I applied online. The process took 5 months. I interviewed at Amazon (San Francisco, Heredia) in Jan 2022
Interview
1) Phone call:
> They wanted to assess my level of english and some background check questions (if I had worked with SQL, Python, etc)
> 1rst Interview:
They performed some behavioral questions based on Dive Deep and Invent and Simplify (look for example of these questions online).
> Interview loop:
1 -> Interview with Business Intelligence Engineer:
2 -> Interview with Hiring manager
3 -> Interview with Bar raiser
4 -> Interview with team member (QA Manager)
Interview questions [1]
Question 1
> Interview loop:
1 -> Interview with Business Intelligence Engineer - Technical Interview:
They performed some questions in detail for Dive Deep leadership principle (they wanted to know everything: how did I processed data, table names, column names, methods used)
The engineer did a question on how to load a CSV file with python, and also made me resolve two SQL exercises (SELECT-JOIN type queries).
Lastly asked if I had some experience on reporting software (Power BI, Tableu, QuickSight) and how did I rate myself, and the same question but for python.
2 -> Interview with Hiring manager
The manager explained me the business, they then went to perform some leadership questions base on leadership principles (Ownership was one, and I think the other one was Are Right, A lot).
3 -> Interview with Bar raiser
Bar raiser performed some questions based on leadership principles, nothing technical. I think one was Learn and Be Curious and the other one was one between the following principles: Bias for Action, Have Backbone; Disagree and Commit and Owernship.
4 -> Interview with team member (QA Manager)
Leardership questions based on Invent and Simplify and I think the other one was Ownership.
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.
Interview questions [1]
Question 1
What is the difference between inner and left join?
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
