Amazon Data Engineer II interview questions

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.

I had the privilege of visiting Amazon multiple times as the company wanted to test my skill sets and technical abilities for various positions (I guess) . After each round, I got the same response saying "Well you are not selected, but maybe you can fit into a different position". This means that I had to go through the entire grueling process of attending 7 more interviews for every position. Of this entire process, the last set of interviews were the worst of all. The interviewers did not keep up to the time (every interview exceeded), they did not give me an opportunity to even ask them a single question and they did not even discuss the answers with me. They just shut me off saying it was wrong.All of these interviews really made me feel, "Can I really work in this sort of an environment where people don't even have the patience to listen to you?". To summarize, the interviewers were rude, unprofessional and wanted to listen to only answers they have already written down. A very uncoordinated effort to just call interviewees onsite and tire them rigorously.