I applied online. The process took 2 months. I interviewed at Amazon (Pittsburgh, PA) in Mar 2016
Interview
Two phone calls, two of them very technical.
First some SQL questions. I did OK on those: joins, basic normalization.
Then some datamart modelling: fact tables and dimension. Also describe the whole ETL process and rational behind the design decisions.
Also resume check and some leadership questions.
Then onsite interview.
Interview questions [1]
Question 1
SQL, Datamart modelling, statistics (confidence, hypothesis tests). Also leadership principles and some questions about that: tell me about a time when you didn`t meet a date, or when you failed on a goal.
Interview focused on analytical thinking and case studies. Main focus was on the leadership principles. First interview was a phone interview that covered a few basic questions and SQL coding. The loop had 4 rounds.
Interview questions [1]
Question 1
What is the difference between inner and left join?
The interview process was smooth and conversational. The interviewer was calmly asking questions about my previous work experiences and listened patiently. He even gave me ample time to frame my answers.
Interview questions [1]
Question 1
1. Tell me about your previous work experience.
2. Asked few SQL questions
few rounds of interviews ranging between technical and conversational. Mostly in the form of " tell a story of time where ..." to show how you relate to amazon LPs
Top companies for "Compensation and Benefits" near you
