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

Amazon Development Center U.S. Data Engineer Interview Questions

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

26questions
~4htotal time
Track your progressSign up free to work through all 26 questions and resume where you left off.
Start practicing free →
1
CodingStart here. 6 questions · ~56 min
Two Sum with TargetEasy
Practice

Use a hash map to find two array elements that sum to a target in O(n) time.

Hash TablesArraysStringsAmazon Development Center U.S.
Reverse List or Detect CycleMedium
Practice

Detect a linked-list cycle with Floyd's algorithm, then reverse the list in place when it is acyclic.

Linked ListsData StructuresAmazon Development Center U.S.
Parse Logs and Rank ErrorsMedium

Tests your ability to process large text data and produce ranked aggregates efficiently.

Hash TablesStringsHeapAmazon Development Center U.S.
More Coding questions with a free account
2
SQL & Data Manipulation7 questions + 3 drills · ~96 min
Star vs Snowflake for Sales AnalyticsMedium

Compare star and snowflake schemas for warehouse design, including trade-offs in normalization, query simplicity, and analytics performance.

JoinsData WranglingGroup ByAmazon Development Center U.S.
Optimize Partitioned Table ScanHard

Tests performance troubleshooting and optimization strategies for partitioned data.

Performance TuningDate FunctionsperformanceAmazon Development Center U.S.
Hierarchical Data ModelingMedium

Tests your ability to choose and implement a data model for hierarchical queries and traversal.

Self-JoinsData ModelingAmazon Development Center U.S.
Top 10 Products SQL QueryEasy
Practice
Practice drill

Use date filtering, GROUP BY, SUM, and ORDER BY to find Artefact's top 10 products by sales last month.

sqlArtefactKraken Digital Asset ExchangeAmazon Development Center U.S.
Top Products by Sales RevenueEasy
Practice
Practice drill

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

RankingGroup ByAggregationsRTXiSmile TechnologiesCatalina
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

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 · ~28 min
Partition and Distribution Key ChoicesMedium

Tests your understanding of data layout tradeoffs for performance, cost, and scalability.

performanceCloudData ModelingAmazon Development Center U.S.
Shopping Cart Data ModelHard

Tests your ability to design data models that support both streaming-style analytics and reporting.

Batch ProcessingData ModelingAmazon Development Center U.S.
More Pipelines questions with a free account
4
Behavioral & Leadership10 questions · ~94 min
More Behavioral & Leadership questions with a free account
The finish line: interview-readyComplete all 26 questions plus 3 hands-on drills to finish this plan.