AmbitionBox
Interview Questions
- Reviews
- Salaries
- Interview Questions
- About Company
- Benefits
- Jobs
- Office Photos
- Community
Add office photos
Filter interviews by
Clear (1)
Mercer Data Analyst Interview Questions and Answers
Mercer Data Analyst Interview Experiences
2 interviews found
Anonymous
Selected
(1 Question)
- Q1. How good are you with numbers
(1 Question)
- Q1. Vlookup, pivot table, sumif, average, graphs
(1 Question)
- Q1. Do you know the role and responsibility of this position
I applied via Recruitment Consulltant and was interviewed in Jun 2022. There were 2 interview rounds.
Aptitude have some basic questions that many of us can solve easily not that much difficult.
(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
I don't know if they do hiring directly.
Top trending discussions
Interview questions from similar companies
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%';
- 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
Skills evaluated in this interview
Interview Questionnaire
2 Questions
- Q1. What is Data
- Ans.
Data is a collection of facts, figures, or statistics that can be analyzed to gain insights and make informed decisions.
Data can be structured or unstructured
Data can be qualitative or quantitative
Examples of data include customer demographics, sales figures, and website traffic
Data can be analyzed using various tools and techniques to extract meaningful insights
- Q2. Data types
Skills evaluated in this interview
I applied via LinkedIn and was interviewed before Nov 2020. There were 4 interview rounds.
Interview Questionnaire
1 Question
- Q1. Real life example of usage of Window functions - lag and lead
- Ans.
Window functions like lag and lead are used to analyze data over a specific range or window.
Lag function can be used to calculate the difference between current and previous values in a time series data.
Lead function can be used to calculate the difference between current and future values in a time series data.
Window functions can be used to calculate moving averages, cumulative sums, and other statistical measures.
Fo...
Interview Preparation Tips
Skills evaluated in this interview
I applied via Naukri.com and was interviewed in Jun 2021. There were 3 interview rounds.
Interview Questionnaire
1 Question
- Q1. About SAP BODS
Interview Preparation Tips
I applied via Company Website and was interviewed in Apr 2021. There was 1 interview round.
Interview Questionnaire
1 Question
- Q1. Why should we hire you?
- Ans. Because you will never get some one like me.
Interview Preparation Tips
Interview Questionnaire
1 Question
- Q1. SQL, Power Bi, Python, Azure
Interview Preparation Tips
I applied via Campus Placement and was interviewed before Jun 2021. There was 1 interview round.
(1 Question)
- Q1. Questions on SQL, C++
Interview Preparation Tips
I applied via Walk-in and was interviewed before Jun 2020. There was 1 interview round.
Interview Questionnaire
1 Question
- Q1. Da tools
Interview Preparation Tips
Mercer Interview FAQs
Some of the top questions asked at the Mercer Data Analyst interview -
Recently Viewed
DESIGNATION
SALARIES
SmartQ - Bottle Lab Technologies
No Salaries
REVIEWS
Hindustan Times
No Reviews
INTERVIEWS
Formative Creators
No Interviews
COMPANY BENEFITS
SmartQ - Bottle Lab Technologies
No Benefits
SALARIES
Megh Computing
No Salaries
LIST OF COMPANIES
SmartQ - Bottle Lab Technologies
Overview
SALARIES
Tata Elxsi
SALARIES
Northwest Executive Education
No Salaries
INTERVIEWS
eVidyaloka Trust
No Interviews
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 Senior Specialist Interview Questions
- Mercer Data Analyst Interview Questions
- Mercer Assistant Manager Interview Questions
- Mercer Investment 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
- Data Science Analyst Interview Questions
- Show more
Mercer Data Analyst Interview Process
based on 2 interviews
Interview experience
Data Analyst Interview Questions from Similar Companies
Mercer Data Analyst Reviews and Ratings
based on 14 reviews
Rating in categories
|
Senior Analyst
1.1k
salaries
|  ₹0 L/yr - ₹0 L/yr |
|
Process Developer
684
salaries
| ₹0 L/yr - ₹0 L/yr |
|
Process Champion
461
salaries
| ₹0 L/yr - ₹0 L/yr |
|
Assistant Manager
407
salaries
| ₹0 L/yr - ₹0 L/yr |
|
Senior Specialist
255
salaries
| ₹0 L/yr - ₹0 L/yr |
Aon
Willis Towers Watson
Marsh McLennan
Accenture
- Home >
- Interviews >
- Mercer Interview Questions >
- Mercer Data Analyst Interview Questions
