J'ai postulé via un recruteur. Le processus a pris 2 semaines. J'ai passé un entretien chez Amazon (Seattle, WA) en sept. 2022
Entretien
The recruiter reached out through LinkedIn and scheduled the first interview with him.
After being approved in this first step, he sent me an email with instructions for the SQL + 2 leadership principles interview.
The process was online through Amazon Chime and with the camera off.
A lot of behavioral questions to be answered with STAR Method.
Questions d'entretien [1]
Question 1
First Interview (With the recruiter):
- Ask to pass through my resume.
- How I get requirements, with which frequency, and what I ask for.
- Size of the data I'm used to work.
- Estathistical knowledge I used and scripting language (Python, R)
- How to use lead and lag function and aggregations functions.
- A time when I worked with a business area, who are they, what was the problem, what was the solution, and which was the quantitative result.
- A time when I had to dive deep to discover the root cause of a problem.
Second Interview (SQL + Leadership Principles):
- When I reached a goal, and exceed it.
-When I delivered a project under a tight timeline.
- When I got negative feedback and what I did with it
- Three things that I do to improve my overall effectiveness.
- Amazon wants to flag clients who bought Alexas and Books to send them campaigns to the next Kindle version. What I expected to find in terms of data (which tables and which fields). Then I had to use those tables and create a query to bring the client_id of those clients.
J'ai passé un entretien chez Amazon (Los Angeles, CA)
Entretien
Interview focused on analytical thinking and case studies. Main focus was on the leadership principles. First interview was a phone interview that covered a few basic questions and SQL coding. The loop had 4 rounds.
Questions d'entretien [1]
Question 1
What is the difference between inner and left join?
J'ai postulé en ligne. J'ai passé un entretien chez Amazon
Entretien
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.
Questions d'entretien [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