Top 24
Prep plan
Updated weekly · Last refresh Oct 17

Amazon Data Engineer Interview Questions

The questions to prepare for a Amazon Data Engineer interview. Questions from real interview reports rank first. Updated daily.

24questions
~5htotal time
Track your progressSign up free to work through all 24 questions and resume where you left off.
Start practicing free →
1
CodingStart here. 7 questions · ~85 min
Rolling Averages and OutliersHard
Practice
Recently asked

Use a deque and running statistics to calculate rolling telemetry averages and detect outliers in linear time.

Data AnalysisstatisticsAmazon
Validate Nested BracketsEasy
Practice
Recently asked

Validate nested API payload brackets using a stack and matching-pair lookup in linear time.

StackStringsAmazon
PySpark Data Processing FunctionsMedium
Practice
Recently asked

Aggregate numeric record values by user with a single-pass dictionary, matching a common PySpark groupBy transformation.

pysparkaggregationCodingAmazon
More Coding questions with a free account
2
SQL & Data Manipulation5 questions + 2 drills · ~81 min
Normalize to Third Normal FormHard
Practice
Recently asked

Analyze normalization levels and decompose a denormalized transaction table into customer, product, and sales relations in 3NF.

sql querynormalizationdatabase designAmazon
Deduplicate with CTEsMedium
Recently asked

Tests ability to write advanced SQL for deduplication and correct aggregation logic.

CTEsAmazon
Second-Highest Purchase by RegionMedium
Recently asked

Evaluates window function proficiency for ranking and per-group top-N retrieval.

Window Functionssql queryAmazon
Rolling 7-Day Metric With WindowsMedium
Practice
Recently asked
Practice drill

Rank Amazon seller categories by completed revenue using joins, aggregation, and DENSE_RANK().

Window FunctionsData AnalysissqlAmazon
Window Functions for Purchase RankingsMedium
Practice
Recently asked
Practice drill

Use CTEs and window functions to calculate monthly running purchase averages and rank Amazon users by completed purchase frequency.

Window FunctionsData AnalysissqlAmazon
More SQL & Data Manipulation questions with a free account
3
Behavioral & Leadership10 questions · ~121 min
More Behavioral & Leadership questions with a free account
4
More topics2 questions · ~24 min
Data Cleaning and CodingHard
Recently asked

Describe your coding experience and explain how you identify, clean, validate, and monitor unreliable data in production pipelines.

Data Qualitydata pipelineCodingAmazon
Real-Time Processing with PipelinesHard
Recently asked

Explain how you design, operate, and recover real-time data pipelines with reliable processing, quality checks, and low latency.

Data Qualityevent processingdata pipelinesAmazon

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 24 questions plus 2 hands-on drills to finish this plan.