Cipla 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. ICH guidline of pharma
Add your answer
Q2. Self goal with company goal
Ans. 
Aligning personal goals with company goals to drive mutual success
• Setting personal goals that contribute to achieving company objectives

• Regularly reviewing progress towards both personal and company goals

• Seeking opportunities to align individual strengths with organizational needs

• Collaborating with team members to ensure collective efforts support company mission

• Celebrating achievements that benefit both personal growt
Answered by AI
Add your answer
Q3. Industrial visit experience
Ans. 
Visited a manufacturing plant to observe production processes and learn about industry practices.
• Learned about the different stages of production

• Observed how raw materials are transformed into finished products

• Interacted with industry professionals to gain insights into the manufacturing sector
Answered by AI
Add your answer
Q4. Family back ground and native information
Add your answer
Q5. Hobbies and passion
Add your answer

Q1. Questions on Data analysis tools,process, data mining, machine learning.
Add your answer
Q2. Main tool IBM SPSS modular.
Add your answer

Q1. What is mean by chromatography
Ans. 
Chromatography is a technique used to separate and analyze mixtures of chemicals based on their properties.
• Chromatography involves passing a mixture through a stationary phase, which separates the components based on their interactions with the stationary phase and mobile phase.

• Different types of chromatography include gas chromatography, liquid chromatography, and thin-layer chromatography.

• It is widely used in various...read more
Answered by AI
Add your answer
Q2. Ir spectroscopy
Add your answer
Q3. Whatis mean by analysis
Ans. 
Analysis is the process of examining data or information to uncover insights, patterns, and trends.
• Analysis involves breaking down complex information into smaller components for better understanding.

• It helps in making informed decisions based on the findings.

• Examples include financial analysis to assess company performance, data analysis to identify trends in customer behavior, and market analysis to understand indust
Answered by AI
Add your answer
Q4. About phvalues phmeters
Add your answer

Q1. Types of chromatography.?
Ans. 
Chromatography is a technique used to separate and analyze mixtures of chemicals based on their properties.
• Types of chromatography include gas chromatography, liquid chromatography, ion exchange chromatography, and affinity chromatography.

• Gas chromatography separates compounds based on their volatility and interactions with a stationary phase.

• Liquid chromatography separates compounds based on their affinity for the mob...read more
Answered by AI
Add your answer
Q2. Trouble shooting of HPLC and GC.?
Ans. 
Troubleshooting of HPLC and GC involves identifying and resolving issues with the equipment to ensure accurate results.
• Perform regular maintenance checks on the equipment to prevent issues

• Calibrate the instruments regularly to maintain accuracy

• Check for leaks, blockages, or contamination in the system

• Verify the integrity of columns and detectors

• Review method parameters and conditions for any errors or inconsistencies
Answered by AI
Add your answer
Q3. Types Of titration.?
Ans. 
Types of titration include acid-base titration, redox titration, complexometric titration, and precipitation titration.
• Acid-base titration involves the neutralization of an acid with a base or vice versa.

• Redox titration involves a redox reaction between the analyte and titrant.

• Complexometric titration involves the formation of a complex between the analyte and titrant.

• Precipitation titration involves the formation of a
Answered by AI
Add your answer
Q4. Reverse phase and normal phase.?
Add your answer
Q5. Types of HPLC and GC columns
Ans. 
Types of HPLC columns include reverse phase, normal phase, ion exchange, size exclusion, and affinity. Types of GC columns include packed, capillary, and micro-packed columns.
• HPLC columns: reverse phase, normal phase, ion exchange, size exclusion, affinity

• GC columns: packed, capillary, micro-packed
Answered by AI
Add your answer

Q1. How to handle noise in data
Add your answer