McKinsey & Company Junior Analyst Interview Questions and Answers

Q1. Difference between dense rank, rank and row number
Ans. 
Dense rank assigns consecutive integers to rows with the same value, rank assigns the same rank to ties and leaves gaps, row number assigns unique numbers to rows.
• Dense rank assigns consecutive integers to rows with the same value, without any gaps.

• Rank assigns the same rank to ties and leaves gaps in the ranking sequence.

• Row number assigns unique numbers to rows in the result set.

• Example: Dense rank - 1, 2, 2, 3; Rank
Answered by AI
Add your answer

Q1. Tell me how you managed to solve a conflict at your firm
Add your answer

Q1. Salary discussion
Add your answer

It had general aptitude questions and the paper was more focused upon English aspect.

Q1. This was was more based upon technical questions , nothing much out of resume... (Tip- try to persive is more as a conversation and not an interview, whenever asked "do you have any questions?" Always have...read more
Add your answer
Q2. What was your role in your college project?
Add your answer
Q3. General questions related to SQL, testing, networking, etc (as per my CV)
Add your answer

Q1. This is a English specific test consisting of listening, speaking, writing, etc
Add your answer

Q1. Tell me about yourself
Ans. 
I am a dedicated and detail-oriented Junior Engineer with a passion for problem-solving and continuous learning.
• Graduated with a degree in Engineering from XYZ University

• Completed internships at ABC Company, gaining hands-on experience in project management

• Proficient in CAD software and technical drawing
Answered by AI
Add your answer
Q2. Diagram of water treatment
Ans. 
Water treatment involves a series of processes to remove impurities and make water safe for consumption.
• Water treatment typically involves processes such as coagulation, sedimentation, filtration, and disinfection.

• Coagulation involves adding chemicals to water to make particles clump together for easier removal.

• Sedimentation allows the larger particles to settle at the bottom of a tank.

• Filtration involves passing water...read more
Answered by AI
Add your answer

Q1. Personal details
Add your answer
Q2. Why you want to join
Ans. 
I want to join because I am passionate about engineering and eager to learn and grow in a dynamic environment.
• Passionate about engineering

• Eager to learn and grow

• Excited about working in a dynamic environment
Answered by AI
Add your answer

Apptitude round mainly english

Basic aptitude test consisting questions of Logical reasoning, quant, and English

Q1. Guesstimate - How many red cars are purchased in Delhi?
Ans. 
It is estimated that around 20% of cars in Delhi are red, so approximately 1 out of every 5 cars is red.
• Consider the total number of cars in Delhi

• Estimate the percentage of cars that are red

• Calculate the number of red cars based on the percentage
Answered by AI
Add your answer

Q1. Guesstimate - Size of mattresses market in Delhi?
Ans. 
The size of the mattresses market in Delhi can be estimated by considering the population, average household size, and consumer preferences.
• Consider the population of Delhi and the average household size to estimate the number of households in need of mattresses

• Research the average spending on mattresses per household in Delhi

• Take into account the various types of mattresses available in the market and their respective...read more
Answered by AI
Add your answer

Q1. Strengths and weakness
Add your answer
Q2. Relocation? How would you manage travel?
Ans. 
I am open to relocation and willing to manage travel efficiently.
• I am flexible and willing to relocate for the right opportunity.

• I will plan ahead and research the best travel options available.

• I am comfortable with long commutes or temporary accommodations if needed.
Answered by AI
Add your answer

Basic accounting anf financial questions were asked

Q1. Xlookup, vlookup Pivot chart Excel
Add your answer
Q2. Accouting ratios DPO
Add your answer
Q3. Ebitda how to calculate and meaning
Ans. 
EBITDA stands for Earnings Before Interest, Taxes, Depreciation, and Amortization. It is a measure of a company's operating performance.
• Calculate EBITDA by adding back interest, taxes, depreciation, and amortization to net income.

• EBITDA is used to analyze and compare profitability between companies.

• It helps in assessing a company's ability to generate cash flow.

• EBITDA is commonly used in valuation and financial analysi...read more
Answered by AI
Add your answer