I got a message from Amazon recruiter on LinkedIn. I was interested to give a try and attended the first telephonic interview. Call started directly with a code edit kind of screen share platform and started with simple SQL questions and ended up with complex. Questions around performance tuning, DWH, Data modeling, Normalization concepts, RDBMS etc. Call lasted for 1 hour. I answered almost all questions. I got an email from HR team after 3 days to attend On-Site interview at Seattle,WA. Went to Seattle and a day full of interviews. Had to meet 8 persons in total. Full of white board sessions - 3 rounds of Technical interview - again mostly around Data Modeling, Complex SQL queries, RDBMS, Performance tuning, Little bit of programming Shell scripting etc. 2 rounds of behavioral interview - more of scenario based questions and my reactions to the same. 1 HR casual round. 1 person to meet at lunch who was Head of the BU. Overall the day was too tiring. The whole day went fine as per my knowledge, with some issues in Data Modeling. I didn't get an email/call yet, hence thinking I have not been selected for that role. All the best guys, Hope this helps.
