I applied online. The process took 1 day. I interviewed at Amazon (München, Bavaria) in Mar 2021
Interview
Interview Process Phone call (chime app) for an hour and was purely on SQL, 1 Q on Data Warehouse and 1 LP question(Deep Dive). The interviewer wasn't clear about the outcome/answers he/she needed.
Interview questions [1]
Question 1
Q1) two tables, orders and order items.
Orders:
(PK: ORDER_ID)
ORDER_ID | ORDER_DATE | CUSTOMER_ID
xyz 1/1/2019 person_a
zzz 1/1/2019 person_b
... ... ...
Order_items:
(PK: ORDER_ID, ITEM_ID)
ORDER_ID | ITEM_ID | QUANTITY
xyz asin1 2
xyz asin2 1
zzz asin1 3
zzz asin3 2
zzz asin5 1
... ... ...
a. date with the greatest number of orders
b. by day, the cumulative sum of quantity
c.customers who placed orders on 2 consecutive days both days having greater than 2 order QUANTITY
Q2) Routes question: Given a table with a combination of flight paths, how would you identify unique flights whichever city is the destination or arrival location.
FROM | TO | DIST
SEA SF 300
CHI SEA 2000
SF SEA 300
SEA CHI 2000
SEA LND 500
LND SEA 500
Q3) Sign on, sign off question:
You have a table as follows:
Agent_ID | Event | dateTimestamp
a sign in 9am
a sign out 10:02am
a sign in 10:15am (took a break)
a sign in 12am
a sign in 13pm
a sign off 19pm
a sign in 22 pm
a sign out 22:15 pm
How would you approach writing a query which would calculate the duration in which agents were signed on during the day?. Do not include Break timings
Outcome:
A 1st jan 21 xxx hrs
Q4). Can you give me a data model which will help answer the following questions. No SQL queries just the data model.
a. Top grossing movie last year?
b. All movies which starred Brad Pitt.
c. Every actor which Bradd Pitt has worked with.
d. Top Movies (star rating) for 2019?
Q5) Deep Dive. Tell me one scenario where you found some gaps in your work which impacted a huge impact to the business/clients. How did you drill-through during that scenario?
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?
