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
Anonymous
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
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
(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
Pharmaace Analytics interview questions for popular designations
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
Top trending discussions
Interview questions from similar companies
I applied via Naukri.com and was interviewed in Aug 2020. There were 3 interview rounds.
Interview Questionnaire
3 Questions
- Q1. Tell me about your self.
- Q2. Find percentage of a number (I did not remember the exact number)
- Ans.
To find the percentage of a number, multiply the number by the percentage and divide by 100.
To find 25% of 80, multiply 80 by 25 and divide by 100: (80 x 25) / 100 = 20
To find 75% of 120, multiply 120 by 75 and divide by 100: (120 x 75) / 100 = 90
- Q3. Situational base questions
Interview Preparation Tips
Akshay Jha
Interview Questionnaire
7 Questions
- Q1. 2-3 Questions on my CV, my goals in life
- Q2. List all the relevant things if you were to float a tender for ordering tube lights if hypothetically you were the head of the engineering cell of your college ?
- Ans.
Relevant things to consider when floating a tender for ordering tube lights for the engineering cell of a college.
Quantity of tube lights required
Specifications of the tube lights (wattage, color temperature, length, etc.)
Budget allocated for the tender
Delivery timeline
Quality standards and certifications required
Supplier evaluation criteria
Payment terms and conditions
Warranty and after-sales support
Technical support a...
- Q3. You have 3 slices of bread, and a toaster. You can put in 2 slices of bread at a time. Each time, only one side of the bread gets cooked. How much minimum time is needed for cooking 3 slices on both sides ...
- Ans.
Minimum time needed to cook 3 slices of bread on both sides using a toaster with 2 slice capacity at a time.
Cook 2 slices on one side for the first round
Cook the third slice on one side for the second round
Cook the first 2 slices on the other side for the third round
Cook the third slice on the other side for the fourth round
Total minimum time needed is 4 rounds or 2 minutes
- Q4. You have 20 red balls, 14 blue balls. You draw out balls, 2 at a time. If they are of same color, add a blue ball the pile. If the are of different colors, add a red ball to the pile. (i) will the color of...
- Q5. From a deck of cards, you pick out one card at a time, 3 times, with replacement. What's the probability of getting a sequence, where a sequence is defined as consecutive integers drawn in any order ?
- Ans.
Probability of getting a sequence of consecutive integers from a deck of cards drawn 3 times with replacement.
There are 4 possible sequences: 2-3-4, 3-4-5, 4-5-6, 5-6-7
The probability of drawing any one of these sequences is 1/52 * 1/52 * 1/52 = 1/140608
The probability of drawing any sequence (in any order) is 4/140608 = 1/35152
- Q6. Same questions, without replacement
- Q7. I consider a domestic airliner, pull out all the seats, and fill it up with tennis balls. How many can I fit inside ?
Interview Preparation Tips
Experience: A basic aptitude test, with Quant, Verbal and LR
Tips: Cover the easiest questions first, from all the sections
Duration: 60 minutes
Total Questions: 60
Round: Technical Interview
Experience: It was a mix of HR+ Puzzles + Guesstimates based interview.
Goals in life:
Why EXL ?
Why not MBA?
How do you think you fit in here given your past internships ?
Tips: Know your CV inside out
LISTEN to the questions carefully, request you for a reiteration/reaffirm if need be.
I was sent to round 2 because of a slight lapse in listening.
Introspect, search deep inside for qualities which you think make you a fit for EXL
Round: Technical Interview
Tips: They test effective communication, structuring skills.
Keep it interactive, keep talking, elaborating in points to structure well!
General Tips: Confidence and attitude are the best things you can carry with you in an interview!
Obviously you should read up on the business they do before the interview
Its a hierarchical company with strict rules about phones, i cards etc
Skills: Presence Of Mind, Common Sense, Structuring your thoughts , Clear communication
College Name: IIT Guwahati
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
I appeared for an interview before May 2016.
Interview Questionnaire
1 Question
- Q1. Round 1: Both technical and HR questions. They were based on R, normal coding questions based on time series, binary search. Round 2: Purely technical questions. He was asked to explain the chemical engine...
Interview Preparation Tips
Experience: There were mainly quant,verbal,aptitude and logic questions. It was held on CoCubes
Duration: 45 minutes
Round: Resume Shortlist
Experience: CGPA plus Resume
Round: HR Interview
Experience: Same as above
Tips: Placement Prep was enough.
College Name: IIT Madras
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
