I applied online. The process took 4 weeks. I interviewed at Amazon
Interview
Applied online followed by a quick phone screen with a recruiter. Everything lined up so scheduled a phone screen which went well. It was a typical technical phone screen. Lots of SQL questions and the famous leadership principal questions as well. Got invited to onsite which I thought went well but I guess it didn't since I didn't get an offer. Overall, people were super nice and had a great time. Not sure if I will interview here again though.
Interview questions [1]
Question 1
Multiple behavioral sessions on leadership principals.
I applied through a recruiter. The process took 2 weeks. I interviewed at Amazon (Arlington, VA) in Jun 2021
Interview
First telephonic interview mostly about behavioral questions. I was asked two questions: Explain a situation where you break a status quo. Second Explain a situation where you work on situation, how did you resolve it and what was its impact and cause.
Second Interview was white board three SQL queries all the queries were very simple and basic and 1 python algorithm.
Interview questions [1]
Question 1
Three SQL queries one was to JOIN two tables to pull required results. Second was about Group & Order by. Third was Window query all very simple and basic.
One Python related to write a function to sort an array so it produce only odd numbers.
I applied online. The process took 4 weeks. I interviewed at Amazon in May 2021
Interview
My interview (3 rounds) went well, but I got rejected after the onsite round. The recruiter didn't give any reason for the rejection. I was expecting a positive result.
1st round was more on my resume.
2nd was more technical - leetcode hard sql, data modelling, data warehousing concepts
3rd round (onsite) - 4hours LP, 1 hour for sql (leetcode medium), data warehousing concepts, performance tuning, strategies on how to select a design for data modelling
Interview questions [1]
Question 1
Signed an NDA. suggestion - just go through all the LP they have, and write your own story for each of them