Citi Consultant Interview Questions

The questions to prepare for a Citi Consultant interview. Questions from real interview reports rank first. Updated daily.

11questions

~3htotal time

Track your progressSign up free to work through all 11 questions and resume where you left off.

SQL & Data ManipulationStart here. 7 questions · ~102 min

Count Citi workflow task types with more than one exception and show the latest review date.

Optimize Slow Queries on Large DataMedium

Practice

Optimize a slow PostgreSQL query on a large dataset by choosing better filters, joins, and indexes.

Performance Tuningdatabase optimizationdatabase management

Citi

Handle Errors in Data PipelinesMedium

Practice

Identify transformation errors in Citi workflow runs and return the latest failed step per pipeline.

error handlingdata handlingdata validation

Citi

Join and Aggregate with SQLMedium

Practice

Join Citi reporting tables and aggregate results by the required business rules.

aggregationJoinssql query

Citi

More SQL & Data Manipulation questions with a free account

Execution3 questions · ~44 min

Explain how to design a new Citi reporting module, balancing stakeholder needs, data quality, and delivery risk.

Architect Using Existing Citi InfrastructureHard

Design a solution for a new business requirement using Citi's existing infrastructure and explain the trade-offs.

business requirementssystem designExecution

Citi

Data Quality During System MigrationMedium

Plan a Citi system migration that preserves data quality, reconciles records, and prevents business disruption.

Data Qualityconsistencysystem migration

Citi

Create a free account to unlock this list and practice real interview questions.