Capital i Interview Questions
The questions to prepare for Capital i interviews, across all roles. Questions from real interview reports rank first. Updated daily.
Tests SQL proficiency for cleaning data and diagnosing underlying causes.
Tests knowledge of governance, security controls, and compliant data handling in restricted networks.
Tests ability to reconcile inconsistent data sources using SQL and sound data logic.
Tests investigation, reconciliation strategy, and decision-making when data sources disagree materially.
Identify duplicate transaction rows, retain the earliest record, and delete later duplicates safely.
Oracle
MicrosoftAudit raw timestamp values, identify formatting and timezone issues, and return normalized PostgreSQL timestamps.
Keystone Strategy
KeystoneUse partitioned ranking to identify the two highest sensor readings per device.
Johnson & JohnsonTests how you manage disagreement using evidence, transparency, and constructive stakeholder engagement.
Tests performance optimization practices for BI dashboards as datasets scale.
Tests requirements clarification and dashboard design from ambiguous inputs.
Tests practical use of statistical modeling for forecasting or operational improvement.
Sign up to see every question
Create a free account to unlock this list and practice real interview questions.