Add office photos
i
Centrient Pharmaceuticals
Compare
Filter interviews by
Centrient Pharmaceuticals Data Analyst Interview Questions and Answers
Centrient Pharmaceuticals Data Analyst Interview Experiences
1 interview found
Ashutosh Gupta
(1 Question)
- Q1. Tell me about yourself
Top trending discussions
Interview questions from similar companies
Anonymous
(2 Questions)
- 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().
- Q2. A question using aggregate function and case when in sql
Interview Preparation Tips
(2 Questions)
- 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
- Q2. 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 applied to a set of rows related to the current row in a query result.
They can be used to calculate running totals, averages, ranks, and more.
Examples include ROW_NUMBER(), RANK(), DENSE_RANK(), and NTILE().
Interview Preparation Tips
(2 Questions)
- 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().
- Q2. A question using aggregate function and case when in sql
Interview Preparation Tips
(2 Questions)
- 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
- Q2. 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 applied to a set of rows related to the current row in a query result.
They can be used to calculate running totals, averages, ranks, and more.
Examples include ROW_NUMBER(), RANK(), DENSE_RANK(), and NTILE().
Interview Preparation Tips
Selected
I applied via campus placement at Vellore Institute of Technology (VIT) and was interviewed before Dec 2023. There were 2 interview rounds.
Mathematics and logical reasoning.
(2 Questions)
- Q1. Why do u want to join roche
- 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 ...
Selected
I applied via LinkedIn and was interviewed in Aug 2023. There was 1 interview round.
(4 Questions)
- Q1. Be prepared with Pyspark and SQL
- 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
- 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...
- Q4. Which one to use when
Skills evaluated in this interview
Data Entry Operator Interview Questions & Answers
Apotex Research
Vaishnavi Kanal
posted on 16 Dec 2022
I applied via Recruitment Consulltant and was interviewed in Jun 2022. There were 4 interview rounds.
Good and not that much difficult
(1 Question)
- Q1. Good, interview was gone very smooth and you should know about what you mentioned in resume
(1 Question)
- Q1. They will ask about personal information and inform you about your role
Interview Preparation Tips
Centrient Pharmaceuticals Interview FAQs
Tell us how to improve this page.
Centrient Pharmaceuticals Interviews By Designations
- Centrient Pharmaceuticals Assistant Manager - Administration Interview Questions
- Centrient Pharmaceuticals Data Analyst Interview Questions
- Centrient Pharmaceuticals Deputy Manager Interview Questions
- Centrient Pharmaceuticals Deputy Manager Engineering Interview Questions
- Centrient Pharmaceuticals Maintenance Engineer Interview Questions
- Centrient Pharmaceuticals Quality Controller Interview Questions
- Centrient Pharmaceuticals Senior Executive Interview Questions
- Centrient Pharmaceuticals Senior Technician Interview Questions
- Show more
Interview Questions for Popular Designations
- Senior Data Analyst Interview Questions
- Junior Data Analyst Interview Questions
- Data Analyst Intern Interview Questions
- Data Engineer Interview Questions
- Data Research Analyst Interview Questions
- Data Scientist Interview Questions
- Data Entry Operator Interview Questions
- Associate Data Analyst Interview Questions
- Show more
Interview Questions from Similar Companies
|
Senior Executive
35
salaries
|  ₹5.4 L/yr - ₹12.5 L/yr |
|
Officer
32
salaries
| ₹3.5 L/yr - ₹5.8 L/yr |
|
Executive
28
salaries
| ₹4.3 L/yr - ₹9.6 L/yr |
|
Assistant Manager
25
salaries
| ₹9 L/yr - ₹19 L/yr |
|
Supervisor
22
salaries
| ₹2.7 L/yr - ₹4 L/yr |
Sun Pharmaceutical Industries
Cipla
DRJ & CO
Biocon Limited
Calculate your in-hand salary
- Home >
- Interviews >
- Centrient Pharmaceuticals Interview Questions >
- Centrient Pharmaceuticals Data Analyst Interview Questions
