I applied through an employee referral. The process took 2 months. I interviewed at Amazon (Seattle, WA) in Nov 2023
Interview
First round: Technical interview with live SQL coding assessment.
Second round: Panel interview with 5 members focusing on both technical skills and behavioral competencies. Among these, one would be bar raiser.
Interview questions [1]
Question 1
What challenges did you face during the analysis process? How did you solve them? What did you learn from the experience? What improvements would you make?
The process consisted of three rounds - a recruiter call, a case study round, and a final behavioral interview. The case study involved analyzing a dataset and presenting recommendations to a panel. Interviewers were professional and asked thoughtful follow-up questions. Feedback was provided within a week of the final round.
Interview questions [1]
Question 1
Walk us through how you would identify the root cause of a 20% drop in user engagement.
I applied through an employee referral. I interviewed at Amazon (Austin, TX)
Interview
The process consisted of a technical and behavioral round. Although the recruiter stated it would cover SQL and behavioral topics, the interview focused entirely on scenario-based and behavioral questions without a live SQL technical assessment. Communication after the interview was poor; the recruiter did not respond to follow-up emails, and an automated rejection notice was sent two days later.
Interview questions [1]
Question 1
They asked me to describe a mistake I made in a past project, how I handled it and what I learned from the experience.
I applied online. I interviewed at Amazon (Hyderābād)
Interview
Easy.
Questions were mostly from sql - Basic to medium level
Topics were Group By, joins, window functions etc.
Basic python knowledge with libraries like pandas, numpy etc. They also ask about projects you have worked on.
Interview questions [1]
Question 1
Questions were mostly from sql - Basic to medium level
Topics were Group By, joins, window functions etc.
Basic python knowledge with libraries like pandas, numpy etc.