I applied through a recruiter. The process took 2 weeks. I interviewed at Amazon (Hyderabad) in Jul 2016
Interview
The interview process is LONG. Started off with a couple of telephonic rounds. The technical questions weren't too intensive. Just a couple of easy SQL queries in the first round and most questions asked from the resume.The second round was shorter and no problem solving questions were asked. The HR called back after the second interview that I'll have to travel to Hyderabad for the on-site interview. Had 3 interview rounds in a day. The first was a telephonic conversation, the other two were VCs. There were a few technical questions asked in the 2nd and 3rd rounds, but were mostly behavioral questions. Upon return, had another couple of telephonic rounds and again mostly focused on behavioral scenarios. Was informed of selection a day after my last telephonic round, which was the 7th interview in all. The entire process seemed to be a healthy mix of technical knowledge, understanding of the projects mentioned on the resume and behavioral scenarios
Interview questions [1]
Question 1
Describe a situation where you faced rigid timelines and what did you do in that situation
I applied through an employee referral. The process took 3 weeks. I interviewed at Amazon in Jun 2016
Interview
Received email from HR about 3 business days after applying. 2 rounds of phone interviews in total, both technical interviews. Both interviews by their team member/leader, each interview last for 40 mins. The first interview focused on SQL, include PL/SQL and general SQL queries. SQL questions are not hard. Got response in one week to schedule the second phone interview. The second one focused on analysis and modeling. Got rejected email one week after.
Interview questions [1]
Question 1
Why this position?
You have sales data for last 5 years. Predict the monthly sales for 2016. data: order (order_id, order_date, sale_amount)
Tell me a time you give insights beyond the data.
Design a data model for the tennis match. Answer who are the players that played with each other more than once. And who is the best/worst player?
You did an analysis, your client thinks the result is not right. What to do?
I applied through an employee referral. The process took 2 weeks. I interviewed at Amazon (Seattle, WA) in Jan 2016
Interview
Got a referral and got called for the first first phone call (SQL) and moved on to a second phone call (statistics questions) before an on site. On site had 4 rounds or 1 hour each.
Interview questions [1]
Question 1
SQL coding on the board, basic statistics questions, behavioral questions