Add office photos
i
Amazon
CompareProud winner of ABECA 2024 - AmbitionBox Employee Choice Awards
Filter interviews by
Amazon Business Analyst Interview Questions, Process, and Tips
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
Amazon Business Analyst Interview Experiences
49 interviews found
Anonymous
I applied via Company Website and was interviewed before Oct 2021. There were 4 interview rounds.
There is one OA after your interview shortlisted based on your domain or profile.
(1 Question)
- Q1. 2 technical interview will be there both are elimination round.interview related to your field.
(1 Question)
- Q1. Before HR there is team round for which you are going to be hired after that there is final HR round.
Interview Preparation Tips
I applied via LinkedIn and was interviewed in Sep 2024. There was 1 interview round.
SQL queries - 3. Was asked to write on notepad using the table structure given by interviewer
Interview Preparation Tips
- Hackerrank
- Stratascratch
- Leetcode
(1 Question)
- Q1. Different joins in sql
- Ans.
Different types of joins in SQL include inner join, left join, right join, and full outer join.
Inner join: Returns rows when there is a match in both tables
Left join: Returns all rows from the left table and the matched rows from the right table
Right join: Returns all rows from the right table and the matched rows from the left table
Full outer join: Returns all rows when there is a match in either table
(1 Question)
- Q1. Something you have done beyond your duty in your previous job.
Skills evaluated in this interview
(2 Questions)
- Q1. Excel Test which had Pivot table creation and vlookups and countifs
- Q2. Sql Questions based on joins
Amazon interview questions for designations
Harmeet Singh
Selected
I applied via Recruitment Consulltant and was interviewed in Oct 2024. There were 2 interview rounds.
3 SQL medium questions
(1 Question)
- Q1. Behavioral questions on managing different situations
Get interview-ready with Top Amazon Interview Questions
Ranjani Mk
I applied via Recruitment Consulltant and was interviewed in Jun 2024. There was 1 interview round.
(2 Questions)
- Q1. Complex SQL query - using Window Function, Date and Time
- Ans.
Using Window Function, Date and Time in a complex SQL query
Use ROW_NUMBER() to assign a unique number to each row within a partition
Use PARTITION BY to divide the result set into partitions
Use ORDER BY to specify the order of rows within each partition
Utilize functions like LAG(), LEAD(), SUM(), AVG(), etc. within the window frame
- Q2. Work related projects to be explained using STAR methodology, based on the problem statement.
Interview Preparation Tips
- SQL
Skills evaluated in this interview
Business Analyst Jobs at Amazon
Anushka Agrawal
(1 Question)
- Q1. LP round to ask about past projects
(2 Questions)
- Q1. SQL round consisting of 5 qs
- Q2. Case study on uber
Bharath bond
SQL intermediate questions
(2 Questions)
- Q1. SQl Joins, union, execution flow
- Q2. Window functions, constraints, aggregates.
(1 Question)
- Q1. SQL, Excel related questions
(2 Questions)
- Q1. Questions based on outer join and then tweaking the use cases.
- Q2. Questions based on correlated sub queries.
I was interviewed in Mar 2024.
Sql, Excel MCQ(group by, vlookup, sumif)
(1 Question)
- Q1. Sql case study(rank, CTE, lag, lead)
(1 Question)
- Q1. Principles based scenarios
(1 Question)
- Q1. Principles based scenarios
(1 Question)
- Q1. Principles based scenarios
Top trending discussions
Amazon Interview FAQs
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 Transaction Risk Investigator Interview Questions
- Amazon Customer Service Executive 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 Questions for Popular Designations
- Business Development Executive Interview Questions
- Business Development Manager Interview Questions
- Business Development Associate Interview Questions
- Senior Business Analyst Interview Questions
- Business Associate Interview Questions
- Business Development Interview Questions
- Business Manager Interview Questions
- Business Executive Interview Questions
- Show more
Amazon Business Analyst Interview Process
based on 30 interviews in last 1 year
3 Interview rounds
- Technical Round
- One-on-one Round
- HR Round
People are getting interviews through
Business Analyst Interview Questions from Similar Companies
Fast track your campus placements
Amazon Business Analyst Reviews and Ratings
based on 119 reviews
Rating in categories
4-10 Yrs
₹ 25-32 LPA
Bangalore / Bengaluru
2-4 Yrs
₹ 4.5-9.5 LPA
4-10 Yrs
₹ 13-24 LPA
|
Customer Service Associate
4.1k
salaries
|  ₹0.6 L/yr - ₹6 L/yr |
|
Transaction Risk Investigator
3.1k
salaries
| ₹2.3 L/yr - ₹6.5 L/yr |
|
Associate
2.8k
salaries
| ₹0.8 L/yr - ₹6.8 L/yr |
|
Senior Associate
2.4k
salaries
| ₹2 L/yr - ₹10.1 L/yr |
|
Software Development Engineer
2k
salaries
| ₹16.1 L/yr - ₹33.2 L/yr |
Flipkart
TCS
Netflix
Calculate your in-hand salary
- Home >
- Interviews >
- Amazon Interview Questions >
- Amazon Business Analyst Interview Questions
