Citigroup Data Engineer Interview Questions
The questions to prepare for a Citigroup Data Engineer interview. Questions from real interview reports rank first. Updated daily.
Reverse a singly linked list in place using an iterative pointer update or recursion.
CitigroupTests your ability to write correct and efficient PySpark transformations.
CitigroupCompare ETL and ELT, and explain when ELT is the better pipeline pattern.
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.
CitigroupSign up to see every question
Create a free account to unlock this list and practice real interview questions.
Assesses SQL skills for top-N retrieval and your approach to performance tuning.
CitigroupTests your ability to write correct joins and date-based aggregations in SQL.
CitigroupFind the top 3 customers in each region by transaction volume using joins, aggregation, and window ranking.
JPMorganChase
Silicon Valley Bank
Banco SantanderUse 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
GoodyearTests your understanding of data types and how they affect modeling and processing choices.
Citigroup