Amazon For Business Analyst interview questions

I was interviewed for the Business Analyst Summer Intern position for Herndon, VA AWS office and I managed to answer all the questions neatly as I was well prepared about business oriented questions, Amazon leadership principles and everything mentioned on my resume. It lasted for an hour and towards the end of a call the manager said that It would be great to have in their team and asked questions about how I will commute to work etc. I told her I can relocate. Then she said that I will hear back from the recruiter within 3 business days. I was happy and I was hoping for a good news as It went very smoothly. But after 5 business days I didn't receive any email or call. Then I sent an email asking for a feedback but recruiter never replied on time saying she has been busy with work and bla bla stuff. My job application status was under consideration so I kept sending mails for getting a feedback. Finally after sending around 5-6 emails, I received an email on 16th day saying the already hired somebody else. I am very much disappointed with the way they handled this process and wasted so much of my time. I have heard that Amazon never values their employees from their other employees but now I have actually experienced it by my own. Keeping candidates waiting is the worst thing and major flaw in a recruitment process. I hope the recruitment team reads this feedback and improve their standard. I am aware that handling too many applications is not easy but since they have huge recruitment team, they should know how to handle this. Extremely disappointing. They don't value the applicants at all. Fortune 500 rankings could be misleading sometimes.

Recruiter reached over LinkedIn and interview set up in a week. It was 45 min SQL white-boarding and few min on what I do in current role and what they are expecting. I did poorly, mainly due to my lack of SQL knowledge. But interviewer was good and polite. I knew I blew it though the interviewer mentioned I did good at the end.