Filter interviews by
I applied via Campus Placement and was interviewed before Aug 2021. There were 4 interview rounds.
Be assertive. You can speak less, but be confident in your opinion. Try to have a different opinion from the rest of the crowd, this always works and gets you noticed.
Cumulative sum in SQL is a running total of a column's values.
Use the SUM() function with the OVER() clause to calculate the cumulative sum.
The OVER() clause specifies the partitioning and ordering of rows for the calculation.
Example: SELECT column_name, SUM(column_name) OVER (ORDER BY column_name) AS cumulative_sum FROM table_name;
I applied via Naukri.com and was interviewed in Dec 2022. There were 3 interview rounds.
30 mins basic aptitude questions
I will use ETL (Extract, Transform, Load) process to analyze a large data set by extracting data from various sources, transforming it into a usable format, and loading it into a target database.
Extract data from multiple sources such as databases, files, APIs, etc.
Transform the data by cleaning, filtering, aggregating, and structuring it for analysis.
Load the transformed data into a target database for further analysi...
I am highly proficient in Excel, with advanced skills in data analysis, formulas, and pivot tables.
Advanced knowledge of Excel functions and formulas
Experience with creating complex spreadsheets for data analysis
Proficient in using pivot tables for summarizing and analyzing data
Skilled in data visualization using charts and graphs
Familiarity with macros and VBA for automation tasks
Pharmaace Analytics interview questions for popular designations
Top trending discussions
I applied via Naukri.com and was interviewed before Apr 2021. There were 2 interview rounds.
I was interviewed in May 2017.
based on 3 interviews
Interview experience
based on 58 reviews
Rating in categories
12-15 Yrs
Not Disclosed
1-8 Yrs
Not Disclosed
3-6 Yrs
Not Disclosed
Associate Consultant
86
salaries
| ₹0 L/yr - ₹0 L/yr |
Consultant
84
salaries
| ₹0 L/yr - ₹0 L/yr |
Analyst
55
salaries
| ₹0 L/yr - ₹0 L/yr |
Senior Consultant
25
salaries
| ₹0 L/yr - ₹0 L/yr |
Project Manager
15
salaries
| ₹0 L/yr - ₹0 L/yr |
IQVIA
Cognizant
Accenture
TCS