Dataford
Top 28
Prep plan
Updated weekly · Last refresh Aug 30

Amazon Development Center U.S. Data Analyst Interview Questions

The questions to prepare for a Amazon Development Center U.S. Data Analyst interview. Questions from real interview reports rank first. Updated weekly.

28questions
~4htotal time
Track your progressSign up free to work through all 28 questions and resume where you left off.
Start practicing free →
1
SQL & Data ManipulationStart here. 9 questions + 1 drill · ~90 min
7-Day Moving Average of Daily GMVEasy
Practice

Compute daily paid GMV and a 7-day trailing moving average using aggregation + window functions.

Window FunctionsData WranglingTime SeriesAmazon Development Center U.S.
Top Products by Sales RevenueEasy
Practice

Find the top 10 products by total sales revenue using joins, aggregation, and a CTE.

RankingGroup ByAggregationsAmazon Development Center U.S.
Handling Missing Data in SQLEasy

Explain practical SQL techniques for handling NULLs and missing values in product analysis without biasing metrics.

Data WranglingCase WhenAggregationsAmazon Development Center U.S.
Compare User Retention by CohortHard
Practice
Practice drill

Use CTEs, joins, and month-based aggregation to calculate cohort retention over time from signup and activity data.

Window FunctionsDate FunctionsCTEsWorkdayAmazon Development Center U.S.The Sparks Foundation
More SQL & Data Manipulation questions with a free account
2
Metrics5 questions · ~44 min
Metrics for New Product LaunchMedium

Choose a metric hierarchy for a new product launch that covers adoption, customer value, and financial performance.

KPIsLeading IndicatorsDiagnosisAmazon Development Center U.S.
Investigate Metric DropMedium

Tests root-cause analysis using SQL, segmentation, and dashboard interpretation.

SQL & Data ManipulationMetricsDiagnosisAmazon Development Center U.S.
More Metrics questions with a free account

Sign up to see every question

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

Get my prep plan
3
Pipelines3 questions · ~27 min
Data Quality in ETL PipelinesEasy

Approach for maintaining data quality and integrity across ETL pipelines.

IdempotencyData ModelingQualityAmazon Development Center U.S.
Data Warehousing in PipelinesEasy

Explain what a data warehouse is and why it matters in analytics pipelines.

InfrastructureETLData ModelingAmazon Development Center U.S.
More Pipelines questions with a free account
4
Behavioral & Leadership10 questions · ~89 min
More Behavioral & Leadership questions with a free account
5
More topics1 question · ~9 min
Most Useful Statistical MethodsMedium

Tests statistical reasoning and ability to choose methods for business questions.

RegressionHypothesis TestingAmazon Development Center U.S.
The finish line: interview-readyComplete all 28 questions plus 1 hands-on drill to finish this plan.