Premium Employer

i

This company page is being actively managed by McKinsey & Company Team. If you also belong to the team, you can get access from here

McKinsey & Company Verified Tick

Compare button icon Compare button icon Compare

Filter interviews by

McKinsey & Company Database Developer Interview Questions and Answers

Updated 16 Jul 2024

McKinsey & Company Database Developer Interview Experiences

1 interview found

Interview experience
4
Good
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Behavioral 

(1 Question)

  • Q1. What are fear that you overcome
Round 2 - Coding Test 

Python coding test that was baasic included panadas framework

Round 3 - HR 

(1 Question)

  • Q1. Behavioural round

Interview questions from similar companies

I applied via Company Website and was interviewed before Nov 2020. There was 1 interview round.

Interview Questionnaire 

1 Question

  • Q1. How do you handle downtime
  • Ans. 

    I prioritize identifying the root cause and finding a solution while keeping stakeholders informed.

    • Identify the root cause of the downtime

    • Communicate with stakeholders about the issue and expected resolution time

    • Work on finding a solution as quickly as possible

    • Implement preventative measures to avoid future downtime

    • Document the incident and steps taken for future reference

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - Because confident and prepare well for versant test

I appeared for an interview in Jan 2021.

Round 1 - HR 

(1 Question)

Round duration - 90 Minutes
Round difficulty - Medium

This round happened on the same day as JAM in the afternoon time. A slot of 20 minutes with respective timing was already sent to the selected students. Interview can’t be generalize as anything can happen over there and hence this was exclusively my experience. 
To have a quick judgement about the person, I believe nothing is better than throwing before him/her some puzzles (mathematical/ analytical/ programming problems) and see the approach. I received back-to-back 4 problems after a quick and brief introduction. The coding problems I got were way too easy (just basics: searching & mathematical). The harder part of this round was the puzzles (tricky, mathematical, related to probability). At last, I was asked a question on DBMS and the interviewer asked if I know JAVA.

  • Q1. 

    Search an Element in a Sorted Array

    Given a sorted array 'A' of 'N' integers, determine whether a number 'X' exists within this array for a series of queries. For each query, print 1 if 'X' exists in the ...

  • Ans. 

    Search for a number in a sorted array and determine its existence for multiple queries.

    • Use binary search algorithm to efficiently search for each query integer in the sorted array.

    • For each query integer 'X', check if it exists in the array 'A' and output 1 if found, 0 otherwise.

    • Ensure the array 'A' is sorted in non-decreasing order to apply binary search effectively.

  • Answered by AI

Interview Preparation Tips

Eligibility criteriaNo criteriaDeloitte interview preparation:Topics to prepare for the interview - Data Structures, C++, OOPS, System Design, Algorithms, Dynamic ProgrammingTime required to prepare for the interview - 12 MonthsInterview preparation tips for other job seekers

Tip 1 : Mention some good projects on your resume.
Tip 2 : Practice competitive and aptitude questions.
Tip 3 : Work on your communication skills.

Application resume tips for other job seekers

Tip 1 : Mention some good projects on your resume.
Tip 2 : Don't put false things on your resume.

Final outcome of the interviewSelected

Skills evaluated in this interview

Interview Questionnaire 

1 Question

  • Q1. Java basics

I applied via Recruitment Consulltant and was interviewed before Jan 2021. There were 2 interview rounds.

Round 1 - Resume Shortlist 
Pro Tip by AmbitionBox:
Keep your resume crisp and to the point. A recruiter looks at your resume for an average of 6 seconds, make sure to leave the best impression.
View all tips
Round 2 - Coding Test 

Python coding test

Interview Preparation Tips

Topics to prepare for Deloitte Software Developer interview:
  • Python
Interview preparation tips for other job seekers - always practice coding
ex: python, java etc

I applied via Recruitment Consulltant and was interviewed before Feb 2021. There were 2 interview rounds.

Round 1 - Assignment 

Cofing round on hackerearth

Round 2 - Case Study 

Case study with algo and db design

Interview Preparation Tips

Interview preparation tips for other job seekers - Great technology, poor worklife balance

I applied via Naukri.com and was interviewed in Apr 2020. There was 1 interview round.

Interview Questionnaire 

2 Questions

  • Q1. What synchronous and asynchronous means??
  • Ans. 

    Synchronous means happening at the same time, while asynchronous means not happening at the same time.

    • Synchronous operations occur in real-time, while asynchronous operations can be delayed or queued.

    • Synchronous operations block the program until they are completed, while asynchronous operations allow the program to continue running.

    • Examples of synchronous operations include function calls and loops, while examples of ...

  • Answered by AI
  • Q2. When to use CTE and temp table.
  • Ans. 

    CTE and temp table usage in SQL

    • Use CTE for recursive queries and complex subqueries

    • Use temp tables for large data sets and complex queries

    • CTE is more efficient for small data sets

    • Temp tables can be indexed for faster performance

    • Consider the scope and lifespan of the data when choosing between CTE and temp table

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - Understand question first and answer.
Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via LinkedIn and was interviewed before May 2023. There were 2 interview rounds.

Round 1 - Aptitude Test 

Clear basic programming fundamentals

Round 2 - Technical 

(1 Question)

  • Q1. All basic to advance concepts oops, SDLC, C3, asp.net, angular etc.

Interview Preparation Tips

Topics to prepare for Gartner Software Developer interview:
  • oops
  • c#
  • .net
  • angular
  • aws
Interview preparation tips for other job seekers - - make sure to have clear understanding of programming fundamentals

I applied via Referral and was interviewed in Sep 2021. There were 3 interview rounds.

Round 1 - Behavioral 

(1 Question)

  • Q1. Basic Questions Regarding My Background & Experience.
Round 2 - Assignment 

Ruby Assignment

Round 3 - One-on-one 

(1 Question)

  • Q1. Discussion regarding the submitted assignment, pair programming followed by some technical questions regarding APIs, Architecture, etc.

Interview Preparation Tips

Interview preparation tips for other job seekers - Interview difficulty is moderate
Interview experience
4
Good
Difficulty level
Moderate
Process Duration
4-6 weeks
Result
Selected Selected

I applied via Company Website and was interviewed before Feb 2022. There were 3 interview rounds.

Round 1 - Coding Test 

MCQ - Logical, AWS, SQL, Python

Round 2 - Technical 

(1 Question)

  • Q1. Basic Python questions, SQL questions, AWS Questions, Previous project discussion, Day to day responsibilities etc.
Round 3 - Behavioral 

(1 Question)

  • Q1. System design, APIs, projects, products etc.

Interview Preparation Tips

Topics to prepare for Gartner Software Engineer interview:
  • Geeks for geeks
  • Blogs
  • Leetcode
  • Youtube
Interview preparation tips for other job seekers - Practice your basic coding skills and give thorough view to scan your resume and learn about almost every skill you have mentioned in your resume.

McKinsey & Company Interview FAQs

How many rounds are there in McKinsey & Company Database Developer interview?
McKinsey & Company interview process usually has 3 rounds. The most common rounds in the McKinsey & Company interview process are Behavioral, Coding Test and HR.

Tell us how to improve this page.

McKinsey & Company Database Developer Interview Process

based on 1 interview

Interview experience

4
  
Good
View more
Join McKinsey & Company We accelerate sustainable and inclusive growth.

Interview Questions from Similar Companies

Deloitte Interview Questions
3.8
 • 2.9k Interviews
PwC Interview Questions
3.4
 • 1.4k Interviews
Ernst & Young Interview Questions
3.4
 • 1.2k Interviews
KPMG India Interview Questions
3.5
 • 801 Interviews
ZS Interview Questions
3.3
 • 453 Interviews
BCG Interview Questions
3.7
 • 197 Interviews
Bain & Company Interview Questions
3.8
 • 106 Interviews
WSP Interview Questions
4.2
 • 94 Interviews
Gartner Interview Questions
4.1
 • 81 Interviews
View all
Business Presentation Specialist
559 salaries
unlock blur

₹2.2 L/yr - ₹8.5 L/yr

Associate
260 salaries
unlock blur

₹22.2 L/yr - ₹70.2 L/yr

Analyst
239 salaries
unlock blur

₹17.2 L/yr - ₹26.7 L/yr

Consultant
204 salaries
unlock blur

₹15 L/yr - ₹60 L/yr

Senior Analyst
189 salaries
unlock blur

₹11.9 L/yr - ₹37 L/yr

Explore more salaries
Compare McKinsey & Company with

BCG

3.7
Compare

Deloitte

3.8
Compare

Ernst & Young

3.4
Compare

PwC

3.4
Compare
Did you find this page helpful?
Yes No
write
Share an Interview