Top 26
Prep plan
Updated weekly · Last refresh Oct 17

Affine Data Engineer Interview Questions

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

26questions
~4htotal time
Track your progressSign up free to work through all 26 questions and resume where you left off.
Start practicing free →
1
SQL & Data ManipulationStart here. 8 questions + 2 drills · ~94 min
Third Highest Salary QueryMedium

Tests SQL ranking logic and correct handling of ordering and ties.

sqlAffine
Core SQL and Big Data ConceptsMedium

Evaluates your breadth of SQL and big data tooling relevant to Affine consulting projects.

sqlsparkAffine
Window Functions and Query SemanticsHard

Evaluates understanding of SQL semantics and window function behavior for analytics queries.

Window FunctionsJoinssqlAffine
Second-Highest Per GroupMedium
Practice
Practice drill

Use a window function to find the second-highest distinct transaction value for each client department.

Window FunctionsData ManipulationRankingAffine
7-Day Rolling Active UsersMedium
Practice
Practice drill

Compute daily active users and a 7-day rolling average using a CTE, distinct counts, and window functions.

Window FunctionsDate FunctionsRunning TotalsMetaSpotifyMeta IT
More SQL & Data Manipulation questions with a free account
2
Coding7 questions · ~65 min
Scala and Python Program DesignMedium

Evaluates your ability to translate solutions across languages used in data engineering.

pythonAffine
Python and SQL Coding BasicsMedium

Tests your ability to implement Python logic and reason about SQL joins.

sqlpythonAffine
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
Pipelines5 questions · ~46 min
Designing Pipelines and Data ModelsMedium

Evaluates your ability to design data pipeline architecture and data modeling decisions.

ETLsparkData ModelingAffine
Spark Broadcast Join StrategyMedium

Tests your ability to choose Spark join strategies to reduce shuffle and improve runtime.

JoinsperformancesparkAffine
More Pipelines questions with a free account
4
Behavioral & Leadership5 questions · ~46 min
More Behavioral & Leadership questions with a free account
5
More topics1 question · ~9 min
Production Error Handling and LoggingMedium

Tests reliability practices for production data pipelines, including observability and failure handling.

production issuespython serviceAffine
The finish line: interview-readyComplete all 26 questions plus 2 hands-on drills to finish this plan.