I applied through an employee referral. The process took 2 months. I interviewed at Amazon (Seattle, WA) in Feb 2017
Interview
One informational (coffee) "interview" with hiring manager. Three informational phone calls with people on the team.
Phone interview for technical assessment.
Phone interview for behavioral assessment.
Writing exercise.
Onsite interview in six different sessions. Two sessions were technical while the other 4 were more behavioral and business. All sessions had some focus on Amazon's Leadership Principles as well as customer satisfaction.
Interview questions [1]
Question 1
Being primarily a behavioral interview the questions were primarily focused on questions where I needed to relay situations I had worked through that demonstrate my abilities and knowledge of the leadership principles.
The technical questions were relatively simple regarding setting up SQL statements, creating joins, thinking critically/technically about challenges in extracting data, etc.
Probably the most difficult technical question was during the phone interview when I had to, off the top of my head, tell the interviewer how to write a SQL statement without being able to type or write it out myself. This was only difficult in that all of it had to happen in my head and it included multiple tables, a sub-query, and a union.
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
