Add office photos
Filter interviews by
Mercer Data Analyst Interview Questions and Answers
Updated
14 Feb 2024
2 interviews found
Sort by:
Popular
Anonymous
I applied via Recruitment Consulltant and was interviewed in Jun 2022.
2 Interview Rounds
1
Aptitude Test Round
Aptitude have some basic questions that many of us can solve easily not that much difficult.
2
One-on-one Round (2 Questions)
- Q1. Nothing much just simple questions about normal calculations, your Introduction, Be Frank keep smile and be confident. Add Answer
- Q2. They also checked your communication skills, grammar skills or some times they assign you to write formal letter or e-mails which could be pretty difficult some...read more Add Answer
Interview Preparation Tips
Interview preparation tips for other job seekers - You will be signed as contenjant ( Contract Basis) if you go from third party
I don't know if they do hiring directly.
I don't know if they do hiring directly.
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
tejas jain
Interview experience
Good
Difficulty level
Moderate
Duration
Less than 2 weeks
Result
No response
I applied via Newspaper Ad and was interviewed in Aug 2024.
3 Interview Rounds
1
Aptitude Test Round
Three sections are there 1) Aptitude Test 2) SQL 3) DSA
2
Technical Round (2 Questions)
- Q1. What is DSA , sorting , difference between array and linked list View Answers (1)
- Q2. Written a SQL query Add Answer
3
HR Round (2 Questions)
- Q1. Coding question like add numbers Add Answer
- Q2. Experience on your project View Answers (1)
Skills evaluated in this interview
Interview experience
Excellent
Difficulty level
-
Duration
-
Result
-
2 Interview Rounds
1
Technical Round (2 Questions)
- Q1. Power BI
Difference between ALL() and ALLSELECTED() View Answers (1)
- Q2. Excel
Difference between COUNT() and COUNTA() View Answers (1)
2
Technical Round (2 Questions)
- Q1. Resume based questions like explain the projects that you have done. Add Answer
- Q2. Sample dataset questions Add Answer
Skills evaluated in this interview
priyam Gawade
Interview experience
Good
Difficulty level
-
Duration
-
Result
-
2 Interview Rounds
1
HR Round (2 Questions)
- Q1. Tell me about yourself View Answers (1)
- Q2. Why should we hire you View Answers (1)
2
Technical Round (2 Questions)
- Q1. What is use of excel in this data field View Answers (1)
- Q2. Difference between vlookup & hlookup View Answers (1)
Interview experience
Good
Difficulty level
Moderate
Duration
Less than 2 weeks
Result
Selected
I applied via campus placement at Lady Shri Ram College for Women, Delhi
4 Interview Rounds
1
Aptitude Test Round
Basic English, Quants and Statistics
2
Group Discussion Round
Easy, relevant to pandemic
3
Technical Round (1 Question)
- Q1. Python, Tableau, SQL, Stats, ML, all questions easy to medium level Add Answer
4
One-on-one Round (2 Questions)
- Q1. Behavioural Questions Add Answer
- Q2. Statistics Case Study Add Answer
Interview Preparation Tips
Interview preparation tips for other job seekers - Good and organized interview process for the post of Data Analyst
Chaithra Anil
Interview experience
Excellent
Difficulty level
-
Duration
-
Result
-
2 Interview Rounds
1
Technical Round (2 Questions)
- Q1. First screening was aptitude test Add Answer
- Q2. Discuss technical skills Add Answer
2
HR Round (1 Question)
- Q1. The interview was pretty simple. 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
2-4 weeks
Result
Selected
I applied via Naukri.com and was interviewed in Mar 2024.
3 Interview Rounds
1
Aptitude Test Round
Basic aptitude questions liek tiem distance, percentage , ratio, work and hour
2
Coding Test Round
Excel, Numpy, Pandas, basic ML
3
Case Study Round
Case study talking about how to optimise the supply chain using data analytics
Interview experience
Good
Difficulty level
-
Duration
-
Result
-
1 Interview Round
1
Technical Round (1 Question)
- Q1. Hard DP level DSA question Add Answer
Mercer Interview FAQs
How many rounds are there in Mercer Data Analyst interview?
Mercer interview process usually has 3 rounds. The most common rounds in the Mercer interview process are HR, Technical and Behavioral.
How to prepare for Mercer Data Analyst interview?
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?
Some of the top questions asked at the Mercer Data Analyst interview -
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
7%
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
413
salaries
| ₹5 L/yr - ₹15.2 L/yr |
|
Senior Specialist
218
salaries
| ₹4.8 L/yr - ₹12.1 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
Share an Interview