Business Intelligence Engineer applicants have rated the interview process at Amazon with 3.5 out of 5 (where 5 is the highest level of difficulty) and assessed their interview experience as 100% positive. To compare, the company-average is 59.7% positive. This is according to Glassdoor user ratings.
Candidates applying for Business Intelligence Engineer roles take an average of 14 days to get hired, when considering 2 user submitted interviews for this role. To compare, the hiring process at Amazon overall takes an average of 29 days.
Common stages of the interview process at Amazon as a Business Intelligence Engineer according to 2 Glassdoor interviews include:
Skills test: 29%
One on one interview: 29%
Phone interview: 14%
Personality test: 14%
Background check: 14%
Here are the most commonly searched roles for interview reports -
I applied through a recruiter. The process took 1 day. I interviewed at Amazon (Bengaluru) in Jul 2022
Interview
The questions were related to SQL, Python and behavioral analysis. There were 4 rounds. 3 rounds of technical and behavioral analysis and 1 round of complete behavioral analysis question. Answer to be given in STAR pattern for behavioral questions.
Interview questions [1]
Question 1
From SQL:
1. If there are 2 tables with m and n rows respectively, then what will be the minimum and maximum number of rows in all the joins.
2. Get the 3rd highest employee salary from employee salary table.
3. Given a product table, the new record gets appended in table with the new timestamp for the product ID. Find out the latest row for that particular product with or without analytical functions.
4. Given there are 2 tables of employee details and employee project details, which all employee are not yet assigned a project.
For python:
1. Given a product data frame, the new record gets appended in table with the new timestamp for the product ID. Find out the latest data frame for that particular product with pandas.
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