I applied online. I interviewed at Amazon in Mar 2021
Interview
Usually first step is a call with recruiter but they wanted to expedite the interview process do they directly conducted a technical and behavioral round together. 5 SQL and 2 Python questions on their 'LiveCode'. The interviewer held on to a specific experience and kept revolving around it. Now, All the LPs would not apply to all of your projects, obviously. But in my case, I guess the interviewer assumed that and I didn't go to another round. I wouldn't apply again to Amazon. They expedite the process and only on person gets to judge you.
Interview questions [1]
Question 1
1. Which JOIN, why?
2. foreign key relationship explain.
3. one easy leetcode SQL problem.
4. two medium leetcode SQL problem.
5. 2 python questions (string comparison, csv manipulation)
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