I applied through a recruiter. I interviewed at Amazon in Jun 2020
Interview
Technical round - with live SQL coding using Amazon's chime and screen-share.
Followed by behavioral + technical
Followed by 5 round of behavioral and conceptual round.
Interviewer was good and helpful.
Interview questions [1]
Question 1
Schemas -
Sales (sales_id, date , customer_id, Product_id, purchase_amount):
Product (P_id, P_Name, Brand_id,B_name)
Top 10 products in year XXXX
Top 10 products in each year
List of customers whose total purchase increased from XXXX-XXXX but decreased from XXXX-XXXX.
List of customers who bought both brands "X" & "Y" and at-least 2 products in each brand.
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
Top companies for "Compensation and Benefits" near you
