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

Amazon Advertising Data Engineer Interview Questions

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

25questions
~4htotal time
Track your progressSign up free to work through all 25 questions and resume where you left off.
Start practicing free →
1
CodingStart here. 5 questions · ~47 min
Reverse a String in PythonEasy
Practice

Reverse a string in Python using character traversal and return the reversed result.

StringsfunctionspythonAmazon Advertising
Max Product of Two IntegersEasy
Practice

Find the maximum product of two distinct array values by tracking the two largest and two smallest numbers in one pass.

ArraysSortingGreedyAmazon Advertising
More Coding questions with a free account
2
SQL & Data Manipulation12 questions + 3 drills · ~142 min
Primary Key vs Foreign KeyEasy

Tests relational database fundamentals and how keys enforce data integrity.

database designdata integrityAmazon Advertising
Normalization vs Reporting DenormalizationMedium

Explain normalization for data integrity and when denormalization is useful for faster reporting and simpler analytical queries.

performancenormalizationdata integrityAmazon Advertising
Join and Aggregation Query TuningHard

Tests advanced SQL performance optimization for large-scale joins and group-bys.

Joinsquery optimizationAggregationsAmazon Advertising
Top 10 Customers by SpendEasy
Practice
Practice drill

Find EarthCam's top 10 customers by total spend using GROUP BY, SUM, ORDER BY, and LIMIT.

RankingGroup ByAggregationsEarthcamAmazon AdvertisingFetch
Analyze Customer Purchase Trends with Window FunctionsEasy
Practice
Practice drill

Calculate the monthly spending trends for customers using window functions and joins.

The Home DepotAvisoWorld Wide Technology
Monthly Sales Trends by CategoryMedium
Practice
Practice drill

Aggregate monthly sales by product category and use LAG to calculate month-over-month changes.

InfrastructureToolsData WranglingTotal Wine & MoreInc.Benjamin Moore
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
Pipelines4 questions · ~37 min
Data Quality in ETL PipelinesEasy

Approach for maintaining data quality and integrity across ETL pipelines.

IdempotencyData ModelingQualityAmazon Advertising
Explain ETL in Data EngineeringEasy

Explain the ETL process, why it matters, and how it fits into a practical data pipeline.

ETLOrchestrationQualityAmazon Advertising
Data Model for ClickstreamHard

Tests schema design for event data and campaign metrics with analytics use cases.

ETLData ModelingQualityAmazon Advertising
More Pipelines questions with a free account
4
Behavioral & Leadership4 questions · ~37 min
More Behavioral & Leadership questions with a free account
The finish line: interview-readyComplete all 25 questions plus 3 hands-on drills to finish this plan.