AmbitionBox
Interview Questions
- Reviews
- Salaries
- Interview Questions
- About Company
- Benefits
- Jobs
- Office Photos
- Community
Add office photos
Filter interviews by
Pharmaace Analytics Interview Questions, Process, and Tips
Top Pharmaace Analytics Interview Questions and Answers
- Q1. what is the role of AHA and how to revive a cardiac arrest ?asked in Analyst interview
- Q2. Cumulative Sum in SQLasked in Senior Consultant interview
- Q3. Background in pharmaasked in Consultant interview
Pharmaace Analytics Interview Experiences
5 interviews found
Rahul Udhwani
(2 Questions)
- Q1. Cumulative Sum in SQL
- Ans.
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;
- Q2. Case When in SQL
Skills evaluated in this interview
Senior Consultant Interview Questions asked at other Companies
Anonymous
(2 Questions)
- Q1. Background in pharma
- Q2. How long in previous company
Interview Preparation Tips
Consultant Interview Questions asked at other Companies
Selected
I applied via Naukri.com and was interviewed in Dec 2022. There were 3 interview rounds.
30 mins basic aptitude questions
(3 Questions)
- Q1. What is the role of AHA and how to revive a cardiac arrest ?
- Q2. How will you analize a large data set using ETL?
- Ans.
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...
- Q3. What is your pofeciancy in Excel
- Ans.
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
Interview Preparation Tips
Analyst Interview Questions asked at other Companies
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.
(1 Question)
- Q1. Asked about hobbies, and guesstimate based on that
(1 Question)
- Q1. Again situation on damage control with clients
(2 Questions)
- Q1. Situation on client interaction
- Q2. Just be honest, stick to your values
Interview Preparation Tips
Consultant Interview Questions asked at other Companies
Pharmaace Analytics interview questions for popular designations
Interview Questionnaire
4 Questions
- Q1. Questions on Excel
- Q2. Questions on analytics, They do check the analytical set of mind along with they check your dedication towards the role or profile.
- Q3. Questions on resume and previous work
- Q4. They do check on your client dealing abilities.
Interview Preparation Tips
Associate Consultant Interview Questions asked at other Companies
Top trending discussions
Interview questions from similar companies
I applied via Naukri.com and was interviewed before Apr 2021. There were 2 interview rounds.
(3 Questions)
- Q1. Spring container and beans
- Q2. Annotations used in Springboot
- Ans.
Annotations are used in Springboot to simplify configuration and reduce boilerplate code.
Annotations are used to define the behavior of Spring components
They can be used to define the scope of a bean, inject dependencies, and handle exceptions
Some commonly used annotations include @Component, @Autowired, and @ExceptionHandler
- Q3. Java 8 New Features and explanation
- Ans.
Java 8 introduced several new features including lambda expressions, streams, and default methods.
Lambda expressions allow for functional programming and simplify code.
Streams provide a way to process collections of data in a functional style.
Default methods allow for adding new methods to interfaces without breaking existing implementations.
Other features include the Optional class, Date and Time API, and Nashorn Java
(1 Question)
- Q1. What is your expected package
Interview Preparation Tips
Skills evaluated in this interview
I applied via Naukri.com and was interviewed before Feb 2021. There were 2 interview rounds.
(1 Question)
- Q1. Questions on Salesforce Basics. One can learn all great features in Salesforce.com but we must know the basic admin functionalities and features in Saleforce.
(1 Question)
- Q1. The questions will be on your career, Resume. They will look for story telling skills, can you be a team player and individual player, etc. Can be technical as well.
Interview Preparation Tips
I applied via Campus Placement and was interviewed before Feb 2021. There were 2 interview rounds.
Focus on industry-specific nuances
Interview Preparation Tips
I applied via Naukri.com and was interviewed in Jun 2019. There were 3 interview rounds.
Interview Questionnaire
2 Questions
- Q1. Configuration Management, data modelling, CI relationships, Problem management process flow, SIAM, integration, cmdb reports, KPIs.
- Q2. General introduction, projects handled in the past,
Interview Preparation Tips
I applied via Naukri.com and was interviewed before May 2021. There were 2 interview rounds.
Coding questions will be given
Interview Preparation Tips
Pharmaace Analytics Interview FAQs
Tell us how to improve this page.
Pharmaace Analytics Interviews By Designations
Interview Questions for Popular Designations
- Executive Interview Questions
- Software Engineer Interview Questions
- Design Engineer Interview Questions
- Intern Interview Questions
- Senior Associate Interview Questions
- Business Analyst Interview Questions
- Sales Executive Interview Questions
- Graduate Engineer Trainee (Get) Interview Questions
- Show more
Pharmaace Analytics Interview Process
based on 3 interviews
Interview experience
Interview Questions from Similar Companies
Pharmaace Analytics Reviews and Ratings
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
- Home >
- Interviews >
- Pharmaace Analytics Interview Questions
