Dataford
Top 39
Prep plan
Updated weekly · Last refresh Aug 30

Citizens Data Engineer Interview Questions

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

39questions
~5htotal time
Track your progressSign up free to work through all 39 questions and resume where you left off.
Start practicing free →
1
SQL & Data ManipulationStart here. 4 questions + 2 drills · ~54 min
Second Highest Without AggregatesHard
Practice

Find the second highest salary in each department without using aggregate functions.

SubqueriesRankingSelf-JoinsCitizens
SQL Optimization at CitizensMedium

Tests SQL proficiency and performance tuning approaches for analytics and reporting workloads.

SQL & Data ManipulationJoinsAggregationsCitizens
Top Customers by Sales RevenueEasy
Practice
Practice drill

Use GROUP BY and SUM to rank the top 10 customers by total revenue from a single sales table.

RankingGroup ByAggregationsHousecall ProEquifaxXYZ
Top Customers by Region VolumeMedium
Practice
Practice drill

Find the top 3 customers in each region by transaction volume using joins, aggregation, and window ranking.

Window FunctionsJoinsRankingJPMorganChaseSilicon Valley BankNavi
More SQL & Data Manipulation questions with a free account
2
Pipelines18 questions · ~151 min
Backfilling Missing Pipeline DataMedium

Approach for safely backfilling missing data while preserving correctness, idempotency, and data quality.

ETLQualityCitizens
Design High-Throughput Event PipelineHard

Design a real-time event pipeline that can handle millions of events per second with sub-second latency.

data pipelineevent processinglatencyCitizens
Data Quality and Schema EvolutionMedium

Approach for handling schema changes and data quality checks in a high-volume data lake pipeline.

schema evolutionData ModelingQualityCitizens
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
Coding5 questions · ~42 min
Explain Algorithm Time ComplexityEasy

Explain how to analyze the time complexity of a solution by examining loops, recursion, and dominant operations.

MathArraysSortingCitizens
CSV Processing in PythonMedium

Tests practical Python skills for transforming data for downstream use at Citizens.

CodingArraysStringsCitizens
Deduplicating Dataset EntriesMedium

Tests data cleaning and correctness skills for producing trustworthy datasets at Citizens.

Hash TablesCodingArraysCitizens
More Coding questions with a free account
4
Behavioral & Leadership12 questions · ~101 min
More Behavioral & Leadership questions with a free account
The finish line: interview-readyComplete all 39 questions plus 2 hands-on drills to finish this plan.