The process took 1+ week. I interviewed at Amazon (Seattle, WA)
Interview
3 rounds of phone screens. First was simple phone screen, last 2 were behavioral and small case questions. No technical or sql test.
Received an offer 1 week after final round of interview. Whole process took less than a week
Interview questions [1]
Question 1
Explain to me why the prime student discount is a good system
I applied through an employee referral. I interviewed at Amazon (Seattle, WA) in Jun 2017
Interview
Well, I got referred by one of my friend and my resume got picked. HR reached out to me saying that he would call me and talk to me about the job role. After that I had two phone calls, one of which was purely SQL, EXCEL and few data mining related questions, and the other call was mostly data driven, behavioral, case studies. These three rounds ( including HR call) took about a month to complete. Well, thats a loooong time and I was already stressed out. But I had another offer by that time, which wanted me to start working ASAP and I did inform the HR about my situation and they fast forwarded my process. HR reached out to me on the same day I finished my third call and told me that they would call me onsite. The same week I was called to the office. Yes, they did take care of me in every which way(Hotel, transport, food and miscellaneous)
Onsite, like everybody else I was nervous but you know what? DON'T BE. The interviewers are gonna make you feel as comfortable as possible. HR had already given me the list of interviewers whom I looked up on linkedIn and had prepared myself for. The interviews over the phone are already your filter in for the company. So, you have to go beyond your capabilities to spoil the onsite interview. By which I mean, Onsite interviews are pretty chill and not really that scary. It's the same you know. They just want to know how you handle the stress because Amazon is HUGE. They have crazy loads of work and they are judging you on how calm and how can you manage yourself in a situation put like that AND that's why they have 5 to 6 back to back interview round onsite. (Behavioral, SQL, your projects, data driven, Case studies)
Don't don't forget to go through Amazon Leadership Skills, its EVERYTHING. Answer your questions through STAR methodology. Build a situation for yourself for every question asked and answer it like a story.
Trust me, people say if you know how to talk you can kill the interview but you need to have context to talk. Too much is also way too much sometimes. Answer for what is asked and don't try to outsmart the people who are interviewing. Keep calm, get yourself some water and keep drinking it. IT WORKS.
Be positive. And, All the best :)
Interview questions [1]
Question 1
SQL- Joins, Group by, order by, Index, Normalization, RAID. Excel - Pivot, Lookups
I applied online. I interviewed at Amazon (New York, NY) in Jun 2017
Interview
Applied online, reached out by recruiter a week later, followed by 1 hour recruiter call, then another 1 hour call from HM two weeks later, then another 1 hour call from another team member a week later, followed by an onsite interview two weeks later. They offered 3 business days after onsite interview