I applied through a recruiter. The process took 1+ week. I interviewed at Amazon (Hyderabad) in Jul 2017
Interview
4 rounds of interviews after screening round over email. All the 4 rounds were done a single day where we had a multiple people invited for interview and had an interview panel similar to hiring day ( full day interviews for the panel )
I applied through a recruiter. I interviewed at Amazon (Seattle, WA) in Mar 2020
Interview
I got contacted by a recruiter who explained the process, team, potential compensation, etc. I had a phone screen later that week with a few easy SQL questions. I was then passed off to another recruiter to talk about the full loop.
The full loop was all behavioral until the last one, which was another SQL interview by a BIE. The first interviewer asked a bunch about paralellism which I didn't have experience in. Most people were friendly but it was fairly repetitive.
I got a call back saying they liked me for Amazon but they filled that position with someone else. They asked if I wanted to do an accelerated process with a different group and I said yes. Then I never heard from either of the original recruiters again. Since then I've been pinged by 4 different recruiters who have also ghosted me as soon as I reply. There seems to be no internal communication whatsoever.
Interview questions [1]
Question 1
SQL question about aggregating a running total of the week's sales by business group.
The recruiter explains the process in the first call. Then I had a phone interview and I was asked to prepare for python and sql for data manipulation, data modelling and leadership questions.
The phone interview was fairly straight forward. I was asked about work-related behavioural questions for the first half and later I was asked questions based on SQL queries.
Interview questions [1]
Question 1
Orders, Orderdetail, product and customer tables. Things one needs to remember are how to check case sensitive data, aggregates, ddl and dml statements, and window functions. These should be good points to remember.