2 Merck Group Data Engineer Interview Questions & Answers | Complete Prep Guide 2025

Merck Group Data Engineer Interview Experiences

1 interview found

Data Engineer Interview Questions & Answers

Anonymous

posted on 26 Aug 2022

I applied via Naukri.com

Round 1 - Technical

(2 Questions)

Q1. Difference between all union all distinct

Ans.

ALL returns all rows, UNION removes duplicates, DISTINCT returns unique rows.

ALL: includes all rows, even duplicates
UNION: combines two result sets and removes duplicates
DISTINCT: returns only unique rows
Example: SELECT name FROM table1 UNION SELECT name FROM table2;
Example: SELECT name FROM table1 UNION ALL SELECT name FROM table2;
Example: SELECT DISTINCT name FROM table1;

Answered by AI

Add your answer

Q2. Convert the given dictionary to list and sort dictionary in ascending order

Ans.

Convert dictionary to list and sort in ascending order

Use the items() method to convert dictionary to list of tuples
Use the sorted() function to sort the list of tuples
Use a lambda function to sort by dictionary values
Convert the sorted list of tuples back to a dictionary using dict() method

Answered by AI

Add your answer

Interview Preparation Tips

Interview preparation tips for other job seekers - Good to join great for freshers good no politics

Skills evaluated in this interview

Top trending discussions

View All

Interview Tips & Stories

1w (edited)

timepasstiwari

A Digital Markter

Got Rejected In an Interview, Just Because I Didn’t Answer a Personal Question

So, I got invited for this interview, and they told me to be there at 9 AM. Of course, I get there early, like 8:30, because I don't want to be late. But then I end up waiting for 1.5 hours... read more

Got a question about Merck Group?

Ask anonymously on communities.

Interview questions from similar companies

Data Engineer Interview Questions & Answers

Bristol-Myers Squibb

Anonymous

posted on 13 Feb 2024

Interview experience

Excellent

Difficulty level

Moderate

Process Duration

Less than 2 weeks

Result

Selected

I applied via LinkedIn and was interviewed in Aug 2023. There was 1 interview round.

Round 1 - Technical

(4 Questions)

Q1. Be prepared with Pyspark and SQL

Add your answer

Q2. How to rename a column in pyspark

Ans.

To rename a column in PySpark, use the 'withColumnRenamed' method.

Use the 'withColumnRenamed' method on the DataFrame
Specify the current column name and the new column name as arguments
Assign the result to a new DataFrame to store the renamed column

Answered by AI

Add your answer

Q3. Difference between multiprocessing and multithreading

Ans.

Multiprocessing involves executing multiple processes simultaneously, while multithreading involves executing multiple threads within a single process.

Multiprocessing utilizes multiple CPUs or cores to execute multiple processes concurrently.
Multithreading involves creating multiple threads within a single process to execute tasks concurrently.
Processes in multiprocessing have separate memory spaces, while threads in m...

Answered by AI

Add your answer

Q4. Which one to use when

Add your answer

Skills evaluated in this interview

Data Analyst Interview Questions & Answers

Eli Lilly and Company

Anonymous

posted on 27 Dec 2024

Interview experience

Excellent

Difficulty level

Easy

Process Duration

Less than 2 weeks

Result

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

Add your answer

Round 2 - Technical

(1 Question)

Q1. Technical questions with respect to SQL and SAS, complexity was easy to medium.

Add your answer

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.

Add your answer

Interview Preparation Tips

Topics to prepare for Eli Lilly and Company Data Analyst interview:

Senior Engineer Interview Questions & Answers

Pfizer

posted on 17 Apr 2021

Interview Questionnaire

1 Question

Q1. Have you experienced failure

Add your answer

Interview Preparation Tips

Interview preparation tips for other job seekers - Go with preparation

Data Analyst Interview Questions & Answers

Eli Lilly and Company

Anonymous

posted on 2 Aug 2024

Interview experience

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

Add your answer

Q2. What is the one thing that eli lilly has as a pharmaceutical brand

Add your answer

Software Engineer Interview Questions & Answers

Eli Lilly and Company

Anonymous

posted on 28 Nov 2024

Interview experience

Average

Difficulty level

Moderate

Process Duration

2-4 weeks

Result

I applied via Campus Placement and was interviewed in Oct 2024. There was 1 interview round.

Round 1 - One-on-one

(2 Questions)

Q1. Why do you want to work for eli lilly

Add your answer

Q2. Tell me about a time you perserved

Add your answer

Software Engineer Interview Questions & Answers

Eli Lilly and Company

Anonymous

posted on 12 Jan 2025

Interview experience

Good

Difficulty level

Moderate

Process Duration

Less than 2 weeks

Result

Selected

I applied via Recruitment Consulltant and was interviewed before Jan 2024. There was 1 interview round.

Round 1 - Aptitude Test

The assessment consists of basic aptitude, quantitative reasoning, and three coding questions.

Data Analyst Interview Questions & Answers

Johnson & Johnson

Anonymous

posted on 31 Jul 2024

Interview experience

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

Add your answer

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

Add your answer

Skills evaluated in this interview

Data Analyst Interview Questions & Answers

Sanofi

Anonymous

posted on 28 May 2022

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.

Add your answer

Q2. Previous projects and their solutions.

Add your answer

Q3. Tool used in previous company. (SharePoint, Power BI, Nintex, InfoPath, Power Apps, Workflows)

Add your answer

Round 3 - Interview

(1 Question)

Q1. Related to professional life and assurance to work.

Add your answer

Round 4 - HR

(1 Question)

Q1. Salary details and candidature check.

Add your answer

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).

Software Engineer Interview Questions & Answers

Bayer

Anonymous

posted on 3 Sep 2021

I applied via Recruitment Consultant and was interviewed in Aug 2021. There were 4 interview rounds.

Interview Questionnaire

1 Question

Q1. Create stack data structure with push pop and getmin

Ans.

Implement a stack with push, pop, and getmin operations.

Use an array to store the stack elements.
Keep track of the minimum element using another stack.
Push operation: add element to the top of the stack and update the minimum stack.
Pop operation: remove the top element from the stack and update the minimum stack.
Getmin operation: return the top element of the minimum stack.

Answered by AI

Add your answer

Interview Preparation Tips

Interview preparation tips for other job seekers - Very interview experience. They interviewed I cleared all rounds and offer was issued. Then they put my offer on hold saying opening has closed. Do not waste your time interviewing for bayer

Skills evaluated in this interview

Merck Group Interview FAQs

How many rounds are there in Merck Group Data Engineer interview?

Merck Group interview process usually has 1 rounds. The most common rounds in the Merck Group interview process are Technical.

How to prepare for Merck Group Data Engineer 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 Group. The most common topics and skills that interviewers at Merck Group expect are Python, Data Analytics, Data Engineering, Data Management and Hadoop.

What are the top questions asked in Merck Group Data Engineer interview?

Some of the top questions asked at the Merck Group Data Engineer interview -

Convert the given dictionary to list and sort dictionary in ascending or...read more
Difference between all union all disti...read more

Senior Analyst 79 salaries	₹5 L/yr - ₹18.7 L/yr
Analyst 58 salaries	₹3.6 L/yr - ₹10 L/yr
Associate Analyst 30 salaries	₹4 L/yr - ₹7 L/yr
Senior Specialist 29 salaries	₹11 L/yr - ₹28.5 L/yr
System Engineer 18 salaries	₹5 L/yr - ₹8.8 L/yr

Merck Group Data Engineer Interview Questions and Answers

Merck Group Data Engineer Interview Experiences

1 interview found

(2 Questions)

Interview Preparation Tips

Skills evaluated in this interview

Interview questions from similar companies

(4 Questions)

Skills evaluated in this interview

(1 Question)

(1 Question)

(1 Question)

Interview Preparation Tips

Interview Questionnaire

1 Question

Interview Preparation Tips

(2 Questions)

(2 Questions)

(2 Questions)

Skills evaluated in this interview

(3 Questions)

(1 Question)

(1 Question)

Interview Preparation Tips

Interview Questionnaire

1 Question

Interview Preparation Tips

Skills evaluated in this interview

Merck Group Interview FAQs

Recently Viewed

Paltech

Gramophone

Vnr Seeds

Gramophone

Gramophone

10405090xyzabc

Vnr Seeds

10405090xyzabc

10405090xyzabc

Tell us how to improve this page.

Merck Group Interviews By Designations

Interview Questions for Popular Designations

Interview Questions from Similar Companies

Fast track your campus placements