The interview process was pretty standard. I was interviewed for BIE L5 role. I had a recruiter call, then SQL assessment with 4 SQL questions ranging from easy to hard. Next, a 60 min tech screen with one of the BIE L5s where they asked 5-6 SQL questions, it was basically live coding and 1 LP question. Later on, I was moved onto Final interviews which was a loop of 5 rounds. Started off with tech round in the similar format of my tech screen earlier but with more emphasis on SQL questions and ETL design, the second round was completely LPs, third round was LPs+Business acumen, 4th the HR where she discussed LPs+data viz and tools, last round was bar raiser which is critical for the interview success. That's all. I can't share exact questions due to NDA.
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
