Add office photos
Engaged Employer
i
This company page is being actively managed by
Amazon Team. If you also belong to the team, you
can get access from
here
Amazon
CompareProud winner of ABECA 2024 - AmbitionBox Employee Choice Awards
Filter interviews by
Amazon Business Analyst Interview Questions, Process, and Tips
Updated
20 Dec 2024
Top Amazon Business Analyst Interview Questions and Answers
- Q1. Use of case in SQL why and when we use it.
- Q2. Do you have knowledge on Aspect WFO and SQL?
- Q3. complex SQL query - using Window Function, Date and Time
49 Amazon Business Analyst Interview Experiences
92 questions found
Sort by:
Popular
Anonymous
I applied via Job Portal and was interviewed in Jul 2022.
1 Interview Round
1
Technical Round (3 Questions)
- Q1. When statements based questions Add Answer
- Q2. Use of case in SQL why and when we use it. View Answers (1)
- Q3. How to merge queries to get result in one got perform a query for that. Add Answer
Interview Preparation Tips
Interview preparation tips for other job seekers - If you’re preparing for business analyst must go through the complex SQL queries and deep dive in case and scenario based question.
Skills evaluated in this interview
Interview experience
Good
Difficulty level
Hard
Duration
4-6 weeks
Result
Not Selected
I applied via LinkedIn and was interviewed in Sep 2024.
1 Interview Round
1
Coding Test Round
SQL queries - 3. Was asked to write on notepad using the table structure given by interviewer
Interview Preparation Tips
Topics to prepare for Amazon Business Analyst interview:
- Hackerrank
- Stratascratch
- Leetcode
Get interview-ready with top interview questions
Interview experience
Good
Difficulty level
-
Duration
-
Result
-
2 Interview Rounds
1
Technical Round (1 Question)
- Q1. Different joins in sql View Answers (1)
2
Behavioral Round (1 Question)
- Q1. Something you have done beyond your duty in your previous job. Add Answer
Skills evaluated in this interview
What people are saying about Amazon
View All
luxuriantquagga
works at
Network Techlab
Loking For A Job Referrals
Hello all,
I am having difficulty connecting with people for jobs, have applied at Amazon, Deloitte, Wells Fargo, CITI etc via career page but it's been months and no response.
And can't find much on Linkedin. I would really appreciate it if you guys can share any consultancy numbers based in Mumbai or their emails or if you can let me know about any vacancies in your company.
I have worked in Icogz for 1 year 10 months as a Junior Python Developer, then I am recently working in Network Tech Lab as Software Engineer (Python) for 6 months.
I have a total of 2.4 years of experience. My current CTC is 3 lpa.
Complete graduation From Viva College Mumbai University.
I live in Mumbai.( If that helps?)
Got a question about Amazon?
Ask anonymously on communities.
Interview experience
Average
Difficulty level
-
Duration
-
Result
-
1 Interview Round
1
Technical Round (2 Questions)
- Q1. Excel Test which had Pivot table creation and vlookups and countifs Add Answer
- Q2. Sql Questions based on joins Add Answer
Amazon interview questions for designations
Harmeet Singh
Interview experience
Excellent
Difficulty level
Moderate
Duration
Less than 2 weeks
Result
Selected
I applied via Recruitment Consulltant and was interviewed in Oct 2024.
2 Interview Rounds
1
Assignment Round
3 SQL medium questions
2
One-on-one Round (1 Question)
- Q1. Behavioral questions on managing different situations Add Answer
Ranjani Mk
Interview experience
Excellent
Difficulty level
Moderate
Duration
6-8 weeks
Result
Not Selected
I applied via Recruitment Consulltant and was interviewed in Jun 2024.
1 Interview Round
1
Technical Round (2 Questions)
- Q1. Complex SQL query - using Window Function, Date and Time View Answers (1)
- Q2. Work related projects to be explained using STAR methodology, based on the problem statement. Add Answer
Interview Preparation Tips
Topics to prepare for Amazon Business Analyst interview:
- SQL
Skills evaluated in this interview
Business Analyst Jobs at Amazon
Anushka Agrawal
Interview experience
Good
Difficulty level
-
Duration
-
Result
-
2 Interview Rounds
1
Technical Round (1 Question)
- Q1. LP round to ask about past projects Add Answer
2
Technical Round (2 Questions)
- Q1. SQL round consisting of 5 qs Add Answer
- Q2. Case study on uber Add Answer
Bharath bond
Interview experience
Good
Difficulty level
-
Duration
-
Result
-
2 Interview Rounds
1
Coding Test Round
SQL intermediate questions
2
Technical Round (2 Questions)
- Q1. SQl Joins, union, execution flow Add Answer
- Q2. Window functions, constraints, aggregates. Add Answer
Interview experience
Excellent
Difficulty level
-
Duration
-
Result
-
1 Interview Round
1
Technical Round (1 Question)
- Q1. SQL, Excel related questions Add Answer
Interview experience
Average
Difficulty level
-
Duration
-
Result
-
1 Interview Round
1
Technical Round (2 Questions)
- Q1. Questions based on outer join and then tweaking the use cases. Add Answer
- Q2. Questions based on correlated sub queries. Add Answer
Interview experience
Average
Difficulty level
Moderate
Duration
4-6 weeks
Result
-
I was interviewed in Mar 2024.
5 Interview Rounds
1
Coding Test Round
Sql, Excel MCQ(group by, vlookup, sumif)
2
Technical Round (1 Question)
- Q1. Sql case study(rank, CTE, lag, lead) Add Answer
3
One-on-one Round (1 Question)
- Q1. Principles based scenarios Add Answer
4
One-on-one Round (1 Question)
- Q1. Principles based scenarios Add Answer
5
One-on-one Round (1 Question)
- Q1. Principles based scenarios Add Answer
Amazon Interview FAQs
How many rounds are there in Amazon Business Analyst interview?
Amazon interview process usually has 2-3 rounds. The most common rounds in the Amazon interview process are Technical, One-on-one Round and Coding Test.
How to prepare for Amazon Business Analyst interview?
Go through your CV in detail and study all the technologies mentioned in your CV. Prepare at least two technologies or languages in depth if you are appearing for a technical interview at Amazon. The most common topics and skills that interviewers at Amazon expect are SQL, Business Analysis, Analytics, Data Analytics and Tableau.
What are the top questions asked in Amazon Business Analyst interview?
How long is the Amazon Business Analyst interview process?
The duration of Amazon Business Analyst interview process can vary, but typically it takes about less than 2 weeks to complete.
Tell us how to improve this page.
Amazon Interviews By Designations
- Amazon Software Developer Interview Questions
- Amazon Customer Service Associate Interview Questions
- Amazon Customer Service Executive Interview Questions
- Amazon Transaction Risk Investigator Interview Questions
- Amazon Software Developer Intern Interview Questions
- Amazon Associate Interview Questions
- Amazon Seller Support Associate Interview Questions
- Amazon Software Engineer Interview Questions
- Show more
Interview Process at Amazon Business Analyst
based on 30 interviews in last 1 year
3 Interview rounds
- Technical Round
- One-on-one Round
- HR Round
View more
People are getting interviews through
based on 38 Amazon interviews
Job Portal
Company Website
Referral
Campus Placement
WalkIn
Recruitment Consultant
29%
26%
13%
11%
3%
3%
15% candidates got the interview through other sources.
High
Confidence
?
High Confidence means the data is based on a large number of responses received from the candidates.
Business Analyst Interview Questions from Similar Companies
Fast track your campus placements
42%
more
than the average Business Analyst Salary in India
View more details
Amazon Business Analyst Reviews and Ratings
based on 119 reviews
Rating in categories
Amazon - Business Analyst - Transportation Team (4-10 yrs)
4-10 Yrs
₹ 13-24 LPA
Amazon - Business Analyst (4-12 yrs)
4-12 Yrs
₹ 20-30 LPA
Amazon - Business Analyst (6-10 yrs)
6-10 Yrs
₹ 30-40 LPA
|
Customer Service Associate
4.2k
salaries
|  ₹1 L/yr - ₹5 L/yr |
|
Transaction Risk Investigator
3.1k
salaries
| ₹2.4 L/yr - ₹6.5 L/yr |
|
Associate
2.6k
salaries
| ₹0.8 L/yr - ₹6.5 L/yr |
|
Senior Associate
2.4k
salaries
| ₹1.8 L/yr - ₹10 L/yr |
|
Software Development Engineer
2k
salaries
| ₹18.6 L/yr - ₹33.3 L/yr |
Explore more salaries
Compare Amazon with
Flipkart
Compare
TCS
Compare
Compare
Netflix
Compare
Calculate your in-hand salary
Confused about how your in-hand salary is calculated? Enter your annual salary (CTC) and
get your in-hand salary
Did you find this page helpful?
Yes No
- Home >
- Interviews >
- Amazon Interview Questions >
- Amazon Business Analyst Interview Questions
Share an Interview