I applied through a recruiter. The process took 2 weeks. I interviewed at Amazon (Bengaluru) in Feb 2017
Interview
Headhunter reached out to me with the vacancy. Submitted CV. Amazon then took a long time to shortlist the CV. However, once that was done the process then was done within 2 weeks including presenting the final offer. The interview was a mix of skill-based(mostly SQL, bit of Statistics), resume-based(lot of relevant experience)and Behavioral. I had 6 rounds of interviews, including 2 telephonic - one screening & one final interview.
Interview questions [1]
Question 1
Optimize SQL Queries?
Find Primary Key on a Table?
Lead & Lag without using those functions?
De-duplicate data on SAS vs SQL?
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
