Merck KGaA Senior Analyst Interview Questions and Answers

Piraamal finance jnlnm knkn

Q1. What is sql? and where to use
Ans. 
SQL is a programming language used for managing and manipulating relational databases.
• SQL stands for Structured Query Language

• Used to retrieve, update, and manage data in relational databases

• Commonly used in data analysis, data manipulation, and data reporting

• Examples: SELECT * FROM table_name, INSERT INTO table_name VALUES (value1, value2)
Answered by AI
Add your answer
Q2. Power bi description and its imp
Ans. 
Power BI is a business analytics tool by Microsoft that provides interactive visualizations and business intelligence capabilities.
• Power BI allows users to connect to a wide variety of data sources and create interactive reports and dashboards.

• Users can easily share their insights with others and collaborate in real-time.

• It offers features like data modeling, data preparation, and data visualization to help organizatio...read more
Answered by AI
Add your answer

Q1. Excel Test before the interview - Pretty basic stuff. Few analysis questions regarding it in the interview.
Add your answer

Q1. Regarding you experiences, background, day to day work etc.
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. About stability studies
Add your answer
Q2. Signification of stability studies
Ans. 
Stability studies are conducted to evaluate the stability of a product over time under various conditions.
• Stability studies help determine the shelf life of a product.

• They assess how the quality of a product changes over time.

• Factors such as temperature, humidity, light exposure, and packaging are considered in stability studies.

• Results of stability studies are used to establish storage conditions and expiration dates ...read more
Answered by AI
Add your answer

Q1. What ever I was mentioning in my resume from toward the questions
Add your answer
Q2. Explain about UV, IR, KF, polarimeter with principle and functions
Ans. 
UV, IR, KF, and polarimeter are analytical instruments used for different types of analysis based on principles of light absorption, emission, and rotation.
• UV (Ultraviolet) spectrophotometer measures the absorption of ultraviolet light by a sample to determine its concentration or purity.

• IR (Infrared) spectrophotometer measures the absorption of infrared light by a sample to identify functional groups in organic compou...read more
Answered by AI
Add your answer
Q3. Calibration of analytical balance
Ans. 
Calibration of analytical balance is essential for accurate measurements in analytical chemistry.
• Calibration involves comparing the readings of the balance to known weights.

• Regular calibration ensures accuracy and reliability of measurements.

• Adjustments may be needed if the balance readings deviate from the known weights.

• Calibration should be done using a proper calibration weight and following manufacturer's instructi...read more
Answered by AI
Add your answer
Q4. What is the range of PH and explain about calibration
Ans. 
PH range is 0-14. Calibration ensures accuracy by adjusting the PH meter to known standards.
• PH range is from 0 to 14, with 7 being neutral

• Acidic solutions have a PH below 7, while alkaline solutions have a PH above 7

• Calibration involves adjusting the PH meter using buffer solutions of known PH values

• Regular calibration ensures accurate PH measurements
Answered by AI
Add your answer

Q1. Waiting for HR round
Add your answer

Q1. There are so many questions like what about you know apqr bpr validation activity document activity like all.
Add your answer
Q2. Than hr interview round family details why you join the intas and all.
Add your answer

Q1. Tell me about yourself and why you’re interested in this role?
Add your answer