DTCC Interview Questions
The questions to prepare for DTCC interviews, across all roles. Questions from real interview reports rank first. Updated weekly.
Validate DTCC CTM trade instructions using abstract rules and polymorphic asset-specific validators.
DTCCExplain how you prioritize competing work under time pressure while making trade-offs and keeping stakeholders aligned.
DTCCSign up to see every question
Create a free account to unlock this list and practice real interview questions.
Explain how SQL is used to validate database quality through row counts, null checks, duplicates, and aggregate comparisons.
DTCCFind duplicate American Institutes for Research assessment submissions using a CTE, GROUP BY, HAVING, and joins.
American Institutes for Research
Macy'sUse joins, a CTE, and aggregations to calculate average vehicle idle minutes in a specific geographic zone.
WaymoFind repeated Zomato order items using GROUP BY, HAVING, a CTE, and STRING_AGG.
ZomatoTests your ability to deliver a clear, relevant introduction tailored to the role at Aqr.
DTCCEvaluates foundational knowledge of financial risk, crisis dynamics, and derivative instruments.
DTCCApproach for keeping data consistent during a legacy-to-new-platform migration, including validation, replay safety, and reconciliation.
DTCCTests baseline understanding of your relevant product and execution background.
DTCCAssesses your operational knowledge for maintaining production systems.
DTCC