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
Selected
I applied via Company Website and was interviewed before Aug 2022. There were 3 interview rounds.
(3 Questions)
- Q1. Why do you want to move to IT Services?
- Q2. Do you have knowledge on Aspect WFO and SQL?
- Ans.
Yes, I have knowledge on Aspect WFO and SQL.
I have experience working with Aspect Workforce Optimization (WFO) software.
I am proficient in writing and executing SQL queries for data analysis and reporting.
I have used SQL to extract and manipulate data from databases for business analysis purposes.
- Q3. Tell me something that is not in the resume but relevant to your applied role?
(2 Questions)
- Q1. Tell me about a situation when you had to disagree with your manager on a task and how did you handle it?
- Q2. Tell me about a situation when you went above and beyond to assist a customer and what was the outcome?
Interview Preparation Tips
Skills evaluated in this interview
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
What people are saying about Amazon
(2 Questions)
- Q1. Excel Test which had Pivot table creation and vlookups and countifs
- Q2. Sql Questions based on joins
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
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 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
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.2k
salaries
|  ₹0.6 L/yr - ₹5 L/yr |
|
Transaction Risk Investigator
3.1k
salaries
| ₹2.5 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
| ₹19.1 L/yr - ₹33 L/yr |
Flipkart
TCS
Netflix
Calculate your in-hand salary
- Home >
- Interviews >
- Amazon Interview Questions >
- Amazon Business Analyst Interview Questions
