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

Citi Data Engineer Interview Questions

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

50questions
~9htotal 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. 12 questions · ~133 min
Second Lowest Salary with PySparkMedium
Practice

Return the second distinct lowest salary from an employee table while handling duplicate and NULL salary values.

Data ManipulationAggregationsdata extractionCiti
End-to-End PySpark ScriptMedium
Practice

Summarize qualifying transaction activity for every customer, including customers with no matching activity.

JoinsCase WhenAggregationsCiti
More SQL & Data Manipulation questions with a free account
2
Coding7 questions · ~78 min
Word Count in Large FileMedium
Practice

Count whitespace-delimited words in a 1TB file by processing chunks without loading the file into memory.

CodingAlgorithmsedge casesCiti
PySpark FundamentalsMedium
Practice
Recently asked

Model PySpark filter, deduplication, groupBy aggregation, and ordering with a single-pass Python pipeline.

pysparkdeduplicationaggregationCiti
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
System Design8 questions · ~89 min
Teradata to Hadoop Migration and SCD Type 2Hard

Explain a Teradata to Hadoop migration using SCD Type 2, including history preservation, reconciliation, data quality, and ML readiness.

Feature Storedata ingestionarchitecture patternsCiti
Handling Data SkewMedium

Design an end-to-end approach for detecting, diagnosing, and mitigating data skewness in ML pipelines.

Feature Driftdata ingestionfailure modesCiti
More System Design questions with a free account
4
Pipelines17 questions · ~189 min
Iceberg Schema Evolution and PartitioningHard
Recently asked

Explain practical schema evolution and partitioning strategies for Apache Iceberg tables.

data pipelinesschema evolutionpartitioningCiti
Lineage, Auditing, and Access ControlsHard
Recently asked

Design lineage, auditability, and access controls for ETL pipelines handling regulated financial data.

regulatory complianceGovernancedata pipelinesCiti
More Pipelines questions with a free account
5
Behavioral & Leadership6 questions · ~67 min
More Behavioral & Leadership questions with a free account
The finish line: interview-readyComplete all 50 questions to finish this plan.