CIBC Risk Analyst Interview Questions
The questions to prepare for a CIBC Risk Analyst interview. Questions from real interview reports rank first. Updated weekly.
Explain how INNER JOIN and LEFT JOIN differ, and when to use each for matched-only versus all-left-row analysis.
CIBCTests SQL join and filtering skills applied to risk-related datasets.
CIBCTests understanding of relational modeling and how keys enforce data relationships.
CIBCCompute top 10 customers by net sales using joins and aggregations, ordering by revenue with deterministic tie-breaking.
Gain Digital
TCS
Zest AIUse joins and LAG to isolate departments driving a large month-over-month spending variance.
State of California
University of Chicago
The Church of Jesus Christ of Latter-day SaintsMerge CRM orders with GA events via an identity map to build a customer-level view using joins, window functions, and monthly rollups.
ArtefactTests understanding of macro drivers and their effect on credit risk across portfolios.
CIBCTests product risk assessment approach and ability to translate business changes into risk views.
CIBCTests incident response and exposure assessment judgment for CIBC's corporate clients.
CIBCSign up to see every question
Create a free account to unlock this list and practice real interview questions.
Assesses how clearly you connect your background, motivation, and career direction to risk analysis through a concrete example.
CIBCAssesses understanding of accounting treatment relevant to credit and lending risk.
CIBC