I have interview with Amazon for data engineer in two weeks. I was interviewed for sde and they referred me to data engineer role. they wont interview me on data structures and algorithms for next round. Interviews would be on data engineering concepts like desiging etl workflows, understading db concepts, architecture, performance, sql, scripting, data modelling, trade offs, de normalization, etc. My question is there some place I can go to for this prep? like leetcode for data structures and algos? Any help?
Data Engineering and Architecture are something that you wouldn’t find on leetcode kind of sites. Data space is vast like you’ve accurately called out in your original post. What’s the exact job title that you would be hired for? That would tell you something to reduce the scope of the subject. Worst case, I would read basics - OLTP, OLAP, 1st, 2nd, 3rd normal forms, why and where you would use them, Datawarehouse basics, Kimbal modeling concepts, RDS best practices, Redshift best practices, Glue details, best practices, DMS concepts n best practices, data pipeline concepts n best practices, any ETL tool like Talend/Informatica concepts and hands on knowledge. Or data pipelines using airflow/python...etc
Its for Data Engineer role.
Basic SQL and some datawarehousing jargons are more than enough! Just prepare yourself strongly on LP, that’s what matters...once you get the offer, you will write shitty SQL trust me on this 😋
What is LP?
Leadership principles
What’s your YOE of experience and background ? Have some interviews for same role coming up !
I have 2.5 years of experience building etl pipelines using hadoop. I will try for another set of interviews
Did you complete your interview , how was that ? Can you please share your experience
Not yet. I will reply once interview is done
One round in leadership principles. Second round: data modeling questions like design tables in star schema. And Normal forms. One java data structure question. One sql question. Third round: two leadership principle questions, two sql questions I didn’t get the job.
For SQL you can use Leetcode and also Hackerrank (I actually think Hackerrank is better for the longer tougher SQL questions). Do some data modelling design mock ups à la system design, how do I build a transactional DB for an online store, how about a data warehouse, etc, then expand to other business cases (a social media app, a marketplace, etc).