I applied online. The process took 4 weeks. I interviewed at Amazon
Interview
Round 1: (technical SQL 45 minutes)
Round 2: Phone screen: Behavioral based on Amazon’s LP (35 minutes 1 interview, follow STAR technique and restrict answers under 3 minutes)
Round 3: Exhaustive one (6 interviews, 45 minutes each with 15 minutes break after each round, follow STAR technique and restrict answers under 3 minutes)
Interview questions [1]
Question 1
Round 1: Phone screen: Live code: Asked about basic SQL questions, nothing behavioral (45 minutes, they guide you and keep explaining while writing queries)
1. Basic SQL questions, 2. Queries: basic related to Date, groupby , join
Round 2: Phone screen: Behavioral based on Amazon’s LP (35 minutes 1 interview, follow STAR technique and restrict answers under 3 minutes)
Round 3:
1 technical SQL interview: advanced SQL queries using CASE, sub queries, Joins, complex queries, a short case study, no behavioral
4 interviews based on Amazon's LP (easy and straight forward)
1 general interaction round with team member
The process consisted of three rounds - a recruiter call, a case study round, and a final behavioral interview. The case study involved analyzing a dataset and presenting recommendations to a panel. Interviewers were professional and asked thoughtful follow-up questions. Feedback was provided within a week of the final round.
Interview questions [1]
Question 1
Walk us through how you would identify the root cause of a 20% drop in user engagement.
I applied through an employee referral. I interviewed at Amazon (Austin, TX)
Interview
The process consisted of a technical and behavioral round. Although the recruiter stated it would cover SQL and behavioral topics, the interview focused entirely on scenario-based and behavioral questions without a live SQL technical assessment. Communication after the interview was poor; the recruiter did not respond to follow-up emails, and an automated rejection notice was sent two days later.
Interview questions [1]
Question 1
They asked me to describe a mistake I made in a past project, how I handled it and what I learned from the experience.
I applied online. I interviewed at Amazon (Hyderābād)
Interview
Easy.
Questions were mostly from sql - Basic to medium level
Topics were Group By, joins, window functions etc.
Basic python knowledge with libraries like pandas, numpy etc. They also ask about projects you have worked on.
Interview questions [1]
Question 1
Questions were mostly from sql - Basic to medium level
Topics were Group By, joins, window functions etc.
Basic python knowledge with libraries like pandas, numpy etc.
Business Analyst applicants have rated the interview process at Amazon with 3.2 out of 5 (where 5 is the highest level of difficulty) and assessed their interview experience as 50% positive. To compare, the company-average is 57.5% positive. This is according to Glassdoor user ratings.
Candidates applying for Business Analyst roles take an average of 29 days to get hired, when considering 457 user submitted interviews for this role. To compare, the hiring process at Amazon overall takes an average of 28 days.
Common stages of the interview process at Amazon as a Business Analyst according to 457 Glassdoor interviews include:
Phone interview: 27%
One on one interview: 17%
Skills test: 12%
Presentation: 10%
Group panel interview: 8%
Personality test: 8%
Background check: 6%
IQ intelligence test: 5%
Drug test: 4%
Other: 2%
Here are the most commonly searched roles for interview reports -