I applied online. The process took 3 months. I interviewed at Amazon (Bellevue, WA) in Nov 2022
Interview
Two back-to-back 45-minute interview rounds with SQL-based questions, Statistics, and Leetcode questions. The second 45 minutes talks about behavioral and Data Modelling questions. The behavioural was situation based as I have to talk about them using the STAR approach while incorporating the leadership principles. You must know the leadership principles and most especially incorporate it when answering questions.
Interview questions [1]
Question 1
Difference Between a Data Lake and a Data Warehouse. Explain how I carryout data modelling from a business question to finding insights
Very difficult process it took me a round 1 month to get back what’s the review for the interview so I think overall it’s bad experience and difficult interview process while it has lot of questions I wa able to answer
Standard three-round process consisting of an online assessment followed by a comprehensive interview loop, where candidates were evaluated across technical skills, problem solving ability, and overall fit for the role.
In my 5th semester, Amazon visited our campus to hire interns for multiple roles, and I was shortlisted for the Data Engineer role.
I cleared the online assessment and attended two technical interviews. The first round focused on coding, while the second round focused on SQL. I faced some challenges in the SQL round, and although I was not selected, the experience helped me identify areas for improvement, especially in advanced SQL concepts