Top 50
Prep plan
Updated weekly · Last refresh Oct 17

C5i Data Engineer Interview Questions

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

50questions
~8htotal 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. 24 questions · ~222 min
SQL Query for Above-Average SalaryEasy
Practice

Use an aggregate subquery and LEFT JOIN to find Dayforce employees paid above the company-wide average salary.

aggregationsqlsalaryC5i
Top 3 Highest-Paid QueryEasy
Practice

Use ROW_NUMBER, filtering, and a department join to identify Josh Technology's three highest-paid active employees.

database managementsql queryC5i
SQL Running Total by DateMedium
Practice

Aggregate posted OneTrust privacy request charges by date and calculate cumulative revenue with a CTE and window function.

Window FunctionsDate FunctionsRunning TotalsC5i
More SQL & Data Manipulation questions with a free account
2
Pipelines15 questions · ~139 min
Data Integrity During System MigrationHard

Approach for preserving correctness during a pipeline migration, including validation, replay safety, and controlled cutover.

ETLIdempotencyQualityC5i
Design Real-Time Feature PipelineHard

Design a real-time feature pipeline processing 120K events/sec into low-latency feature tables and warehouse models with replay and quality controls.

InfrastructureStream ProcessingOrchestrationC5i
Backfill While Preserving Real TimeHard

Approach for running large historical backfills without breaking real-time pipeline freshness or correctness.

Stream ProcessingDependenciesBackfillingC5i
More Pipelines 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
Behavioral & Leadership10 questions · ~92 min
Explaining Python and SQL ImpactEasy

Tests how clearly you communicate hands-on Python and SQL experience through a concrete example with ownership and measurable impact.

sqltechnical experiencepythonC5i
More Behavioral & Leadership questions with a free account
4
More topics1 question · ~9 min
Normalization ImportanceMedium

Evaluates your understanding of normalization and its impact on database design.

databasenormalizationdesignC5i
The finish line: interview-readyComplete all 50 questions to finish this plan.