Amazon Data Scientist interview questions

A very, very long process. 2 phone screeners, in the space of 3 weeks 1 resume based(I had relevant experience) and the other had a coding component(I was given the option of SQL, SAS, R and Python) and a Market entry case. After this stage, I had to wait a 6 weeks before I got a call for an onsite interview. Onsite, I had 6 back to back interviews. Each interview tested at least 1 leadership principle and also tested problem solving skills. The first interview had a really simple case question that I royally messed up with complicated thinking(I am almost certain that this cost me). The second interview had SQL. My lunch interview went a little awkward because my interviewer decided to throw a probability based puzzle out of the blue in the last 5 minutes and I couldn't solve it in time. Post lunch, everything went quite smooth, I was asked a forecasting based case, about Holt-winters method and ARIMA. 3 days after interviewing, I got a call where the HR started off by saying "The team really liked your background and experience and were impressed by you BUT, have decided to not move ahead" When I asked for feedback, there was none given to her. So after around 9 weeks in the process, felt a tad devastated to get a reject, I had invested a lot of time and preparation for Amazon.

A recruiter saw my resume on Linkedin and they contact me. They sent over SQL and Probability Assessment Test to complete . The recruiter told me they won't ask me questions on SQL and Probability if you complete the assessment Test. When the interview process started I told the interviewer that I completed the Assessment Test so am not expecting any questions from SQL and Probability. Unfortunately the interviewer did not listen and the entire interview questions was on SQL and Probability. No questions on Data Science which I prepared for. I was very disappointed in the process. After 48 hours the recruiter sent an email saying they even though I did well in the interview they decided to proceed with other candidates. I could have even spent all my time on SQL and Probability if I knew thats what they were going to do, I smell something bad with the interview process.