Upload Button Icon Add office photos

Merck

Compare button icon Compare button icon Compare

Filter interviews by

Merck Business Analyst Interview Questions and Answers

Updated 11 Dec 2021

Merck Business Analyst Interview Experiences

1 interview found

I applied via LinkedIn and was interviewed in Nov 2021. There were 5 interview rounds.

Interview Questionnaire 

1 Question

  • Q1. Excel and SQL

Interview Preparation Tips

Interview preparation tips for other job seekers - Prepare Excel and SQL well

Interview questions from similar companies

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

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

Round 1 - One-on-one 

(2 Questions)

  • Q1. BI and excel presentation on sales related data: all the questions were asked from the presentation only.
  • Q2. Why I am switching my job?

Interview Preparation Tips

Topics to prepare for AstraZeneca Data Analyst interview:
  • Power Bi
  • Advanced Excel
  • sales data
Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Not Selected

I applied via Naukri.com and was interviewed in May 2024. There were 2 interview rounds.

Round 1 - Technical 

(2 Questions)

  • Q1. What is lamda function
  • Ans. 

    Lambda function is an anonymous function in programming that can have multiple arguments but can only have one expression.

    • Lambda functions are used for creating small, one-time use functions without the need to define a formal function.

    • They are often used in functional programming languages like Python.

    • Lambda functions can take any number of arguments, but can only have one expression.

    • Example: lambda x: x*2 defines a l

  • Answered by AI
  • Q2. Difference between list and tuple
  • Ans. 

    List is mutable, tuple is immutable in Python.

    • List can be modified after creation, tuple cannot.

    • List uses square brackets [], tuple uses parentheses ().

    • List is used for collections of items that may change, tuple for fixed collections.

    • Example: list_example = [1, 2, 3], tuple_example = (4, 5, 6)

  • Answered by AI
Round 2 - HR 

(2 Questions)

  • Q1. Explain your previous work experience
  • Q2. Explain with example how your work related to real life example

Interview Preparation Tips

Interview preparation tips for other job seekers - Prepare very well for the job description give most of the questions will be based on that

Skills evaluated in this interview

Interview experience
5
Excellent
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Technical 

(1 Question)

  • Q1. What are the basics of power bi
  • Ans. 

    Power BI is a business analytics tool by Microsoft for visualizing and analyzing data.

    • Power BI is a business analytics tool by Microsoft

    • It allows users to visualize and analyze data from various sources

    • Users can create interactive reports and dashboards

    • Power BI offers a wide range of data connectors for seamless integration

    • It provides features like data modeling, data preparation, and data visualization

    • Power BI can be ...

  • Answered by AI

Skills evaluated in this interview

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

Data Analyst Interview Questions & Answers

Bayer user image Virendra Chavhan

posted on 23 Mar 2024

Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
4-6 weeks
Result
Selected Selected

I applied via LinkedIn and was interviewed before Mar 2023. There were 2 interview rounds.

Round 1 - Technical 

(3 Questions)

  • Q1. Coding questions on python
  • Q2. Version control system GitHub questions
  • Q3. Web scraping questions
Round 2 - Technical 

(1 Question)

  • Q1. Behavioral questions on senarioy
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

Merck Interview FAQs

How to prepare for Merck Business 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 Clinical Data Management, Python, Analytical Skills, Application Support and Business Analysis.

Tell us how to improve this page.

Interview Questions from Similar Companies

Hetero Interview Questions
3.9
 • 223 Interviews
Abbott Interview Questions
4.1
 • 147 Interviews
Novartis Interview Questions
4.1
 • 140 Interviews
Viatris Interview Questions
4.2
 • 136 Interviews
Micro Labs Interview Questions
3.6
 • 125 Interviews
Biological E Interview Questions
4.2
 • 112 Interviews
Piramal Pharma Interview Questions
4.0
 • 92 Interviews
Novo Nordisk Interview Questions
4.1
 • 82 Interviews
View all
Merck Business Analyst Salary
based on 11 salaries
₹3.4 L/yr - ₹11.7 L/yr
32% less than the average Business Analyst Salary in India
View more details
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