Citigroup Data Engineer Interview Questions
The questions to prepare for a Citigroup Data Engineer interview. Questions from real interview reports rank first. Updated weekly.
Reverse a singly linked list in place using an iterative pointer update or recursion.
CitigroupTests your understanding of time series analytics and window-based computations.
CitigroupApproach for safely backfilling missing data while preserving correctness, idempotency, and data quality.
CitigroupDesign the core pipeline infrastructure for a new project, with attention to orchestration, data quality, idempotency, and future scale.
CitigroupApproach for maintaining data quality and integrity across ETL pipelines.
CitigroupSign up to see every question
Create a free account to unlock this list and practice real interview questions.
Tests your ability to write correct joins and date-based aggregations in SQL.
CitigroupTests SQL window function proficiency for grouped ranking and result shaping.
CitigroupTests your ability to improve query efficiency using indexing, query plans, and rewrite strategies.
CitigroupFind the top 3 customers in each region by transaction volume using joins, aggregation, and window ranking.
JPMorganChase
Silicon Valley Bank
NaviUse CTEs and ROW_NUMBER to return each customer's top three posted Citi card transactions per month.
CitigroupUse aggregation and window functions to calculate cumulative paid claims and rank Mutual of Omaha policyholders within each region.
Mutual of Omaha
Costar Group
Goodyear