Citi Data Engineer Interview Guide
The Citi data engineer loop, round by round: what each stage tests, example questions with the guidance interviewers actually score, the mistakes that sink strong candidates, and how to prepare.
What the Citi loop tests: domains and difficulty
Our prediction of the question mix by domain and difficulty for this company's data engineer loop, from live listings and interview reports.
The domain and difficulty mix we predict for a Citi data engineer loop, across 14 problems. It updates as more Citi data lands.
2 real Citi interview questions
Reported by candidates from real loops, tagged by domain, round, level, and year. Expand for what the round is scoring.
SQLL5 · 2025Top N salary without using function key wordUnknown+
SQLL5 · 2025Top N salary without using function key wordOnsite · sql+
Try a Citi-style SQL round
Find every user active on 3 or more CONSECUTIVE days. This gaps-and-islands shape shows up in nearly every DE SQL round. Edit the query and run it against the seed data.
Practice the Citi loop
The problems our model expects in this company's interview, grouped by round. Work the shapes that come up, not the ones that read well on a list.
Citi is hiring data engineers now
The roles behind this loop. Prep against the levels and locations they are actually filling.
Data integration delivery: Design, build, and operate robust batch and near-real-time integration pipelines for CRM data domains (e.g., customers, products, orders, invoices, service interactions).
Big Data Infrastructure: Develop and manage large-scale data processing systems using frameworks like Apache Spark, Hadoop, and Kafka.
Design and maintain blueprint of the information architecture, data integrations and controls aligned to the renewed business strategy
Design, develop, and maintain high-performance, resilient, and scalable ETL processes using the Ab Initio suite of products (GDE, Co>Operating System, EME) to transform upstream data into the required format for Oracle Financials SaaS.
Develop, maintain, and optimize highly efficient and resilient data ingestion, processing, and transformation pipelines using advanced Python and PySpark techniques for large-scale datasets.
Architect for Real-Time: Serve as the go-to expert for the data platform, ensuring every design adheres to our overall architecture blueprint.
Build and maintain big data pipelines using technologies such as Apache Hadoop, Apache Kafka, Databricks and other cloud based big data tools.
Monitor and control all phases of development process and analysis, design, construction, testing, and implementation as well as provide user and operational support on applications to business users
Architect & Design: Design, architect, and oversee the development of robust, scalable, and reliable data infrastructure, including data lakes, data warehouses, and real-time streaming platforms on the cloud.
Architect, design, and deliver scalable, Python‑based applications supporting credit risk analytics, workflows, and reporting.
Citi compensation and culture
The numbers, tech stack, and team structure live on the company overview.
Compare Citi with other data engineering employers
How the role, pay, and loop stack up against peer companies.
Prepare at Citi interview difficulty
- 01
Reading a solution is not the same as writing one
Every engineer who has frozen on a query they had read a dozen times knows the gap. The only preparation that closes it is producing the answer yourself, under time, before the interview does it for you
- 02
76% of hiring managers reject on the coding task, not the resume
From HackerRank's 2024 Developer Skills Report. Candidates who look strong on paper still fail the live screen if they haven't done timed, executable practice
- 03
5 problem shapes cover 80% of data engineer loops
Dedup, sessionization, top-N-per-group, slowly-changing dimensions, partition tricks. Writing the shapes by hand turns the unfamiliar into pattern recognition