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
Compare
Filter interviews by
Marsh McLennan Analytics Consultant Interview Questions and Answers
Updated
9 Aug 2023
1 interview found
Sort by:
Popular
Anonymous
Interview experience
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 View Answers (1)
- Q2. Pratice joining concepts View Answers (1)
- Q3. Regarding end to end intercation with your project manager Add Answer
- Q4. ETL process and tableau concepts Add Answer
- Q5. Dashboard related to Tableau Add Answer
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
- Don't make you down at the time of interview.
- Answer what's real
Top trending discussions
View All
Interview Tips & Stories
2w (edited)
a consultant
Alternate documents for Employee verification?
My new employer asked for my previous offer letters and salary slips. When I inquired, they said it was for background verification.
However, I feel that providing these documents might affect salary negotiations, and it feels a bit unethical too.
What alternative documents can I provide for employment verification?
Got a question about Marsh McLennan?
Ask anonymously on communities.
Interview questions from similar companies
Interview experience
Excellent
Difficulty level
-
Duration
-
Result
-
1 Interview Round
1
One-on-one Round (2 Questions)
- Q1. SQL , Oracle SQL, distinct Add Answer
- Q2. SQL, analytical SQL query Add Answer
Interview experience
Average
Difficulty level
Moderate
Duration
-
Result
No response
I was interviewed in Jan 2024.
1 Interview Round
1
Technical Round (1 Question)
- Q1. 1. Macro quoting functions in SAS 2. ways to create macro variable in Data step 3. date functions-intck() and intnx() 4.situational scenario based questions 5.A...read more View Answers (1)
Interview Preparation Tips
Topics to prepare for Wells Fargo Analytics Consultant interview:
- SAS
- SQL
Skills evaluated in this interview
Interview experience
Excellent
Difficulty level
Hard
Duration
Less than 2 weeks
Result
Not Selected
I applied via Recruitment Consulltant and was interviewed in Jan 2024.
1 Interview Round
1
Technical Round (1 Question)
- Q1. SQL hard questions Add Answer
Interview Preparation Tips
Interview preparation tips for other job seekers - Prepare v hard for sql
Interview experience
Excellent
Difficulty level
Easy
Duration
4-6 weeks
Result
Selected
I applied via Naukri.com and was interviewed before Feb 2023.
1 Interview Round
1
Technical Round (2 Questions)
- Q1. What projects I worked before Add Answer
- Q2. Behavioural questions Add Answer
Interview experience
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? View Answers (2)
- Q2. Delete duplicate Records in SQL View Answers (2)
- Q3. What are the different types of Join used in SQL? View Answers (3)
- Q4. What is subquary ? Why it is required ? View Answers (1)
- Q5. What is the meaning of Trigger in Python? View Answers (1)
- Q6. Componets of Tableau ? What are the different connection is there in Tableau ? View Answers (1)
- Q7. Find out Top 5 highest paid Employees ? View Answers (1)
Interview Preparation Tips
Topics to prepare for Wells Fargo Analytics Consultant interview:
Ask job related question if they allow you.
- SQL
- SAS
- Excel
Ask job related question if they allow you.
Skills evaluated in this interview
Interview experience
Good
Difficulty level
Moderate
Duration
2-4 weeks
Result
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 Add Answer
- Q2. Basic intro question on experience Add Answer
2
Technical Round (1 Question)
- Q1. Technical skill questions advanced category Add Answer
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 Add Answer
Interview experience
Good
Difficulty level
Moderate
Duration
Less than 2 weeks
Result
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 Add Answer
- Q2. What is Random forest View Answers (1)
- Q3. Hypothesis testing Add Answer
- Q4. Guesstimates Question on no.of marriage in a year Add Answer
3
HR Round (1 Question)
- Q1. Introduction, why Wells, strength, what do I know about it. Add Answer
Skills evaluated in this interview
Interview experience
Good
Difficulty level
Easy
Duration
2-4 weeks
Result
Selected
I applied via Approached by Company and was interviewed before Apr 2023.
1 Interview Round
1
Technical Round (2 Questions)
- Q1. Explain end to end data solution and how did you handle a challenging or difficult situation in current role ? View Answers (1)
- Q2. Thoroughly explain the project, process, platform, components, integrations and development life cycle followed. With an example, explain how you handled a comp...read more View Answers (1)
Interview Preparation Tips
Interview preparation tips for other job seekers - Na
Interview experience
Good
Difficulty level
Easy
Duration
Less than 2 weeks
Result
Selected
I applied via Internal and was interviewed before Aug 2022.
3 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
One-on-one Round (3 Questions)
- Q1. About Roles and Responsibilities Add Answer
- Q2. Tableau Application Add Answer
- Q3. Powerbi Application Add Answer
3
One-on-one Round (1 Question)
- Q1. Salary Discussion Add Answer
Marsh McLennan Interview FAQs
How many rounds are there in Marsh McLennan Analytics Consultant interview?
Marsh McLennan interview process usually has 2 rounds. The most common rounds in the Marsh McLennan interview process are Technical and Resume Shortlist.
Tell us how to improve this page.
Marsh McLennan Interviews By Designations
- Marsh McLennan Associate Interview Questions
- Marsh McLennan Analyst Interview Questions
- Marsh McLennan Accountant Interview Questions
- Marsh McLennan Actuarial Analyst Interview Questions
- Marsh McLennan Analytics Consultant Interview Questions
- Marsh McLennan Application Development Engineer Interview Questions
- Marsh McLennan Application Development Manager Interview Questions
- Marsh McLennan Associate Consultant Interview Questions
- Show more
Interview Questions for Popular Designations
- Analytics Manager Interview Questions
- Decision Analytics Associate Interview Questions
- Senior Analytics Consultant Interview Questions
- Data Scientist Interview Questions
- Analytics Specialist Interview Questions
- Analytics Executive Interview Questions
- Senior Data Analyst Interview Questions
- Assistant Manager Analytics Interview Questions
- Show more
Interview Questions from Similar Companies
|
Senior Associate
419
salaries
|  ₹2.3 L/yr - ₹6.6 L/yr |
|
Specialist
346
salaries
| ₹3.3 L/yr - ₹7.9 L/yr |
|
Assistant Manager
256
salaries
| ₹4.7 L/yr - ₹17.4 L/yr |
|
Associate
242
salaries
| ₹1.8 L/yr - ₹4.1 L/yr |
|
Senior Analyst
237
salaries
| ₹2.4 L/yr - ₹6 L/yr |
Explore more salaries
Compare Marsh McLennan with
TCS
Compare
Infosys
Compare
Wipro
Compare
HCLTech
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
- Home >
- Interviews >
- Marsh McLennan Interview Questions >
- Marsh McLennan Analytics Consultant Interview Questions
Share an Interview