Top 11
Company roadmap
Updated weekly · Last refresh Oct 27
C

Capital i Interview Questions

The questions to prepare for Capital i interviews, across all roles. Questions from real interview reports rank first. Updated daily.

11questions
~1htotal time
Track your progressSign up free to work through all 11 questions and resume where you left off.
Start practicing free →
1
SQL & Data ManipulationStart here. 4 questions + 3 drills · ~62 min
SQL Data Cleaning and Root CauseMedium

Tests SQL proficiency for cleaning data and diagnosing underlying causes.

data cleaningsqlCCapital i
Data Governance in DoD EnvironmentsMedium

Tests knowledge of governance, security controls, and compliant data handling in restricted networks.

security complianceCCapital i
SQL Reconciliation Across SystemsMedium

Tests ability to reconcile inconsistent data sources using SQL and sound data logic.

legacy systemssapCCapital i
Reconciling Major Data Quality DiscrepanciesHard

Tests investigation, reconciliation strategy, and decision-making when data sources disagree materially.

Data Qualitydata validationdiscrepancy handlingCCapital i
Data Quality in TransformationsHard
Practice
Practice drill

Transform Roblox event records by validating fields, imputing missing creators, and reporting quality metrics per experience.

missing valuesData Qualitydata cleaningRoblox
ETL, Data Cleaning, and SQLMedium
Practice
Practice drill

Clean staged customer events and return valid records with invalid-row reasons using joins and CASE logic.

data cleaningJoinsETLSnowflake Computing
Analyzing Data in SQLMedium
Practice
Practice drill

Use SQL to rapidly summarize transaction failures and identify accounts requiring review.

Data Analysissqldata validationIntuit
2
Behavioral & Leadership4 questions · ~32 min
Handling Analysis That Contradicts Prior DecisionsMedium

Tests how you manage disagreement using evidence, transparency, and constructive stakeholder engagement.

Conflict ResolutionData Analysisclient communicationCCapital i
More Behavioral & Leadership questions with a free account
3
More topics3 questions · ~24 min
Keeping Dashboards PerformantMedium

Tests performance optimization practices for BI dashboards as datasets scale.

optimizationCCapital i
Power BI From Vague RequestMedium

Tests requirements clarification and dashboard design from ambiguous inputs.

stakeholder communicationdashboard designCCapital i
Statistical Modeling for ForecastingMedium

Tests practical use of statistical modeling for forecasting or operational improvement.

ForecastingCCapital i

Sign up to see every question

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

Get my prep plan
The finish line: interview-readyComplete all 11 questions plus 3 hands-on drills to finish this plan.