Citi Data Analyst Interview Questions
The questions to prepare for a Citi Data Analyst interview. Questions from real interview reports rank first. Updated daily.
Explain how to identify, assess, and handle missing values in SQL using NULL checks, COALESCE, and validation logic.
CitiExplain how SQL replaces Excel for trend analysis on 100,000+ rows using aggregation, date grouping, and filtering.
CitiSummarize qualifying transaction activity for every customer, including customers with no matching activity.
CitiFind the second highest distinct salary and adapt the query to retrieve any requested salary rank.
Snowflake ComputingKKGISL
SBSRank valid transactions by amount within each department and month, returning the three highest-value rows per group.
Citi
MillimanDesign an orchestrated workflow that validates risk reports, detects anomalies, and routes actionable issues for review.
CitiTests experience building automated data transformation pipelines for reliable downstream analytics.
CitiTests core understanding of autocorrelation concepts and how to interpret ACF and PACF plots.
CitiDefine what success means for a project using clear KPIs, a north star, and supporting metrics.
CitiAssesses ability to apply quantitative methods to portfolio optimization and communicate results to clients.
CitiIdentify transaction KPIs, customer segments, trends, anomalies, and actionable insights from Citi customer transaction data.
CitiSign up to see every question
Create a free account to unlock this list and practice real interview questions.