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
Interview experience
Average
Difficulty level
Easy
Duration
Less than 2 weeks
Result
Not Selected
I applied via Naukri.com and was interviewed in Nov 2024.
1 Interview Round
1
Technical Round (4 Questions)
- Q1. Was Given two small tables and was asked the total no of rows returned for each kind of join. Add Answer
- Q2. In Tableau if the underlining table columns keep on changing than what can be done so that it wont affect on the view level. View Answers (1)
- Q3. Row level security Add Answer
- Q4. Tell me about your project View Answers (1)
Interview Preparation Tips
Interview preparation tips for other job seekers - Focus on SQL mainly on joins and be prepared to explain your project in detail.
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
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
Shaonly Chowdhury
Interview experience
Average
Difficulty level
-
Duration
-
Result
-
1 Interview Round
1
Technical Round (2 Questions)
- Q1. Sql questions checking ur knowledge Add Answer
- Q2. Self join questions about sql Add Answer
Interview experience
Average
Difficulty level
Moderate
Duration
Less than 2 weeks
Result
Not Selected
I applied via Naukri.com and was interviewed in Sep 2024.
1 Interview Round
1
Technical Round (1 Question)
- Q1. Tableau, SQL related question Add Answer
Monika Singh
Interview experience
Excellent
Difficulty level
Hard
Duration
2-4 weeks
Result
Not Selected
I applied via Naukri.com and was interviewed in Jun 2024.
2 Interview Rounds
1
Assignment Round
Data related, aptitude, English
2
One-on-one Round (2 Questions)
- Q1. Asked for a quick intro Add Answer
- Q2. Basic to advance SQL question Add Answer
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
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 Resume Shortlist, Aptitude Test and One-on-one Round.
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
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
Share an Interview