I applied through a recruiter. I interviewed at Amazon in Mar 2021
Interview
I had a technical interview and did not make it further in the process. I received feedback very quickly.
I had a video interview and had to code in real time.
IF i could do the interview all over again i would have describe the problem and how i would solve it instead of trying to code right away
Interview questions [1]
Question 1
Derive customer's account status as of month end for all the months in 2019.
If for given month, there are more than one rows, pick the data from the latest date within the month.
If for given month, there is no data, pick the data from latest date prior to the month
You can use last_day function to get month ending date(Eg: last_day(01/01/2015) = 01/31/2015)
customer_id event_date status credit_limit
1 1/1/2019 C 1000
1 1/5/2019 F 1000
1 3/10/2019 1000
1 3/10/2019 1000
1 8/27/2019 L 1000
2 1/1/2019 L 2000
2 1/5/2019 2500
2 3/10/2019 2500
3 1/1/2019 S 5000
3 1/5/2019 6000
3 3/10/2019 B 5000
4 3/10/2019 B 10000
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?
