Add office photos
Filter interviews by
Mercer Data Analyst Interview Questions and Answers for Experienced
Updated
14 Feb 2024
1 interview found
Sort by:
Popular
Anonymous
Interview experience
Average
Difficulty level
Easy
Duration
-
Result
Selected
3 Interview Rounds
1
HR Round (1 Question)
- Q1. How good are you with numbers Add Answer
2
Technical Round (1 Question)
- Q1. Vlookup, pivot table, sumif, average, graphs Add Answer
3
Behavioral Round (1 Question)
- Q1. Do you know the role and responsibility of this position Add Answer
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 Mercer?
Ask anonymously on communities.
Interview questions from similar companies
Interview experience
Good
Difficulty level
-
Duration
-
Result
-
1 Interview Round
1
Technical Round (2 Questions)
- Q1. Explain all types of joins View Answers (1)
- Q2. Difference between having and where View Answers (1)
Skills evaluated in this interview
Sohini Bera
Interview experience
Good
Difficulty level
-
Duration
-
Result
-
1 Interview Round
1
One-on-one Round (1 Question)
- Q1. Write a code to determine average salary wrt location View Answers (1)
Interview experience
Excellent
Difficulty level
-
Duration
-
Result
-
2 Interview Rounds
1
Technical Round (2 Questions)
- Q1. Sql intermediate level Add Answer
- Q2. Power bi intermediate level Add Answer
2
HR Round (2 Questions)
- Q1. Family background & earning source Add Answer
- Q2. What you like about EY Add Answer
Interview experience
Good
Difficulty level
Moderate
Duration
Less than 2 weeks
Result
No response
I applied via Indeed and was interviewed in Jan 2024.
2 Interview Rounds
1
HR Round (3 Questions)
- Q1. Basics of power bi and sql Add Answer
- Q2. What are joins and types of join View Answers (1)
- Q3. How to add date table in power bi View Answers (1)
2
Technical Round (4 Questions)
- Q1. Sql scenario based question on joins Add Answer
- Q2. Window function questions Add Answer
- Q3. Performance tuning Add Answer
- Q4. Power bi dax question Add Answer
Skills evaluated in this interview
Interview experience
Excellent
Difficulty level
Moderate
Duration
Less than 2 weeks
Result
Selected
I applied via Referral and was interviewed in Jun 2024.
2 Interview Rounds
1
Case Study Round
Guesstimates related to different scenario
2
Aptitude Test Round
Aptitude questions to check your critical thinking
Interview experience
Average
Difficulty level
-
Duration
-
Result
-
I applied via Recruitment Consulltant and was interviewed in Aug 2024.
2 Interview Rounds
1
Aptitude Test Round
60 min of exam and 30 question of apti
2
HR Round (2 Questions)
- Q1. Salary exption and carrer growth Add Answer
- Q2. Privious organaization Add Answer
Interview experience
Average
Difficulty level
Moderate
Duration
Less than 2 weeks
Result
Selected
I applied via Campus Placement and was interviewed before Apr 2023.
2 Interview Rounds
1
Case Study Round
Business problems were asked and analyzed the approach to solve the problem. Reading case studies would help you here
2
Technical Round (1 Question)
- Q1. Few Statistics questions were asked. Some coding. And all about our resume in depth. Prepare your resume and Stats well. Add Answer
Interview Preparation Tips
Interview preparation tips for other job seekers - Prepare you resume and case studies well.
Interview experience
Good
Difficulty level
Moderate
Duration
Less than 2 weeks
Result
Selected
I applied via Campus Placement and was interviewed before May 2023.
1 Interview Round
1
One-on-one Round (1 Question)
- Q1. Difference between mutual and hedge funds View Answers (1)
Interview Preparation Tips
Interview preparation tips for other job seekers - Just know whatever is written in you resume and be prepared with all the basic financial knowledge
I applied via Approached by Company and was interviewed in Oct 2022.
1 Interview Round
1
Technical Round (2 Questions)
- Q1. Informatica: All scenario based questions. When aggregator will fail, need top and bottom 1 salary. Add Answer
- Q2. Compare 2 scorce files record count and print if their are equally or not View Answers (1)
Interview Preparation Tips
Interview preparation tips for other job seekers - All are purely scenario based questions on informatica
Mercer Interview FAQs
How many rounds are there in Mercer Data Analyst interview for experienced candidates?
Mercer interview process for experienced candidates usually has 3 rounds. The most common rounds in the Mercer interview process for experienced candidates are HR, Technical and Behavioral.
How to prepare for Mercer Data Analyst interview for experienced candidates?
Go through your CV in detail and study all the technologies mentioned in your CV. Prepare at least two technologies or languages in depth if you are appearing for a technical interview at Mercer. The most common topics and skills that interviewers at Mercer expect are Data Analysis, Excel, Marketing, Program Management and Sharepoint.
What are the top questions asked in Mercer Data Analyst interview for experienced candidates?
Some of the top questions asked at the Mercer Data Analyst interview for experienced candidates -
Tell us how to improve this page.
Mercer Interviews By Designations
- Mercer Senior Analyst Interview Questions
- Mercer Analyst Interview Questions
- Mercer Process Developer Interview Questions
- Mercer Investment Consultant Interview Questions
- Mercer Assistant Manager Interview Questions
- Mercer Data Analyst Interview Questions
- Mercer Investment Analyst Interview Questions
- Mercer Lead Analyst Interview Questions
- Show more
Interview Questions for Popular Designations
- Senior Data Analyst Interview Questions
- Junior Data Analyst Interview Questions
- Data Analyst Intern Interview Questions
- Data Engineer Interview Questions
- Data Research Analyst Interview Questions
- Data Scientist Interview Questions
- Data Entry Operator Interview Questions
- Associate Data Analyst Interview Questions
- Show more
Data Analyst Interview Questions from Similar Companies
9%
less
than the average Data Analyst Salary in India
View more details
Mercer Data Analyst Reviews and Ratings
based on 14 reviews
Rating in categories
|
Senior Analyst
1.1k
salaries
|  ₹1.9 L/yr - ₹7.5 L/yr |
|
Process Developer
699
salaries
| ₹2.4 L/yr - ₹9 L/yr |
|
Process Champion
470
salaries
| ₹3.2 L/yr - ₹10 L/yr |
|
Assistant Manager
414
salaries
| ₹5.2 L/yr - ₹15.2 L/yr |
|
Senior Specialist
216
salaries
| ₹5 L/yr - ₹12.3 L/yr |
Explore more salaries
Compare Mercer with
Aon
Compare
Willis Towers Watson
Compare
Marsh McLennan
Compare
Accenture
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 >
- Mercer Interview Questions >
- Mercer Data Analyst Interview Questions for Experienced
Share an Interview