Ho presentato la mia candidatura tramite un selezionatore. La procedura ha richiesto 4 settimane. Ho sostenuto un colloquio presso Amazon (Seattle, WA) nel mese di gen 2020
Colloquio
Interviewed for the BI engineer role in Seattle. Reached out to a recruiter on LinkedIn after which I had my first phone interview which was a live coding exercise. They were mainly looking for data engineers but calling out BI engineers.
Domande di colloquio [1]
Domanda 1
Q1) Find the number of unique days each employee worked
Emp Id Task Id Start date End date
1 1 Monday Wednesday
1 2 Monday Tuesday
1 3 Friday Friday
2 1 Monday Friday
2 1 Tuesday Wednesday
Hint: Calendar day table or date dimension table
Calendar_day Calendar_day_of_week Calendar_year Calendar_month
1900/01/01 Wednesday (3) 1990 1
Q2) How many customers placed orders every month?
Table 1: Customer
Date customer_id order_id units country
2019/07/01 A 112 5 US
2019/07/02 A 211 4 US
2019/08/02 B 511 4 EU
2019/09/01 C 322 1 JP
2019/09/01 C 322 2 JP
2019/08/05 A 378 6 US
2019/09/10 A 456 7 US
Ho presentato la mia candidatura online. Ho sostenuto un colloquio presso Amazon
Colloquio
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.
Domande di colloquio [1]
Domanda 1
1. Tell me about your previous work experience.
2. Asked few SQL questions
Ho sostenuto un colloquio presso Amazon (Lussemburgo)
Colloquio
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.
Domande di colloquio [1]
Domanda 1
Could you tell me the steps involved in the data analysis process?
