Dataford
Top 24
Prep plan
Updated weekly · Last refresh Aug 30

Guy Carpenter Software Engineer Interview Questions

The questions to prepare for a Guy Carpenter Software Engineer interview. Questions from real interview reports rank first. Updated weekly.

24questions
~4htotal time
Track your progressSign up free to work through all 24 questions and resume where you left off.
Start practicing free →
1
CodingStart here. 7 questions · ~62 min
Sorting Integers FunctionEasy
Practice

Sort an integer array in ascending order and return the sorted result.

ArraysSortingGuy Carpenter
Explaining a Live Coding SolutionEasy

Explain how to present an array/hash-table coding solution clearly in a live interview, from clarification to testing.

Hash TablesArraysSortingGuy Carpenter
More Coding questions with a free account
2
Execution11 questions · ~97 min
Handling QA Feedback Under ReviewEasy

Explain how you handle criticism of your QA work while maintaining quality, trust, and continuous improvement.

Trade-offsSuccess CriteriaRisk AssessmentGuy Carpenter
Explain Technical Trade-offs ClearlyEasy

Explain technical trade-offs to non-technical stakeholders in a way that drives alignment and decision-making.

Trade-offsSuccess CriteriaRisk AssessmentGuy Carpenter
More Execution 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
Pipelines3 questions · ~26 min
Design Scalable Pipeline InfrastructureHard

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

InfrastructureToolsQualityGuy Carpenter
Handle Distributed Data IntegrityHard

Tests understanding of consistency, validation, and failure modes in distributed environments.

IdempotencyDependenciesQualityGuy Carpenter
More Pipelines questions with a free account
4
More topics3 questions · ~26 min
Columnar vs Traditional DatabasesMedium

Evaluates your ability to choose storage and query approaches for different analytics workloads.

databasesGuy Carpenter
Broadcast vs Shuffle JoinsMedium

Tests your knowledge of distributed join strategies and performance trade-offs.

sparkGuy Carpenter
More questions with a free account
Hands-on SQL practiceWrite and run real queries in the editor. 3 drills · ~30 min
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
Contact Center Agent Performance MetricsHard
Practice
Practice drill

Compute daily agent call KPIs and SLA using joins, aggregations, and window ranking in a contact center model.

ETLAggregationsData ModelingADP
Second Highest Trader SalaryEasy
Practice
Practice drill

Find the second highest distinct salary from a single table using basic PostgreSQL ordering and limiting.

SubqueriesRankingSortingeClinicalWorksInformaticaSpectraforce Technologies
The finish line: interview-readyComplete all 24 questions plus 3 hands-on drills to finish this plan.