McKinsey Interview Questions
McKinsey Interview Guides
McKinsey Interview Questions
Practice for the McKinsey interview with these recently asked interview questions.
| Question | Topic | Difficulty | ||||||||||||||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SQL | Medium | |||||||||||||||||||||||||||||||||||||||||||
Over budget on a project is defined when the salaries, prorated to the day, exceed the budget of the project. For example, if Alice and Bob both combined income make 200K and work on a project of a budget of 50K that takes half a year, then the project is over budget given 0.5 * 200K = 100K > 50K. Write a query to forecast the budget for all projects and return a label of Note: Assume that employees only work on one project at a time. Example: Input:
departments table
Output:
| ||||||||||||||||||||||||||||||||||||||||||||
Statistics | Easy | |||||||||||||||||||||||||||||||||||||||||||
Data Structures & Algorithms | Easy | |||||||||||||||||||||||||||||||||||||||||||
SQL | Easy | |
Machine Learning | Medium | |
Statistics | Medium | |
SQL | Hard | |
Machine Learning | Medium | |
Python | Easy | |
Deep Learning | Hard | |
SQL | Medium | |
Statistics | Easy | |
Machine Learning | Hard |
Challenge
Check your skills...
How prepared are you for working at Mckinsey & Company?
McKinsey Salaries by Position
Most data science positions fall under different position titles depending on the actual role.
From the graph we can see that on average the Software Engineer role pays the most with a $195,673 base salary while the Data Analyst role on average pays the least with a $92,851 base salary.
Discussion & Interview Experiences