J'ai postulé en ligne. Le processus a pris 5 semaines. J'ai passé un entretien chez Amazon (Chicago, IL) en août 2022
Entretien
I applied online in August 2022, the full process lasted 5 weeks.
I was contacted 2 days after my application to schedule a phone screen with the recruiter. This call was very high-level, mostly trying to confirm that I understood the job posting and that I actually had the skills/experience mentioned in my application and resume. We discussed the salary range for the role to confirm it matched my expectations.
Next step was a 1 hour interview with a Senior BIE on the hiring team. The breakdown was 30 minutes of live-coding (SQL only) and 30 minutes of standard behavioral interview questions where they expect answers in STAR format and that your answers tie back to the Amazon leadership principles.
The final round "loop" interviews consisted of 5 1-hour interviews that were a mix of technical of behavioral questions. The technical questions consisted of both live-coding exercises and more case-type questions. There are a TON of behavioral interview questions, and each interviewer was tasked with focusing their questions around 2-3 leadership principles. Toward the 4th and 5th interviews I felt like I hadn't prepared enough examples and did end up reiterating examples I had given to previous interviewers - I would avoid this if possible but as long as you make sure to tailor the examples to the specific question you should be fine.
Be aware - each interviewer will take diligent notes and likely ask you a series of clarifying questions for every example you give. Don't let this throw you off - they just want to make sure they fully understand your experiences and help guide you to the type of information they're looking for.
Questions d'entretien [1]
Question 1
Tell me about a time where you had to choose between multiple solutions to a problem.
Tell me about a time where you went above and beyond for a customer
Have you ever had an experience where you proposed a solution that you faced resistance in implementing?
Have you ever had an experience where you didn't know how to solve a problem?
Say your are ingesting near real-time data from JSON outputs, how would you set up the process to optimize both read and write from your destination table?
Write a SQL query to return the top 2 customers with highest sales volume for each product from a sample dataset/tables
Write a SQL query to return only customers who ordered both Product A and B but not Product C from a sample dataset/tables
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