I applied online. The process took 1 day. I interviewed at Amazon (Seattle, WA) in Apr 2020
Interview
First got a screening interview reviewing prior experience and explaining the position, responsibilities and skill set. Second interview was focused on Amazon values and Leadership Principles. Third round was for coding. Four questions where made. Three of them where SQL and one coding
Interview questions [4]
Question 1
Q1 How many units were sold yesterday? Output: order_day | units
Q3 How many units were sold in each category that cost less than $20, between $20 and $50, and more than $50? Output: category | units_0_20 | units_20_50 | units_50_plus
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?
