Centrient Pharmaceuticals Data Analyst Interview Questions and Answers

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

SWOT ANALYSIS OF A NEW PRODUCT IN THE MARKET

RESEARCH ASSIGNMENT ON THE TB SPACE

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...read more
Answered by AI
Add your answer
Q4. Which one to use when
Add your answer

Mathematics and logical reasoning.

Q1. Why do u want to join roche
Add your answer
Q2. How data science plays vital roles in contemporary world
Ans. 
Data science plays vital roles in contemporary world by enabling businesses to make data-driven decisions, improving healthcare outcomes, enhancing customer experiences, and driving innovation.
• Data science helps businesses make informed decisions by analyzing large datasets to identify trends and patterns.

• In healthcare, data science is used to predict disease outbreaks, personalize treatment plans, and improve patient ...read more
Answered by AI
Add your answer

Q1. Work experience
Add your answer
Q2. Process validation
Add your answer

Q1. Background of the organization
Ans. 
Our organization is a leading retail company specializing in high-quality fashion and accessories.
• Founded in 2005 by a group of fashion enthusiasts

• Over 100 stores nationwide

• Focus on sustainable and ethical sourcing practices

• Collaborations with renowned designers like Stella McCartney

• Strong online presence with e-commerce platform
Answered by AI
Add your answer
Q2. Product knowledge in the mfg site
Add your answer

Q1. Salary requirements
Add your answer
Q2. Time period of joining
Ans. 
I am available to start immediately.
• I can start as soon as possible.

• I am flexible with my start date.

• I am ready to join the team whenever needed.
Answered by AI
Add your answer

Q1. Why are you looking for a change?
Add your answer

2/3 coding questions+technical questions on dbms,os,cn

Q1. Its much about managerial related to project kept in resume and some basic tech questions on skills kept in resume
Add your answer

Q1. Behavioural questions and few questions on project
Add your answer

Q1. It was just regular culture fit questions
Add your answer