Upload Button Icon Add office photos

Merck

Compare button icon Compare button icon Compare

Filter interviews by

Clear (1)

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

I applied via Recruitment Consultant and was interviewed in Feb 2020. There were 4 interview rounds.

Interview Questionnaire 

1 Question

  • Q1. Technical questions regarding Sas and aptitude questions and previous company project details

Interview Preparation Tips

Interview preparation tips for other job seekers - Be confident on projects and technical knowledge in sas
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

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 Resume 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
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

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

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
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
Contribute & help others!
anonymous
You can choose to be anonymous

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.

Recently Viewed

LIST OF COMPANIES

Clariant Chemicals

Overview

SALARIES

Clariant Chemicals

SALARIES

Vinati Organics

COMPANY BENEFITS

Amara Raja Group

No Benefits

SALARIES

Coromandel International

SALARIES

Aarti Industries

REVIEWS

Deccan Fine Chemicals

No Reviews

SALARIES

Gujarat Fluorochemicals

SALARIES

Deccan Fine Chemicals

SALARIES

Deccan Fine Chemicals

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