Centrient Pharmaceuticals Data Analyst Interview Questions and Answers

Q1. Do you know adobe analytics
Ans. 
Yes, I am familiar with Adobe Analytics and have experience using it for data analysis.
• I have used Adobe Analytics to track website traffic and user behavior

• I have created custom reports and dashboards using Adobe Analytics

• I am proficient in extracting insights from Adobe Analytics data to drive business decisions
Answered by AI
Add your answer
Q2. Explain example of window function
Add your answer

Q1. Explain example of window function
Add your answer
Q2. A question using aggregate function and case when in sql
Ans. 
Using SQL aggregate functions with CASE WHEN allows for conditional data analysis and summarization.
• Aggregate functions like COUNT, SUM, AVG can be combined with CASE WHEN for conditional calculations.

• Example: SELECT COUNT(CASE WHEN status = 'active' THEN 1 END) AS active_count FROM users;

• This counts only the active users in the users table.

• You can also use it to categorize data, e.g., SELECT AVG(salary) AS avg_salary,...read more
Answered by AI
Add your answer

SWOT ANALYSIS OF A NEW PRODUCT IN THE MARKET

RESEARCH ASSIGNMENT ON THE TB SPACE

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

Q1. How do you manage deadlines in your work?
Ans. 
I prioritize tasks, set clear milestones, and communicate effectively to manage deadlines efficiently.
• Prioritization: I use tools like the Eisenhower Matrix to distinguish between urgent and important tasks.

• Milestones: I break projects into smaller tasks with specific deadlines, ensuring steady progress. For example, in a recent project, I set weekly goals to analyze data subsets.

• Time Management: I allocate specific ti...read more
Answered by AI
Add your answer
Q2. If you have a disagreement with a coworker regarding the correctness of their work, what actions would you take? Would you consider informing your manager?
Ans. 
Addressing disagreements with coworkers requires a collaborative approach, focusing on constructive dialogue and resolution.
• Initiate a private conversation with the coworker to discuss the specific concerns about their work.

• Use data and evidence to support your viewpoint, ensuring the discussion remains objective.

• Listen actively to their perspective to understand their reasoning and approach.

• Seek to find common ground ...read more
Answered by AI
Add your answer

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