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 appeared for an interview in Dec 2016.
Interview Questionnaire
5 Questions
- Q1. Number of 0s in 1 to 1000
- Ans.
The number of 0s in 1 to 1000 is 192.
There are 1000 numbers from 1 to 1000.
Every 10 numbers have one 0 in the units place.
Every 100 numbers have ten 0s in the tens place.
Every 1000 numbers have one hundred 0s in the hundreds place.
Therefore, there are 1 + 10 + 100 + 81 = 192 0s in total.
- Q2. A simple question which can be converted to an easy linear equation. I don't remember the exact question though.
- Q3. How to cut a cake in 8 equal parts
- Ans.
Cut the cake in half, then cut each half in half again. Repeat once more to get 8 equal parts.
Use a long, sharp knife to make clean cuts.
Start by cutting the cake in half vertically.
Then cut each half in half horizontally.
Repeat the process once more to get 8 equal parts.
Use a cake divider or toothpicks to mark where to cut for even slices.
- Q4. HR questions based on resume
- Q5. Why not core?
- Ans.
Core is not the best fit for our current needs and goals.
Our current focus is on expanding our reach to new markets.
Core may not have the necessary features to support our growth plans.
We have evaluated multiple options and found a better fit for our requirements.
Interview Preparation Tips
Experience: Everyone with CGPA > 6.5 were shortlisted.
Round: Test
Experience: Questions were not too difficult. You just need practice to solve them within the time limit.
Tips: Solve level 1 of all the chapters of Arun Sharma's Quantitative Aptitude. Also, take part in the weekly tests organized by pariksha.co .
Duration: 1 hour
Total Questions: 45
Round: HR Interview
Experience: Standard HR questions and resume based questions.
College Name: IIT Kanpur
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
Yash Maheshwari
I applied via Campus Placement and was interviewed in Dec 2016. There were 5 interview rounds.
Interview Questionnaire
3 Questions
- Q1. Why do you want to join EXL?
- Ans.
I want to join EXL because of its reputation for excellence in consulting and its commitment to innovation and growth.
EXL has a strong reputation for excellence in consulting, which aligns with my career goals.
I am impressed by EXL's commitment to innovation and its use of advanced technologies in solving complex business problems.
EXL's focus on growth and expansion presents exciting opportunities for professional deve...
- Q2. Case study - Strategy to sell credit cards to Chennai population
- Ans.
Strategy to sell credit cards to Chennai population
Conduct market research to understand the needs and preferences of the Chennai population
Offer attractive rewards and benefits such as cashback, discounts, and reward points
Partner with local businesses to offer exclusive deals and discounts to credit card holders
Create targeted marketing campaigns in local languages and use social media to reach a wider audience
Provid...
- Q3. Puzzles - Heard on the street level
Interview Preparation Tips
Experience: Prepare from Pariksha.
Tips: Be fast.
Duration: 1 hour
Total Questions: 45
Round: Technical + HR Interview
Experience: They guide you through the process.
Tips: Prepare puzzles from various sources and practice with friends.
Round: HR Interview
Experience: Keep calm and answer with confidence.
Tips: Prepare general guestimate.
College Name: IIT Madras
I appeared for an interview before Jan 2016.
Interview Preparation Tips
Experience: The test was easy.General aptitude test preparation should be sufficient.Prepare via Pariksha and Indiabix websites.Keep the time constraint in mind
Duration: 1 hour
Total Questions: 60
Round: Technical + HR Interview
Experience: The interview was concentrated on case studies and puzzles and general hr questions like Why EXL and Why analytics.EXL do not expect analytics background at all.You just have to do your interviews well.Communicate your ideas in case studies very clearly and precisely.
Tips: Case studies-Basic preparation that students do for consult companies.Follow Caseinterviewcracked book to get the basic flavour and then practice with friends
Puzzles-www.techinterview.com was very helpful followed by heard on the street book
Round: Technical + HR Interview
Experience: Very similar to previous round
College Name: IIT Madras
I appeared for an interview before Dec 2015.
Interview Questionnaire
4 Questions
- Q1. Tell us about yourself/resume
- Ans.
I am a highly motivated and experienced consultant with a strong track record of delivering successful projects.
Over 10 years of experience in consulting for various industries including finance, healthcare, and technology
Expertise in project management, process improvement, and data analysis
Proven ability to lead cross-functional teams and deliver results on time and within budget
Strong communication and interpersonal...
- Q2. Puzzles
- Q3. Case study question
- Q4. Puzzles What do you know about EXL Why consulting
- Ans.
EXL is a global consulting and analytics firm that helps businesses transform and streamline their operations.
EXL provides services in areas such as finance, healthcare, insurance, and more
They use advanced analytics and technology to drive business outcomes
Consulting allows for problem-solving and strategic thinking in a variety of industries
EXL's consulting services help clients improve efficiency, reduce costs, and
Interview Preparation Tips
Duration: 30 minutes
Total Questions: 30
Round: Technical + HR Interview
Experience: The interview started with a 'tell me about your resume' question and the interviewers built it up as a stress interview in the initial 5 min burst. After that, the interviewers opened up and tried to make me comfortable, asking me about my passions and interests. After a 5-7 minute discussion on this, they moved to puzzles. They asked me a mathematical puzzle of magic square and a logical puzzle. Further, they gave me a case to devise a strategy to market a Nokia phone(not a smartphone) in your city, viz and viz the target population, urban rural divide etc.
Tips: Be confident and think out loud while solving your puzzles. Even if you're not able to get to the correct answer, if your thought process is going in the right direction, they will guide you.
Round: Technical + HR Interview
Experience: In this round, the interviewer (a Senior Manager in the firm) wanted to ascertain that I had the requisite skillset in terms of my interaction capabilities to handle the role of a Consultant. He focussed on interacting with me whilst he had given me a puzzles or two, to see how I would deal with interacting with the client while problem solving.
Skills: Conversation Skills, Problem Solving Abilties, Basic Aptitude And Probability
College Name: IIT Kanpur
Pharmaace Analytics Interview FAQs
Tell us how to improve this page.
Pharmaace Analytics Interviews By Designations
Interview Questions for Popular Designations
- Associate Interview Questions
- Senior Executive Interview Questions
- Intern Interview Questions
- Senior Associate Interview Questions
- Sales Executive Interview Questions
- Consultant Interview Questions
- Graduate Engineer Trainee (Get) Interview Questions
- Senior Software Engineer 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 63 reviews
Rating in categories
12-15 Yrs
Not Disclosed
1-8 Yrs
Not Disclosed
3-6 Yrs
Not Disclosed
|
Associate Consultant
91
salaries
|  ₹6.3 L/yr - ₹15 L/yr |
|
Consultant
86
salaries
| ₹7 L/yr - ₹24 L/yr |
|
Analyst
54
salaries
| ₹5 L/yr - ₹10 L/yr |
|
Senior Consultant
26
salaries
| ₹9.8 L/yr - ₹33 L/yr |
|
Project Manager
16
salaries
| ₹14 L/yr - ₹38 L/yr |
EXL Service
Access Healthcare
AGS Health
Straive
- Home >
- Interviews >
- Pharmaace Analytics Interview Questions
