Merck Group Data Engineer Interview Questions and Answers

Q1. Why do you want to work here,
Add your answer
Q2. They want to know your passion and motivation for the opportunity
Add your answer
Q3. Tell me about you
Add your answer
Q4. What are your expectations
Add your answer
Q5. When are you ready to start
Add your answer

Q1. How to handle noise in data
Add your answer

Q1. Explain example of window function
Ans. 
Window functions are used to perform calculations across a set of table rows related to the current row.
• Window functions are used in SQL to perform calculations within a specific window or subset of rows.

• They allow you to perform aggregate functions like SUM, AVG, COUNT, etc. over a specific range of rows.

• Examples include ROW_NUMBER(), RANK(), DENSE_RANK(), and NTILE().
Answered by AI
Add your answer
Q2. A question using aggregate function and case when in sql
Add your answer

Q1. Fresher or experienced person?
Add your answer
Q2. Why you choose this company
Add your answer

Q1. Excel shortcut keys?
Add your answer
Q2. WHAT IS THE ROLE OF DATA ANALYST?
Ans. 
Data Analysts are responsible for collecting, processing, and analyzing data to help organizations make informed decisions.
• Collecting and organizing data from various sources

• Cleaning and processing data to ensure accuracy and reliability

• Analyzing data to identify trends, patterns, and insights

• Creating visualizations and reports to communicate findings

• Providing recommendations based on data analysis

• Collaborating with st...read more
Answered by AI
Add your answer
Q3. What are the skills need for data analyst?
Ans. 
Skills needed for data analyst include strong analytical skills, proficiency in data analysis tools, programming knowledge, and communication skills.
• Strong analytical skills to interpret complex data sets

• Proficiency in data analysis tools such as Excel, SQL, Python, R, etc.

• Programming knowledge to manipulate and analyze data effectively

• Communication skills to present findings and insights to stakeholders
Answered by AI
Add your answer

Q1. Angular theory questions asked
Add your answer

Aptitude test was quite good if we are good at basics

Group discussion happened to eliminate most of the candidates, just we have to put our point forward boldly, we can succeed

Coding test was but hard, they asked algorithms for searching and sorting techniques with code, OOPs concept was emphasised

Again there was a coding test, this time few coding related questions are given like the hacker rank and hacker earth problems

Q1. This round was with the manager and coding questions were asked in this round. Along with that few riddles were asked related to the logical thinking.
Add your answer

Q1. General HR questions are asked like tell about yourself
Add your answer
Q2. What are your strengths
Add your answer

Complete discuss about college project