Phone screening with HR. Phone call with a BIE in the team, 30mins SQL and Python, 30 mins BQ. Final round with 5 people, only 30 mins technical and business questions, the rest 4.5 hours are all BQ.
Interview questions [1]
Question 1
Tell me about a time when you failed or made a mistake.
First round: several behavior questions with leadership principles and sql live coding problems. It takes 1 hour overall. Make sure you are well prepared for the behavior questions. The sql problems are not that difficult. Leetcode easy to medium.
I applied online. The process took 2 months. I interviewed at Amazon (Seattle, WA) in May 2021
Interview
I applied though Job site. after a week got email to schedule Phone call with Hiring manager. It went well and Virtual on site interview after a month- 5 + hours with 5 different people
Interview questions [1]
Question 1
Initial Interview:
What are the statistical analysis I have done? Examples.
Most challenging work
on site virtual-mostly all Amazon Leadership Principles - but technical section was very specific to the job. like one guy asked Coefficient of correlation and R2 for given sample data. Some of Visualization questions related to retail- like how to show top sellers, How to show top warehouse which do not deliver on time etc.. lot of cross questioning so be prepared . only 2 SQL questions they asked at the very end like 5 mins before the interview would end- I just solved one