Dataford
Dataford
Top 33
Prep plan
Updated weekly · Last refresh Oct 17

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 daily.

33questions
~5htotal time
Track your progressSign up free to work through all 33 questions and resume where you left off.
Start practicing free →
1
SQL & Data ManipulationStart here. 14 questions + 1 drill · ~147 min
Compute Category Sales by LocationMedium
Practice
Recently asked

Calculate sales value by item category and location using pricing validity and a specified date range.

Date FunctionsJoinssqlAmazon Advertising
Employee and Manager Join QueryEasy
Practice
Recently asked

Use a self-join to return each Beaconfiresolution employee alongside their manager, including employees without a manager.

sql queryAmazon Advertising
Primary Key vs Foreign KeyEasy
Recently asked

Explain how primary keys and foreign keys differ and how together they keep related tables consistent.

data relationshipsdatabase designdata integrityAmazon Advertising
SQL Window Functions for Campaign RankingMedium
Practice
Recently asked
Practice drill

Rank campaigns by advertiser performance and calculate campaign-level running conversions over time with PostgreSQL window functions.

Window FunctionsJoinsData ManipulationStackadaptLiveRampAmazon Advertising
More SQL & Data Manipulation questions with a free account
2
Coding4 questions · ~39 min
Max Product of Two IntegersEasy
Practice
Recently asked

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

ArraysSortingGreedyAmazon Advertising
Reverse a String in PythonEasy
Practice
Recently asked

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

StringsfunctionspythonAmazon Advertising
More Coding 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
Pipelines8 questions · ~78 min
Handle PySpark Data SkewMedium
Recently asked

Approach for detecting and mitigating skew in PySpark pipelines using partitioning, join strategies, and runtime monitoring.

Data Qualitypysparkdata skewnessAmazon Advertising
Explain ETL in Data EngineeringEasy
Recently asked

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

ETLOrchestrationQualityAmazon Advertising
Data Quality in ETL PipelinesEasy
Recently asked

Approach for maintaining data quality and integrity across ETL pipelines.

IdempotencyData ModelingQualityAmazon Advertising
More Pipelines questions with a free account
4
Behavioral & Leadership7 questions · ~68 min
More Behavioral & Leadership questions with a free account
The finish line: interview-readyComplete all 33 questions plus 1 hands-on drill to finish this plan.