AmbitionBox
Interview Questions
- Reviews
- Salaries
- Interview Questions
- About Company
- Benefits
- Jobs
- Office Photos
- Community
Add office photos
Filter interviews by
Pharmaace Analytics Senior Consultant Interview Questions and Answers
Pharmaace Analytics Senior Consultant Interview Experiences
1 interview 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
Top trending discussions
Interview questions from similar companies
Anonymous
I applied via Naukri.com and was interviewed before Dec 2019. There was 1 interview round.
Interview Questionnaire
2 Questions
- Q1. Oracle Apps Technical - PlSQL concepts
- Q2. Basic questions like logic to find even number, swap number ,etc.
Interview Preparation Tips
Interview Questionnaire
1 Question
- Q1. Data transforms, integration, data pages, RAP, Case management
Interview Preparation Tips
I applied via Referral and was interviewed before Mar 2021. There were 4 interview rounds.
Aptitude was quite Simple, They wont ask you difficult category questions.
(1 Question)
- Q1. Technical round was quite interes and long too, I have been in interview room for almost 40+ minutes. They asked me about Java, database, Linux my collage project and some brainstorming questions.
After technical round we have got a subject to write maximum 300 words on it.
here they checked about how we good at grammer and sentence framing.
I cracked this round easily and selected for HR Round
(4 Questions)
- Q1. What are your strengths and weaknesses?
- Q2. Where do you see yourself in 5 years?
- Q3. Tell me about yourself.
- Q4. Why Capgemini? What are your short term goals? What are your long term goals?
Interview Preparation Tips
- Core Java
- ooos
- SQL
- Linux basics
- C
- C++
I must say, go with the capgemini when you feel you got good compensation.
Best of luck for your future…😊
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 LinkedIn and was interviewed before Jul 2021. There were 3 interview rounds.
(1 Question)
- Q1. General questions about previous company and the work I did there and then building on from there?
(1 Question)
- Q1. Details about my experience?
(3 Questions)
- Q1. Total Experience I have overall?
- Q2. Current Salary inclusive of fixed?
- Q3. Salary expectations?
Interview Preparation Tips
I applied via Naukri.com and was interviewed before Oct 2020. There were 4 interview rounds.
Interview Questionnaire
2 Questions
- Q1. Basic knowledge on JavaScript, closure, class, ES6 syntaxes, problem solving
- Q2. Basic knowledge on react, virtual dom, lifecycle hooks, hooks concept, functional and class components, redux
Interview Preparation Tips
There will be 5 rounds:
1. L1 interview by Capgemini
2. L2 interview by Capgemini
3. Client interview
4. Managerial interview
5. HR round, salary negotiation
I applied via Naukri.com and was interviewed before Jul 2021. There were 2 interview rounds.
(1 Question)
- Q1. Basic SQL questions, Basic ASP.NET
AMCAT English assignment test
Interview Preparation Tips
Krishnan G
I applied via Campus Placement
Interview Preparation Tips
Experience: Q1.Tell me about yourself.
Then I was asked about my past internship, PoRs
Then I was asked why I wanted to do a non core internship.
After that, I was asked a puzzle (Similar to a puzzle in the book "Heard on the Street".
Then I was asked a guesstimate question. It was: Estimate the amount of Surf (washing powder) used in India everyday.
It lasted for around half an hour. It was a telephonic round
Tips: Be thorough with your resume. They mainly asked resume based questions in this round.
Regarding puzzles and guesstimates, walk your interviewer through your answer.
General Tips: Be thorough with your resume.
Practice puzzles and guesstimates.
Practice a few cases.
Skills: Presentation Of Facts In Resume, Project And Internship, Guesstimate Skills, Case Solving Ability, Quantitative Aptitude
Duration: 2
College Name: IIT Madras
I applied via Company Website and was interviewed before Jan 2021. There were 4 interview rounds.
Interview Questionnaire
1 Question
- Q1. Questions on COBOL,DB2,JCL,VSAM
Interview Preparation Tips
should point to point.if they ask you to explain then only go ahead.
Pharmaace Analytics Interview FAQs
Tell us how to improve this page.
Pharmaace Analytics Interviews By Designations
Interview Questions for Popular Designations
- Associate Consultant Interview Questions
- Senior Associate Consultant Interview Questions
- Lead Consultant Interview Questions
- Technical Consultant Interview Questions
- Consultant Interview Questions
- Associate Technical Consultant Interview Questions
- Principal Consultant Interview Questions
- Technology Consultant Interview Questions
- Show more
Pharmaace Analytics Senior Consultant Interview Process
based on 1 interview
Interview experience
Senior Consultant Interview Questions from Similar Companies
Pharmaace Analytics Senior Consultant Reviews and Ratings
based on 5 reviews
Rating in categories
|
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 >
- Pharmaace Analytics Senior Consultant Interview Questions
