McKinsey & Data Engineer Interview Questions

The questions to prepare for a McKinsey & Data Engineer interview. Questions from real interview reports rank first. Updated daily.

45questions

~10htotal time

Track your progressSign up free to work through all 45 questions and resume where you left off.

CodingStart here. 10 questions · ~128 min

Compute the minimum operations required to reduce an integer to zero using constrained bit flips.

Detect Loop in Linked ListMedium

Practice

Detect a cycle in a singly linked list using Floyd's slow and fast pointer algorithm.

Data Structurescycle detectionAlgorithms

McKinsey &

More Coding questions with a free account

SQL & Data Manipulation5 questions · ~64 min

Filter records above a threshold and return them in ascending value order.

Running Sum with SQLMedium

Practice

Calculate a chronological running sum of transaction amounts for each account using PostgreSQL.

Data Manipulationdatabase queryingAggregations

McKinsey &

More SQL & Data Manipulation questions with a free account

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

System Design7 questions · ~90 min

Data Warehouse for Convenience Store ChainHard

Design a reliable warehouse for convenience-store transactions, inventory, suppliers, and ML-ready analytical features.

Feature Driftdata ingestionarchitecture patterns

McKinsey &

More System Design questions with a free account

Pipelines12 questions · ~154 min

SQL, Python, and PySpark RoundHard

Explain how you approached a technical case using SQL, Python, and PySpark, including design decisions, validation, and performance considerations.

Data Qualitydistributed computingprojects

McKinsey &

More Pipelines questions with a free account

Behavioral & Leadership9 questions · ~116 min

More Behavioral & Leadership questions with a free account