I applied online. The process took 3 weeks. I interviewed at Amazon in May 2022
Interview
Straightforward interview:
- behavioral with 4 employees (not necessarily on hiring team). key is to know the leadership principles and show with examples from projects you've worked on via STAR method.
- technical interview is just SQL based
Interview questions [1]
Question 1
What was a challenge you had at work that you couldn't solve?
I applied online. The process took 4 weeks. I interviewed at Amazon (Pittsburgh, PA) in Nov 2023
Interview
I had 2 rounds of 1-hour back to back interviews. The interview included 5 to 7 easy-medium levels of SQL questions, and then follow up with 3 behavioral questions. Interviewers are very patient and friendly during the entire process.
HR phone screen, first round SQL + 2 LPs, final round five back-to-back including SQL, Business Acumen, Visualization, and LPs. Among all five, there is one bar raiser who will ask very detail about the story you have.
Interview questions [1]
Question 1
SQL Window Function, using rank() and difference between row_number, rank, and dense_rank,