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?
Interview focused on analytical thinking and case studies. Main focus was on the leadership principles. First interview was a phone interview that covered a few basic questions and SQL coding. The loop had 4 rounds.
Interview questions [1]
Question 1
What is the difference between inner and left join?
The interview process was smooth and conversational. The interviewer was calmly asking questions about my previous work experiences and listened patiently. He even gave me ample time to frame my answers.
Interview questions [1]
Question 1
1. Tell me about your previous work experience.
2. Asked few SQL questions
few rounds of interviews ranging between technical and conversational. Mostly in the form of " tell a story of time where ..." to show how you relate to amazon LPs
Top companies for "Compensation and Benefits" near you
