I applied through an employee referral. The process took 1 day. I interviewed at Amazon (Chennai) in Jul 2014
Interview
5 rounds of interview including one telephonic. first was the phone screen and then once it was cleared, there was onsite interview.There were 2 techinical rounds, one manager round and one bar riser round. Bar riser round is very very important as it checks for the overall personality of the candidate.The interview is based on the leadership principles of Amazon where in every candidate is measured across the leadership principles.
Interview questions [2]
Question 1
Design a data model for calculating the air shipped in packages in Amazon?
I applied through a recruiter. The process took 1 week. I interviewed at Amazon (Seattle, WA) in Mar 2019
Interview
The interviewer didn't use the whiteboard app at all, I was writing queries on pen and paper. He was also typing really loudly the entire time, which basically destroyed my concentration.
The questions were not hard, but when I tried to get any feedback or clarification from him he would just repeat the question over again, and ended the interview abruptly half an hour early before I could even formulate responses...since I was writing on paper.
To be frank, it didn't seem like he was paying attention. I'm sure these guys do thousands of these, but based on the email I got from my recruiter, I was prepared to answer in-depth technical questions on database architecture, internals, and query tuning. This was...not that.
Only one person called for technical round. Ask me to write some queries on white board and ask few questions related to dataware house. Interview should be more of discussion then exam..!
I applied online. The process took 2 days. I interviewed at Amazon (Sydney) in Aug 2018
Interview
At first they take one online assessment. It took around 3 hrs to complete. It was a simulation on real world support environment.
one Phone interview ( Technical )
Interview questions [1]
Question 1
How to generate oracle awr report when you don't access to EM ?