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?
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
The first interview is a technical phone interview that assesses your skills in SQL and Python, specifically data analysis with python. The interviewer pastes the description of an SQL problem on the code editor and asks you to write your answer while describing your thought process. They give you hints when you're stuck.
Interview questions [1]
Question 1
Could you tell me the steps involved in the data analysis process?