Citi Data Engineer interview questions & guide 2026

The following questions are representative of those asked during real interviews for the Data Engineer position at Citi. They are shared to illustrate patterns in technical depth and scenario evaluation rather than serving as a static memorization list.

Technical and Coding Fundamentals

• Write a SQL query to find the top N salaries without using built-in ranking functions like RANK() or DENSE_RANK().
• Write a Python function to process a large log file and output specific transformation metrics.
• What is the expected output and execution behavior of the provided PySpark transformation snippet?

Preparing for your loops at Citi requires a balanced focus on core programming competency, distributed data concepts, and system architecture. Interviewers look for structured thinking, clean code, and the ability to articulate architectural trade-offs under pressure. Ground your preparation in practical problem-solving rather than theoretical definitions.

Role-related knowledge – This covers your command of core languages and tools, particularly Python, PySpark, advanced SQL, and big data engines. Interviewers evaluate this through live coding tasks, written exercises, and technical deep-dives into your past projects. Demonstrate strength by writing clean, readable code and proactively discussing time and space complexity.

Problem-solving ability – You will face ambiguous design scenarios and optimization challenges that test how you break down complex problems. Interviewers look for structured approaches where you clarify constraints, consider edge cases, and justify your technical choices. Walk the interviewer through your thought process clearly, especially when debugging code or tuning performance bottlenecks.

System design and architecture – This evaluates your capacity to design scalable, fault-tolerant, and secure data platforms. You must be ready to discuss data ingestion, storage layers, processing frameworks, and data federation strategies. Show strength by addressing non-functional requirements such as cost efficiency, latency, and regulatory compliance.

Culture fit and collaboration – As an engineer in a highly regulated global institution, your ability to communicate effectively with cross-functional partners is paramount. Interviewers assess how you handle operational incidents, collaborate with stakeholders, and adhere to data governance standards. Highlight your experience working in multidisciplinary teams and managing production-grade reliability.

The interview journey for a Data Engineer at Citi is designed to thoroughly evaluate both your hands-on coding capabilities and your architectural expertise. The process typically begins with an initial recruiter screening followed by a technical assessment or an automated coding evaluation on platforms like Karat. This early stage tests fundamental programming logic, data structures, and basic query writing.

Candidates who clear the initial screening advance to technical rounds, which often include a mix of live coding, scenario-based problem-solving, and deep technical discussions. Depending on the seniority of the role, you may encounter live whiteboard or shared-screen coding sessions focusing on PySpark, advanced SQL optimization, and data structures. Later stages frequently involve system design panels where you must defend architectural decisions around data pipelines, warehousing, and distributed clusters. The overall pace is rigorous, requiring you to transition smoothly from algorithmic problem-solving to high-level system design.

The visual timeline above outlines the progression from initial screening through technical assessments and final interviews. You should use this structure to pace your preparation, dedicating early weeks to algorithmic coding and SQL tuning before shifting focus to system architecture and behavioral readiness. Keep in mind that specific rounds can vary based on your geographic location, team alignment, and seniority level.

PySpark and Distributed Computing

Distributed computing proficiency is foundational for engineering roles at Citi. Interviewers assess your ability to write efficient transformation logic, manage data skew, and optimize cluster resource utilization. Strong candidates do not just write working code; they demonstrate an acute awareness of execution plans, shuffle operations, and memory management.

Be ready to go over:

• RDD transformations vs. DataFrames/Datasets API – Understanding execution efficiency and optimization advantages.
• Handling data skew – Techniques like broadcasting, salting, and custom partitioning to avoid single-task bottlenecks.

As a Data Engineer at Citi, your day-to-day responsibilities center on building and maintaining the robust data pipelines that feed enterprise applications and regulatory reporting engines. You will design and implement end-to-end ETL/ELT workflows that ingest streaming and batch data from internal databases, external feeds, and cloud storage repositories. Your focus will be on ensuring high data availability, low latency, and strict adherence to data quality standards.

Collaboration is a daily constant in this role. You will work side-by-side with data scientists, quantitative analysts, and application development teams to translate analytical requirements into scalable data models. You will also partner with infrastructure and site reliability teams to monitor production data pipelines, troubleshoot performance degradations, and automate deployment pipelines using continuous integration practices.

Driving strategic data modernization initiatives is another core expectation. You will participate in architecture reviews, evaluate emerging open-source technologies and cloud data services, and help migrate legacy data warehouses to modern distributed platforms. By establishing best practices in coding, documentation, and data governance, you ensure that Citi's data infrastructure remains resilient, secure, and ready for future scale.

Meeting the threshold for a Data Engineer position at Citi requires a robust blend of technical mastery, system design acumen, and domain experience. Interviewers look for engineers who have proven track records of building and maintaining production-grade data platforms in enterprise environments.

• Must-have technical skills – Advanced proficiency in Python and SQL, extensive hands-on experience with PySpark or similar distributed processing frameworks, and deep familiarity with data warehousing concepts and ETL/ELT pipeline design.
• Cloud and Big Data ecosystem – Practical experience working with modern data lake and warehouse technologies such as Snowflake, Databricks, Kafka, or Starburst (Trino), alongside cloud platforms (AWS, Azure, or GCP).
• Experience level – Typically 3 to 10+ years of hands-on data engineering experience, depending on whether you are stepping into an Assistant Vice President (AVP), Vice President (VP), or Senior Vice President (SVP) track.
• Soft skills and governance – Strong communication abilities, stakeholder management experience, and a solid understanding of data governance, security, and compliance principles in regulated industries.
• Nice-to-have skills – Familiarity with containerization technologies like Docker and Kubernetes, experience with Infrastructure as Code (IaC), contributions to open-source data tools, and specific domain knowledge in financial services or trading analytics.

Q: How difficult are the technical interviews at Citi? The interviews range from average to challenging, with a heavy emphasis on practical coding and problem-solving under time constraints. While initial screening rounds often utilize standard coding platforms, later technical rounds test deep domain knowledge in PySpark, SQL, and system architecture.

Q: How much time should I dedicate to interview preparation? Most candidates benefit from 4 to 6 weeks of dedicated preparation. Focus your time on solving medium-to-hard algorithmic problems in Python, optimizing complex SQL queries without window functions, and reviewing distributed systems concepts.

Q: What differentiates successful candidates from those who are rejected? Successful candidates excel at communicating their thought process clearly, even when they encounter a challenging coding problem or an unfamiliar design scenario. Demonstrating a rigorous approach to performance tuning and data governance also sets top-tier applicants apart.

Q: What is the typical interview timeline from initial screen to offer? The process typically spans 3 to 5 weeks from your initial recruiter conversation to the final decision. This includes an online assessment or technical screen, followed by multiple rounds of deep-dive technical and system design interviews.

Q: Are remote or hybrid work options available for Data Engineers? Work arrangements vary by team and geographic location, with many technology hubs operating on a hybrid model that blends remote work with collaboration days in regional offices such as New York, Jersey City, Tampa, or Toronto.

• Master the fundamentals of SQL and PySpark: Expect to write code on the spot during technical rounds. Practice writing complex queries without relying on modern shortcuts, and be ready to explain the execution mechanics of distributed data frames.
• Structure your system design answers: When facing architectural questions, start by clarifying functional and non-functional requirements. Explicitly discuss trade-offs around latency, consistency, partitioning, and cost efficiency.
• Prepare STAR-format behavioral stories: Be ready to discuss past projects where you handled data pipeline failures, optimized slow-running jobs, or collaborated with difficult stakeholders under tight deadlines.
• Brush up on data governance principles: Because Citi operates in a heavily regulated financial sector, demonstrate an active awareness of data lineage, compliance, security controls, and data quality monitoring.
• Communicate your assumptions clearly: During live coding or system design exercises, never code or design in silence. Articulate your assumptions, check in with your interviewers, and treat them as collaborative engineering partners.

Stepping into a Data Engineer role at Citi offers the unique opportunity to build and scale critical financial data infrastructure that impacts global markets. By mastering the core evaluation areas—ranging from distributed computing with PySpark and advanced SQL optimization to enterprise data architecture and governance—you position yourself as a high-impact technical candidate. Approach your preparation methodically, focusing on clean code execution and clear architectural reasoning.

The compensation data above reflects competitive market rates for engineering talent at Citi, varying by geographic hub, organizational unit, and seniority level ranging from analyst tracks up to Vice President and Director roles. Use these ranges to anchor your expectations during recruiter conversations while focusing primarily on demonstrating your technical value. Consistent, targeted preparation can materially improve your performance across every stage of the loop.

To explore additional interview insights, practice questions, and comprehensive preparation resources, be sure to visit Dataford. With disciplined study and a clear understanding of what the hiring teams expect, you are well-equipped to navigate your interviews with confidence and secure your next career milestone.