Upload Button Icon Add office photos

Merck

Compare button icon Compare button icon Compare

Filter interviews by

Merck Data Analyst Interview Questions and Answers

Updated 2 Nov 2024

Merck Data Analyst Interview Experiences

2 interviews found

Data Analyst Interview Questions & Answers

user image Anonymous

posted on 2 Nov 2024

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

I applied via Recruitment Consulltant and was interviewed in Oct 2024. There were 2 interview rounds.

Round 1 - Aptitude Test 

Logical reasoning numerical English sum

Round 2 - Coding Test 

Python power bi sql tablue

Interview Preparation Tips

Topics to prepare for Merck Data Analyst interview:
  • Python
  • SQL
  • Power Bi
  • Tablu
Interview preparation tips for other job seekers - No

Data Analyst Interview Questions & Answers

user image Nishant Deswal

posted on 19 Sep 2024

Interview experience
5
Excellent
Difficulty level
-
Process Duration
-
Result
-

I applied via Campus Placement

Round 1 - Aptitude Test 

It was a 90 mins round, and we have to do 85 questions. Coding was also a part of it.

Data Analyst Interview Questions Asked at Other Companies

asked in Deloitte
Q1. Suppose there is a room in the office and X people enter room thr ... read more
asked in Wipro
Q2. Chocolate Distribution Problem You are given an array/list CHOCOL ... read more
asked in Wipro
Q3. Ninja and Substrings Problem Statement Ninja has to determine all ... read more
asked in Capgemini
Q4. Ninja and His Secret Information Encoding Problem Ninja, a new me ... read more
Q5. Sliding Window Maximum Problem Statement You are given an array/l ... read more

Interview questions from similar companies

Interview experience
5
Excellent
Difficulty level
Easy
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via LinkedIn and was interviewed before Dec 2023. There were 3 interview rounds.

Round 1 - HR 

(1 Question)

  • Q1. Basic introduction with HR on call
Round 2 - Technical 

(1 Question)

  • Q1. Technical questions with respect to SQL and SAS, complexity was easy to medium.
Round 3 - One-on-one 

(1 Question)

  • Q1. Manager asked during the final round regarding the job, your motivation to join the company, and about my role in previous organization.

Interview Preparation Tips

Topics to prepare for Eli Lilly and Company Data Analyst interview:
  • SQL
  • SAS
Interview experience
4
Good
Difficulty level
Moderate
Process Duration
4-6 weeks
Result
Not Selected

I applied via Company Website and was interviewed in Feb 2024. There were 3 interview rounds.

Round 1 - HR 

(1 Question)

  • Q1. Why did you choose to work at Pfizer?
Round 2 - One-on-one 

(1 Question)

  • Q1. Tell me about your project
Round 3 - Group Discussion 

Time management and organization skills

I applied via Recruitment Consulltant and was interviewed before May 2021. There were 4 interview rounds.

Round 1 - 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
Round 2 - Technical 

(3 Questions)

  • Q1. Questions related to Data analytics and SharePoint for my role.
  • Q2. Previous projects and their solutions.
  • Q3. Tool used in previous company. (SharePoint, Power BI, Nintex, InfoPath, Power Apps, Workflows)
Round 3 - Interview 

(1 Question)

  • Q1. Related to professional life and assurance to work.
Round 4 - HR 

(1 Question)

  • Q1. Salary details and candidature check.

Interview Preparation Tips

Interview preparation tips for other job seekers - Prepare well with you technical rounds. It will be medium level (not to easy or difficult in cracking the interview).
Interview experience
4
Good
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Technical 

(2 Questions)

  • Q1. What time intelligence functions can be used for ytd and qtd analysis
  • Ans. 

    Time intelligence functions like YTD (Year-to-Date) and QTD (Quarter-to-Date) can be used for YTD and QTD analysis in data analytics.

    • YTD analysis can be done using functions like YTD() or TOTALYTD() to calculate values from the beginning of the year up to the selected date.

    • QTD analysis can be done using functions like QTD() or TOTALQTD() to calculate values from the beginning of the quarter up to the selected date.

    • Thes...

  • Answered by AI
  • Q2. Difference between import and direct query
  • Ans. 

    Import brings data into Power BI for further analysis, while direct query connects to data source in real-time.

    • Import: Data is loaded into Power BI for analysis, improving performance but requiring periodic refreshes.

    • Direct Query: Connects to data source in real-time, allowing for up-to-date information but potentially slower performance.

    • Import is suitable for smaller datasets, while direct query is better for large da

  • Answered by AI

Skills evaluated in this interview

Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Company Website and was interviewed in Jul 2023. There were 6 interview rounds.

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

Basic questions based on sql theories and excel

Round 3 - Assignment 

Assignment to solve excel sheets using advanced excel functions

Round 4 - Technical 

(1 Question)

  • Q1. Common interview questions, index match, self join, SQL theoretical questions ( types of join, union and union all , delete and truncate difference), data modelling using excel, count if, case study.
Round 5 - Technical 

(1 Question)

  • Q1. Previous experience and personal questions and tools knowledge
Round 6 - HR 

(1 Question)

  • Q1. Salary discussion round

Interview Preparation Tips

Interview preparation tips for other job seekers - Be prepared
Interview experience
3
Average
Difficulty level
Easy
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Approached by Company and was interviewed in Apr 2024. There was 1 interview round.

Round 1 - Technical 

(2 Questions)

  • Q1. Data management
  • Q2. Excel pivot, Vlookup

Interview Preparation Tips

Interview preparation tips for other job seekers - know more about the role in JD
Interview experience
4
Good
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
-

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

Round 1 - One-on-one 

(1 Question)

  • Q1. About Sql, project and work we did
Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
4-6 weeks
Result
Not Selected

I applied via Approached by Company and was interviewed before Aug 2023. There was 1 interview round.

Round 1 - HR 

(2 Questions)

  • Q1. Tell me about your experiences
  • Ans. 

    I have experience working as a data analyst in various industries, utilizing statistical analysis and data visualization tools.

    • Worked as a data analyst at XYZ Company, analyzing sales data to identify trends and make recommendations for improvement

    • Utilized SQL and Python to extract and manipulate data from databases

    • Created interactive dashboards using Tableau to present findings to stakeholders

    • Performed A/B testing to ...

  • Answered by AI
  • Q2. What is the one thing that eli lilly has as a pharmaceutical brand

Merck Interview FAQs

How many rounds are there in Merck Data Analyst interview?
Merck interview process usually has 1-2 rounds. The most common rounds in the Merck interview process are Aptitude Test and Coding Test.
How to prepare for Merck 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 Merck. The most common topics and skills that interviewers at Merck expect are ERP Systems, Financial Analysis, Project Management, Analytical Chemistry and Budgeting.

Tell us how to improve this page.

Merck Data Analyst Interview Process

based on 2 interviews

Interview experience

4.5
  
Good
View more
Merck Data Analyst Salary
based on 18 salaries
₹3.8 L/yr - ₹9 L/yr
15% less than the average Data Analyst Salary in India
View more details

Merck Data Analyst Reviews and Ratings

based on 2 reviews

5.0/5

Rating in categories

5.0

Skill development

5.0

Work-life balance

5.0

Salary

5.0

Job security

5.0

Company culture

5.0

Promotions

5.0

Work satisfaction

Explore 2 Reviews and Ratings
Senior Analyst
138 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Analyst
65 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

System Engineer
39 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Specialist
37 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Senior Systems Engineer
36 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Explore more salaries
Compare Merck with

Pfizer

4.0
Compare

GlaxoSmithKline Pharmaceuticals

4.1
Compare

Novartis

4.1
Compare

Johnson & Johnson

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