Amazon Business Analyst Interview Questions and Answers for Experienced

Q1. What is second highest Salary
Add your answer

Q1. Questions based on Leadership principles
Add your answer

Analyzing data For insights ?
business analytics skills
Prioritizing task in fast paced environment ?

Handling incomplete data

Python ,SQL, PowerBi

General language test

SQL skills test to measure handson approach

Q1. Why do you want to move to IT Services?
Add your answer
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.
Answered by AI
Add your answer
Q3. Tell me something that is not in the resume but relevant to your applied role?
Add your answer

Q1. Tell me about a situation when you had to disagree with your manager on a task and how did you handle it?
Add your answer
Q2. Tell me about a situation when you went above and beyond to assist a customer and what was the outcome?
Add your answer

Q1. When statements based questions
Add your answer
Q2. Use of case in SQL why and when we use it.
Ans. 
CASE in SQL is used to apply conditional logic to queries and manipulate data based on specific conditions.
• CASE is used to create conditional expressions in SQL

• It allows for the manipulation of data based on specific conditions

• CASE can be used in SELECT, WHERE, and ORDER BY clauses

• It can be used to create calculated fields or to filter data based on specific criteria

• CASE can also be used in conjunction with aggregate f...read more
Answered by AI
Add your answer
Q3. How to merge queries to get result in one got perform a query for that.
Add your answer

The coding topics include SQL problems and query optimization techniques.