Upload Button Icon Add office photos
Engaged Employer

i

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

Marsh McLennan Verified Tick

Compare button icon Compare button icon Compare
4.1

based on 632 Reviews

Filter interviews by

Marsh McLennan Analytics Consultant Interview Questions and Answers for Experienced

Updated 9 Aug 2023

1 interview found

Sort by: Popular

Analytics Consultant Interview Questions

user image Anonymous

posted on 29 Jul 2023

Interview experience
3
 Average
Difficulty level
 -
Duration
 -
Result
 -

2 Interview Rounds

1

Resume Shortlist Round

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
2

Technical Round (5 Questions)

  • Q1. SQL queries regarding your project
  • Q2. Pratice joining concepts
  • Q3. Regarding end to end intercation with your project manager
  • Q4. ETL process and tableau concepts
  • Q5. Dashboard related to Tableau

Interview Preparation Tips

Interview preparation tips for other job seekers - - Be confident
- Don't make you down at the time of interview.
- Answer what's real

Interview questions from similar companies

Interview experience
4
 Good
Difficulty level
 Moderate
Duration
 -
Result
 Not Selected

I applied via Naukri.com and was interviewed in Jul 2022.

2 Interview Rounds

1

Resume Shortlist Round

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
2

Technical Round (7 Questions)

  • Q1. What is the meaning of Data Aggregation?
  • Q2. Delete duplicate Records in SQL
  • Q3. What are the different types of Join used in SQL?
  • Q4. What is subquary ? Why it is required ?
  • Q5. What is the meaning of Trigger in Python?
  • Q6. Componets of Tableau ? What are the different connection is there in Tableau ?
  • Q7. Find out Top 5 highest paid Employees ?

Interview Preparation Tips

Topics to prepare for Wells Fargo Analytics Consultant interview:
  • SQL
  • SAS
  • Excel
Interview preparation tips for other job seekers - Be Cool and Calm .
Ask job related question if they allow you.

Skills evaluated in this interview

Interview experience
5
 Excellent
Difficulty level
 -
Duration
 -
Result
 -

2 Interview Rounds

1

Coding Test Round

I was asked Python, sql, coding questions

2

Case Study Round

Case study on how would you identify the total number of footfall on a airport

Interview experience
5
 Excellent
Difficulty level
 -
Duration
 -
Result
 -

2 Interview Rounds

1

Aptitude Test Round

Many Mcq,s.Similar to cat exam

2

Case Study Round

Ml case study . Eg loan default prediction

Interview experience
4
 Good
Difficulty level
 Moderate
Duration
 4-6 weeks
Result
Selected  Selected

I applied via Naukri.com and was interviewed in Jan 2023.

6 Interview Rounds

1

Resume Shortlist Round

Pro Tip by AmbitionBox:
Don’t add your photo or details such as gender, age, and address in your resume. These details do not add any value.
View all tips
2

Aptitude Test Round

Need to complete online assessments

3

Technical Round (1 Question)

  • Q1. Technical round about the coding of SAS and SQL
4

Team lead round Round (1 Question)

  • Q1. Questions on past experience and SAS coding
5

One-on-one Round (1 Question)

  • Q1. About the job fitment
6

HR Round (1 Question)

  • Q1. Salary discussion round

Data Scientist Interview Questions

Citicorp user image Anonymous

posted on 19 Apr 2024

Interview experience
4
 Good
Difficulty level
 -
Duration
 -
Result
 -

I was interviewed before Apr 2023.

2 Interview Rounds

1

Technical Round (1 Question)

  • Q1. Basic statistics
2

Technical Round (1 Question)

  • Q1. Project related

Interview Preparation Tips

Interview preparation tips for other job seekers - Donot join citi....no job security at all...I joined and was thrown in 3months due to their restructuring and budget issues.very bad management
Interview experience
4
 Good
Difficulty level
 Moderate
Duration
 2-4 weeks
Result
Selected  Selected

I applied via Approached by Company and was interviewed before Apr 2023.

3 Interview Rounds

1

One-on-one Round (2 Questions)

  • Q1. Regarding skill set and intro
  • Q2. Basic intro question on experience
2

Technical Round (1 Question)

  • Q1. Technical skill questions advanced category
3

HR Round (1 Question)

  • Q1. Questions related to relocation if you want to relocate and why would you look to join this org and salary

I applied via Approached by Company and was interviewed before Sep 2021.

3 Interview Rounds

1

Resume Shortlist Round

Pro Tip by AmbitionBox:
Properly align and format text in your resume. A recruiter will have to spend more time reading poorly aligned text, leading to high chances of rejection.
View all tips
2

Technical Round (1 Question)

  • Q1. Projects and Data Science concepts
3

Technical Round (1 Question)

  • Q1. Python and coding skills

Interview Preparation Tips

Interview preparation tips for other job seekers - Be through with concepts - ML, stats, NLP
Interview experience
4
 Good
Difficulty level
 Moderate
Duration
 Less than 2 weeks
Result
Selected  Selected

I applied via Referral and was interviewed before Sep 2022.

3 Interview Rounds

1

Resume Shortlist Round

Pro Tip by AmbitionBox:
Double-check your resume for any spelling mistakes. The recruiter may consider spelling mistakes as careless behavior or poor communication skills.
View all tips
2

Technical Round (1 Question)

  • Q1. Question related to BFSI - mostly from resume, collection startegy, Sas, project handling
3

Technical Round (1 Question)

  • Q1. Case studies related to collection, segmentation, market based questions in contact strategy
Interview experience
4
 Good
Difficulty level
 Moderate
Duration
 Less than 2 weeks
Result
Selected  Selected

I applied via campus placement at Indian Institute of Technology (IIT), Kharagpur and was interviewed before Mar 2023.

3 Interview Rounds

1

Aptitude Test Round

General altitude with MAT level question

2

Technical Round (4 Questions)

  • Q1. Questions from CV, guesstimates, data science questions
  • Q2. What is Random forest
  • Q3. Hypothesis testing
  • Q4. Guesstimates Question on no.of marriage in a year
3

HR Round (1 Question)

  • Q1. Introduction, why Wells, strength, what do I know about it.

Skills evaluated in this interview

Marsh McLennan Interview FAQs

How many rounds are there in Marsh McLennan Analytics Consultant interview for experienced candidates?
Marsh McLennan interview process for experienced candidates usually has 2 rounds. The most common rounds in the Marsh McLennan interview process for experienced candidates are Resume Shortlist and Technical.
What are the top questions asked in Marsh McLennan Analytics Consultant interview for experienced candidates?

Some of the top questions asked at the Marsh McLennan Analytics Consultant interview for experienced candidates -

  1. SQL queries regarding your proj...read more
  2. ETL process and tableau conce...read more
  3. Pratice joining conce...read more

Tell us how to improve this page.

Interview Questions from Similar Companies

TCS Interview Questions
3.7
 • 10k Interviews
Accenture Interview Questions
3.9
 • 7.8k Interviews
Infosys Interview Questions
3.7
 • 7.3k Interviews
Cognizant Interview Questions
3.8
 • 5.4k Interviews
Wipro Interview Questions
3.7
 • 5.2k Interviews
Capgemini Interview Questions
3.8
 • 4.6k Interviews
Tech Mahindra Interview Questions
3.6
 • 3.7k Interviews
HCLTech Interview Questions
3.6
 • 3.6k Interviews
IBM Interview Questions
4.1
 • 2.3k Interviews
View all
Senior Associate
419 salaries
unlock blur

₹2.3 L/yr - ₹6.6 L/yr

Specialist
346 salaries
unlock blur

₹3.3 L/yr - ₹7.9 L/yr

Assistant Manager
256 salaries
unlock blur

₹4.7 L/yr - ₹17.4 L/yr

Associate
242 salaries
unlock blur

₹1.8 L/yr - ₹4.1 L/yr

Senior Analyst
237 salaries
unlock blur

₹2.4 L/yr - ₹6 L/yr

Explore more salaries
Compare Marsh McLennan with

TCS

3.7
Compare

Infosys

3.7
Compare

Wipro

3.7
Compare

HCLTech

3.6
Compare

Calculate your in-hand salary

Confused about how your in-hand salary is calculated? Enter your annual salary (CTC) and get your in-hand salary
Did you find this page helpful?
Yes No
write
Share an Interview