Top 34
Company roadmap
Updated weekly · Last refresh Aug 30

Capital Technology Group Interview Questions

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

34questions
~5htotal time
Track your progressSign up free to work through all 34 questions and resume where you left off.
Start practicing free →
1
ExecutionStart here. 9 questions · ~73 min
Handling a Critical Production BugEasy

Describe how you handled discovery, escalation, triage, and containment of a critical bug under release pressure.

Trade-offsSuccess CriteriaRisk AssessmentCapital Technology Group
Decide What to AutomateEasy

Explain how you decide which tests to automate versus keep manual, balancing risk, cost, and long-term maintenance.

Trade-offsRisk AssessmentScope ManagementCapital Technology Group
More Execution questions with a free account
2
Pipelines6 questions · ~48 min
Design Scalable Pipeline InfrastructureHard

Design the core pipeline infrastructure for a new project, with attention to orchestration, data quality, idempotency, and future scale.

InfrastructureToolsQualityCapital Technology Group
Handling a Production Pipeline FailureEasy

Describe a real production pipeline failure, how you diagnosed and fixed it, and what changes you made around orchestration, quality, and reruns.

InfrastructureIdempotencyQualityCapital Technology Group
More Pipelines questions with a free account

Sign up to see every question

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

Get my prep plan
3
SQL & Data Manipulation3 questions + 3 drills · ~54 min
Avoiding SQL PitfallsMedium

Tests your ability to identify and prevent performance, correctness, and scalability issues in SQL for high-volume systems.

best practicesperformancesqlCapital Technology Group
Optimizing Slow SQL and DatabricksMedium

Tests your approach to performance tuning in SQL and Databricks for reliable delivery.

Performance TuningdatabricksCapital Technology Group
Monthly Sales Trends by CategoryMedium
Practice
Practice drill

Aggregate monthly sales by product category and use LAG to calculate month-over-month changes.

InfrastructureToolsData WranglingTotal Wine & MoreInc.Benjamin Moore
Top Models Per Asset ClassEasy
Practice
Practice drill

Rank Balyasny research models by average return within each asset class using DENSE_RANK and aggregation.

performancesqlBalyasny Asset Management
SQL Queries for RankingMedium
Practice
Practice drill

Rank active HSBC employees by division and return every employee tied for the highest or second-highest salary.

javasqlHsbc
More SQL & Data Manipulation questions with a free account
4
Coding4 questions · ~32 min
JavaScript Data TransformationMedium

Tests your practical coding ability to implement correct data transformation logic in JavaScript.

javascriptfunctionsCapital Technology Group
Real-World Coding FocusMedium

Evaluates ability to transfer algorithmic thinking to real-world software constraints.

leetcodeAlgorithmsCapital Technology Group
More Coding questions with a free account
5
Behavioral & Leadership12 questions · ~97 min
More Behavioral & Leadership questions with a free account
The finish line: interview-readyComplete all 34 questions plus 3 hands-on drills to finish this plan.