Upload Button Icon Add office photos

Mercer

Compare button icon Compare button icon Compare

Filter interviews by

Mercer Data Analyst Interview Questions and Answers for Freshers

Updated 14 Feb 2024

Mercer Data Analyst Interview Experiences for Freshers

1 interview found

Data Analyst Interview Questions & Answers

user image Anonymous

posted on 15 Dec 2022

I applied via Recruitment Consulltant and was interviewed in Jun 2022. There were 2 interview rounds.

Round 1 - Aptitude Test 

Aptitude have some basic questions that many of us can solve easily not that much difficult.

Round 2 - One-on-one 

(2 Questions)

  • Q1. Nothing much just simple questions about normal calculations, your Introduction, Be Frank keep smile and be confident.
  • 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 sometimes be prepared for to that too.

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.

Interview questions from similar companies

I appeared for an interview before Jan 2021.

Round 1 - Coding Test 

(1 Question)

Round duration - 60 minutes
Round difficulty - Easy

This was an online aptitude round on the Talview platform which we can give from our Home. To attempt this test, we have been given a window of 12-24 hours. It was a proctored online test. The round consisted of 60 aptitude questions in 60 minutes of time without any negative marking. The aptitude test consisted of various questions of Logical Reasoning, Mental Ability, Data Interpretation Questions, Numerical Reasoning.

  • Q1. 

    Matrix Transpose Problem Statement

    Given a matrix MAT, your task is to return the transpose of the matrix. The transpose of a matrix is obtained by converting rows into columns and vice versa. Specificall...

  • Ans. 

    Transpose a given matrix by switching rows and columns.

    • Iterate through the matrix and swap elements at [i][j] with [j][i].

    • Create a new matrix to store the transposed values.

    • Ensure the dimensions of the transposed matrix are reversed from the original matrix.

  • Answered by AI
Round 2 - Video Call 

Round duration - 30 minutes
Round difficulty - Medium

This was a video interview round taken immediately after the Aptitude test, it was a proctored round on Talview platform. This round consisted of 8 questions, we have to answer each question in the span of 3 mins and 10 secs were given for reading the question, our audio and video was being recorded while answering those questions. Our soft skills were being judged in this round. The questions basically consisted of HR questions and Guesstimates

Round 3 - Video Call 

Round duration - 120 minutes
Round difficulty - Hard

This round was the case study round, in this round, we were provided a case study which we had to solve in 1 hour using pen and paper and had to share the answers of the case study questions in a PDF format to the HR, the questions were related to market share, advertisement strategies, and can be easily solved using basic mathematics. After this, there was be a one-to-one interview on Zoom Platform in which the interviewer will ask you to describe your approach for every question you have solved in the case study, they will not ask for the exact answer, all they ask is about your approach that you have used to solve a particular problem and the way you explain it. They may or may not ask some guesstimates or puzzles as well in this round. The interviewer was very friendly and he gave me hints as well if I was stuck somewhere.

Round 4 - Video Call 

(1 Question)

Round duration - 60 minutes
Round difficulty - Hard

The next round was the Behavioral interview round, in this round, the interviewer asked me about my projects and some guesstimates or puzzles. This round was for 1 hour. The interviewer was very friendly and helpful, she helped me if I was stuck somewhere, she kept me calm during the interview process.

  • Q1. How many people do you estimate watched Ramayana/Mahabharat during the first month of the Covid lockdown in 2020?
Round 5 - Video Call 

(1 Question)

Round duration - 40 minutes
Round difficulty - Hard

The fit round was my final interview round, in this, you will meet the manager/Principal from the company. They will basically check whether you are fit for the organization. They ask about the projects I have done in college/internships. Some basic questions like what are your strengths and weaknesses, why do you want to join the company and some guesstimates or puzzles as well.
On-campus, the behavioral and fit interview rounds were combined into one.
This round was of 40 minutes and the interview was taken on Zoom, the interviewer was helpful and sweet.

  • Q1. How many pizzas are sold in one day in Pune?
  • Ans. 

    The number of pizzas sold in Pune in one day varies depending on factors like day of the week, weather, events, etc.

    • The number of pizzas sold in Pune can range from hundreds to thousands in a day.

    • Factors like day of the week (weekend vs weekday), weather (rainy vs sunny), events (festivals, holidays) can impact the sales.

    • Popular pizza outlets in Pune like Domino's, Pizza Hut, etc. contribute to the overall sales.

    • Data f...

  • Answered by AI

Interview Preparation Tips

Professional and academic backgroundI applied for the job as Data Analyst in GurgaonEligibility criteriaAbove 6.5 CGPA in B. TechZS Associates interview preparation:Topics to prepare for the interview - Aptitude, Guesstimates, Puzzles, HR questions, Resume Related QuestionsTime required to prepare for the interview - 2 monthsInterview preparation tips for other job seekers

Tip 1 : Prepare well for guesstimates and puzzles.
Tip 2 : Practice Data Interpretation Questions.
Tip 3 : Be well versed with your projects.

Application resume tips for other job seekers

Tip 1 : The resume should be very precise and concise
Tip 2 : Do not add such skills in your resume in which you're not comfortable.

Final outcome of the interviewSelected

Skills evaluated in this interview

I applied via Naukri.com and was interviewed before Oct 2020. There were 3 interview rounds.

Interview Questionnaire 

2 Questions

  • Q1. Write a query where all the customer name start with A
  • Ans. 

    Query to retrieve all customer names starting with A.

    • Use the SELECT statement to retrieve customer names.

    • Use the LIKE operator with the pattern 'A%' to match names starting with A.

    • Specify the table and column name where the customer names are stored.

    • Example: SELECT customer_name FROM customers WHERE customer_name LIKE 'A%';

  • Answered by AI
  • Q2. Write a query where we'll get state wise sales summary report. Actually in this query we have to join multiple table and finding the rank .

Interview Preparation Tips

Interview preparation tips for other job seekers - Interview was extremely easy and smooth.

Skills evaluated in this interview

I applied via Job Portal and was interviewed before Jan 2021. There were 2 interview rounds.

Round 1 - Aptitude Test 
Round 2 - Resume Shortlist 
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

Interview Preparation Tips

Topics to prepare for Deloitte Data Analyst interview:
  • Procurement
  • Marketing
  • Career goal
Interview preparation tips for other job seekers - Location should be Delhi NCR,Monday would be good
Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
2-4 weeks
Result
Selected Selected

I applied via Naukri.com and was interviewed in Mar 2024. There were 3 interview rounds.

Round 1 - Aptitude Test 

Basic aptitude questions liek tiem distance, percentage , ratio, work and hour

Round 2 - Coding Test 

Excel, Numpy, Pandas, basic ML

Round 3 - Case Study 

Case study talking about how to optimise the supply chain using data analytics

Interview experience
4
Good
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Naukri.com and was interviewed in Jan 2024. There was 1 interview round.

Round 1 - HR 

(2 Questions)

  • Q1. Tell me about yourself
  • Q2. Expected salary
Interview experience
5
Excellent
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Technical 

(2 Questions)

  • Q1. Power BI Difference between ALL() and ALLSELECTED()
  • Ans. 

    ALL() ignores all filters in the query context, while ALLSELECTED() ignores only filters on columns in the visual.

    • ALL() removes all filters from the specified column or table.

    • ALLSELECTED() removes filters from the specified column or table, but keeps filters on other columns in the visual.

    • Example: ALL('Table') would remove all filters on the 'Table' in the query context.

    • Example: ALLSELECTED('Column') would remove filte...

  • Answered by AI
  • Q2. Excel Difference between COUNT() and COUNTA()
  • Ans. 

    COUNT() counts only numeric values, while COUNTA() counts all non-empty cells.

    • COUNT() counts only cells with numerical values.

    • COUNTA() counts all non-empty cells, including text and errors.

    • Example: COUNT(A1:A5) will count only cells with numbers, while COUNTA(A1:A5) will count all non-empty cells.

  • Answered by AI
Round 2 - Technical 

(2 Questions)

  • Q1. Resume based questions like explain the projects that you have done.
  • Q2. Sample dataset questions

Skills evaluated in this interview

Interview experience
4
Good
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Aptitude Test 

Basic maths questions, just be very quick

Round 2 - Case Study 

Sales report, asked to analyzs data and take steps accordingly to upheld company's profit.

Round 3 - HR 

(1 Question)

  • Q1. Puzzles, riddles, guesstimates, need good communication skills
Interview experience
5
Excellent
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Technical 

(1 Question)

  • Q1. Master data management
Round 2 - HR 

(1 Question)

  • Q1. How was your Technical interview experience
Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Referral and was interviewed in Jun 2024. There were 2 interview rounds.

Round 1 - Case Study 

Guesstimates related to different scenario

Round 2 - Aptitude Test 

Aptitude questions to check your critical thinking

Mercer Interview FAQs

How many rounds are there in Mercer Data Analyst interview for freshers?
Mercer interview process for freshers usually has 3 rounds. The most common rounds in the Mercer interview process for freshers are Resume Shortlist, Aptitude Test and One-on-one Round.
How to prepare for Mercer Data Analyst interview for freshers?
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 freshers?

Some of the top questions asked at the Mercer Data Analyst interview for freshers -

  1. They also checked your communication skills, grammar skills or some times they ...read more
  2. Nothing much just simple questions about normal calculations, your Introduction...read more
  3. Vlookup, pivot table, sumif, average, gra...read more

Tell us how to improve this page.

Mercer Data Analyst Salary
based on 88 salaries
₹2.2 L/yr - ₹9.6 L/yr
14% less than the average Data Analyst Salary in India
View more details

Mercer Data Analyst Reviews and Ratings

based on 14 reviews

3.5/5

Rating in categories

3.1

Skill development

3.5

Work-life balance

2.6

Salary

3.8

Job security

2.9

Company culture

2.9

Promotions

3.2

Work satisfaction

Explore 14 Reviews and Ratings
Senior Analyst
1.1k salaries
unlock blur

₹1.9 L/yr - ₹8 L/yr

Process Developer
671 salaries
unlock blur

₹2.7 L/yr - ₹8.1 L/yr

Process Champion
430 salaries
unlock blur

₹3.2 L/yr - ₹10 L/yr

Assistant Manager
409 salaries
unlock blur

₹5 L/yr - ₹15.2 L/yr

Senior Specialist
251 salaries
unlock blur

₹4.5 L/yr - ₹13.4 L/yr

Explore more salaries
Compare Mercer with

Deloitte

3.8
Compare

Ernst & Young

3.4
Compare

PwC

3.4
Compare

KPMG India

3.5
Compare
Did you find this page helpful?
Yes No
write
Share an Interview