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.
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 ?
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..!
