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

Amazon DSP Data Engineer Interview Questions

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

50questions
~12htotal time
Track your progressSign up free to work through all 50 questions and resume where you left off.
Start practicing free →
1
SQL & Data ManipulationStart here. 17 questions · ~236 min
Customers Never Ordered QueryEasy
Practice
Recently asked

Use a LEFT JOIN anti-join to identify Amazon DSP customers who have never placed an order.

SubqueriesJoinsCase WhenAmazon DSP
Top 3 Salaries With TiesMedium
Practice
Recently asked

Use DENSE_RANK to return the three highest salary levels and include every employee tied at those levels.

Window FunctionsSubqueriesRankingAmazon DSP
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 DSP
More SQL & Data Manipulation questions with a free account
2
Coding17 questions · ~236 min
Palindrome Ignoring PunctuationEasy
Practice
Recently asked

Determine whether Amazon DSP text is a case-insensitive palindrome after ignoring spaces and punctuation using two pointers.

Hash TablesStringsTwo PointersAmazon DSP
Rearrange Into PalindromeEasy
Practice
Recently asked

Determine whether an Amazon DSP label can be rearranged into a palindrome using character frequency counting.

Hash TablesBit ManipulationStringsAmazon DSP
Reverse a Linked List in PythonEasy
Practice
Recently asked

Reverse a singly linked list in place using an iterative pointer update or recursion.

RecursionLinked ListspointersAmazon DSP
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
Pipelines12 questions · ~166 min
Backfill Missing Customer DataHard
Recently asked

Design a safe backfill for missing customer records after an upstream fix, with idempotent reprocessing and data quality checks.

IdempotencyDependenciesBackfillingAmazon DSP
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 DSP
More Pipelines questions with a free account
4
Behavioral & Leadership4 questions · ~55 min
More Behavioral & Leadership questions with a free account
The finish line: interview-readyComplete all 50 questions to finish this plan.