Amazon Web Services Business Analyst Interview Questions

The questions to prepare for a Amazon Web Services Business Analyst interview. Questions from real interview reports rank first. Updated daily.

27questions

~5htotal time

Track your progressSign up free to work through all 27 questions and resume where you left off.

Start practicing free →

SQL & Data ManipulationStart here. 5 questions · ~51 min

Find the Second Highest SalaryMedium

Practice

Find the second highest distinct salary from an employee table, handling duplicate and NULL salary values.

database queryingAggregationsnull values

Amazon Web Services

Employees Missing Building NumberEasy

Practice

Use a LEFT JOIN to find employees in the company who do not have a building number.

Joins

Amazon Web Services

SQL JOIN With Missing ValuesMedium

Practice

Use a JOIN and COALESCE to return related rows while replacing missing values with defaults.

postgresqlnull handlingJoins

Amazon Web Services

Employees Joined This YearEasy

Practice

Find how many employees joined this company during this year. Asked in the Virtual Onsite stage. SQL question asked during interview rounds. Task Write ...

queriesDate FunctionsAggregations

Amazon Web Services

More SQL & Data Manipulation questions with a free account

Behavioral & Leadership19 questions · ~194 min

Motivation for Career ChangeEasy

Tests career motivation, self-awareness, accountability, and alignment with the role.

adaptabilityaccountabilitybehavioral

Amazon Web Services

More Behavioral & Leadership questions with a free account

More topics3 questions · ~31 min

Identify Driver Performance to ImproveMedium

Use delivery productivity benchmarks to identify the driver whose performance offers the greatest improvement opportunity.

product analysisMetricsproduct improvement

Amazon Web Services

NYC Windows EstimationMedium

Recently asked

Estimate the number of windows in New York City using transparent assumptions, segmentation, and sensitivity analysis.

Estimationanalytical thinkingassumptions

Amazon Web Services

Working Effectively in TeamsEasy

Recently asked

Tests collaboration habits and communication practices for cross-functional work at Blue Cross and Blue Shield of North Carolina.

Trade-offsRisk Assessment

Amazon Web Services

Sign up to see every question

Create a free account to unlock this list and practice real interview questions.

Get my prep plan

The finish line: interview-readyComplete all 27 questions to finish this plan.