I applied online. I interviewed at Amazon (Nashville, TN) in Dec 2020
Interview
Applied to the position through LinkedIn and recruiter reached out in 2 days. Technical phone screen after 2 weeks where I had to write 5 SQL queries and Python code for 2 problems. Behavioral phone screen less than 2 weeks after that where I was asked questions on leadership principles by the hiring manager. 2 days later the recruiter informed me that I was invited to virtual onsite loop. We scheduled it for 3 weeks later. 5 interviews spanned across 2 consecutive days. Each interview was an hour long (50 minutes for interview and remaining 10 for me to ask any questions). All the interviewers were very friendly and nice. They answered all of my questions about the team, role and Amazon in general. My recruiter was excellent throughout the process. A week after the interview I got the offer which I accepted after couple days of negotiations. Technical interviews were mostly medium difficulty for SQL and easy for Python. Leadership principles are very important for all Amazon interviews and one must demonstrate strong competency in these principles to get an offer.
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