AmbitionBox
Interview Questions
- Reviews
- Salaries
- Interview Questions
- About Company
- Benefits
- Jobs
- Office Photos
- Community
i
McKinsey & Company
Compare
Filter interviews by
McKinsey & Company Database Developer Interview Questions and Answers
McKinsey & Company Database Developer Interview Experiences
1 interview found
Anonymous
(1 Question)
- Q1. What are fear that you overcome
Python coding test that was baasic included panadas framework
(1 Question)
- Q1. Behavioural round
Top trending discussions
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
Interview Preparation Tips
I appeared for an interview in Jan 2021.
(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.
Interview Preparation Tips
Tip 1 : Mention some good projects on your resume.
Tip 2 : Practice competitive and aptitude questions.
Tip 3 : Work on your communication skills.
Tip 1 : Mention some good projects on your resume.
Tip 2 : Don't put false things on your resume.
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.
Python coding test
Interview Preparation Tips
- Python
ex: python, java etc
I applied via Recruitment Consulltant and was interviewed before Feb 2021. There were 2 interview rounds.
Cofing round on hackerearth
Case study with algo and db design
Interview Preparation Tips
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 ...
- 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
Interview Preparation Tips
Selected
I applied via LinkedIn and was interviewed before May 2023. There were 2 interview rounds.
Clear basic programming fundamentals
(1 Question)
- Q1. All basic to advance concepts oops, SDLC, C3, asp.net, angular etc.
Interview Preparation Tips
- oops
- c#
- .net
- angular
- aws
I applied via Referral and was interviewed in Sep 2021. There were 3 interview rounds.
(1 Question)
- Q1. Basic Questions Regarding My Background & Experience.
Ruby Assignment
(1 Question)
- Q1. Discussion regarding the submitted assignment, pair programming followed by some technical questions regarding APIs, Architecture, etc.
Interview Preparation Tips
Selected
I applied via Company Website and was interviewed before Feb 2022. There were 3 interview rounds.
MCQ - Logical, AWS, SQL, Python
(1 Question)
- Q1. Basic Python questions, SQL questions, AWS Questions, Previous project discussion, Day to day responsibilities etc.
(1 Question)
- Q1. System design, APIs, projects, products etc.
Interview Preparation Tips
- Geeks for geeks
- Blogs
- Leetcode
- Youtube
McKinsey & Company Interview FAQs
Tell us how to improve this page.
McKinsey & Company Interviews By Designations
- McKinsey & Company Consultant Interview Questions
- McKinsey & Company Business Analyst Interview Questions
- McKinsey & Company Business Presentation Specialist Interview Questions
- McKinsey & Company Summer Intern Interview Questions
- McKinsey & Company Intern Interview Questions
- McKinsey & Company Junior Associate Interview Questions
- McKinsey & Company Associate Interview Questions
- McKinsey & Company Analyst Interview Questions
- Show more
Interview Questions for Popular Designations
- Oracle Database Administrator Interview Questions
- SQL Database Administrator Interview Questions
- Database Architect Interview Questions
- Senior Database Administrator Interview Questions
- Database Engineer Interview Questions
- SQL Server Database Administrator Interview Questions
- Mysql Database Administrator Interview Questions
- DB2 Database Administrator Interview Questions
- Show more
McKinsey & Company Database Developer Interview Process
based on 1 interview
Interview experience
Interview Questions from Similar Companies
Fast track your campus placements
|
Business Presentation Specialist
559
salaries
|  ₹2.2 L/yr - ₹8.5 L/yr |
|
Associate
260
salaries
| ₹22.2 L/yr - ₹70.2 L/yr |
|
Analyst
239
salaries
| ₹17.2 L/yr - ₹26.7 L/yr |
|
Consultant
204
salaries
| ₹15 L/yr - ₹60 L/yr |
|
Senior Analyst
189
salaries
| ₹11.9 L/yr - ₹37 L/yr |
BCG
Deloitte
Ernst & Young
PwC
- Home >
- Interviews >
- McKinsey & Company Interview Questions >
- McKinsey & Company Database Developer Interview Questions
