AmbitionBox
Search
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
Updated
26 Dec 2024
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
Popular Designations
5 interviews found
Anonymous
Interview experience
Good
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Selected
I applied via Naukri.com and was interviewed in Dec 2022. There were 3 interview rounds.
Round 1 - Resume Shortlist
Pro Tip by AmbitionBox:
Keep your resume crisp and to the point. A recruiter looks at your resume for an average of 6 seconds, make sure to leave the best impression.
View all tips
Round 2 - Aptitude Test
30 mins basic aptitude questions
Round 3 - One-on-one
(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
Add your answer
Answered by
AI
Add your answer
Answered by
AI
Add your answer
Interview Preparation Tips
Interview preparation tips for other job seekers - Do not join the company; the salary is low, and the work-life balance is poor.
Analyst Interview Questions asked at other Companies
Q1. N-th Fibonacci Number Problem Statement Given an integer ‘N’, your task is to find and return the N’th Fibonacci number using matrix exponentiation. Since the answer can be very large, return the answer modulo 10^9 + 7. Formula: F(n) = F(n-...
read more
View answer
(1)
Rahul Udhwani
Interview experience
Good
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Technical
(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
Answered by
AI
Add your answer
Add your answer
Skills evaluated in this interview
Senior Consultant Interview Questions asked at other Companies
Q1. 1. What's the use of update sets and how do you move update set from one instance to another? Once you imported the update set, what will you do? To check the customisations, You need to do open the update set and do something. What is that...
read more
View answer
(3)
Interview experience
Poor
Difficulty level
-
Process Duration
-
Result
-
Round 1 - HR
(2 Questions)
- Q1. Background in pharma
- Q2. How long in previous company
Add your answer
Add your answer
Interview Preparation Tips
Interview preparation tips for other job seekers - Do not apply for this company
Consultant Interview Questions asked at other Companies
Q1. How would you pass an entry for travel expenses incurred and paid by employee and was reimbursed? How would the end to end flow happens
View answer
(8)
I applied via Campus Placement and was interviewed before Aug 2021. There were 4 interview rounds.
Round 1 - Group Discussion
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.
Round 2 - One-on-one
(1 Question)
- Q1. Asked about hobbies, and guesstimate based on that
Add your answer
Round 3 - HR
(1 Question)
- Q1. Again situation on damage control with clients
Add your answer
Round 4 - One-on-one
(2 Questions)
- Q1. Situation on client interaction
- Q2. Just be honest, stick to your values
Add your answer
Add your answer
Interview Preparation Tips
Interview preparation tips for other job seekers - Be honest, stick to your values, try to show yourself as willing to learn.
Consultant Interview Questions asked at other Companies
Q1. How would you pass an entry for travel expenses incurred and paid by employee and was reimbursed? How would the end to end flow happens
View answer
(8)
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.
Add your answer
Add your answer
Add your answer
Add your answer
Interview Preparation Tips
Interview preparation tips for other job seekers - Just be confident and say what comes in your mind
Associate Consultant Interview Questions asked at other Companies
Q1. There are 2 cricket teams, A and B, with 11 players each. If every player of team A shakes hands with every player of team B(once), what will be the total number of handshakes?
View answer
(15)
Interview questions from similar companies
Interview Questionnaire
2 Questions
- Q1. Tell me about yourself?
- Q2. Why did you apply for this company?
Add your answer
Add your answer
Interview Preparation Tips
Round: Test
Experience: Questions were similar to that in CAT. Question based on logic, reasoning and English were asked with every section having 20 questions. Shortlisted students were selected for interviews.
Duration: 60 minutes
Round: HR Interview
Experience: A case was given which had to be analysed and I was to suggest different solutions and justify them.
Round: HR Interview
Experience: Consisted of HR questions and guess estimate questions.Also a few analytics question were asked.
Skill Tips: My projects related to analytics,basic knowledge on engineering, spontaneity was tested. The PDF's uploaded by the BC,solving puzzles from the Internet helped.Also I talked to my seniors which gave me a good idea as to what to expect of the interview. Basic preparation on all the core courses. Reading from the materials provided by the BC. Reading TIME material,brushing up on coding concepts (from NPTEL lectures), learning R(analytics software) from coursera helped.
Skills: Analytics
College Name: IIT MADRAS
Experience: Questions were similar to that in CAT. Question based on logic, reasoning and English were asked with every section having 20 questions. Shortlisted students were selected for interviews.
Duration: 60 minutes
Round: HR Interview
Experience: A case was given which had to be analysed and I was to suggest different solutions and justify them.
Round: HR Interview
Experience: Consisted of HR questions and guess estimate questions.Also a few analytics question were asked.
Skill Tips: My projects related to analytics,basic knowledge on engineering, spontaneity was tested. The PDF's uploaded by the BC,solving puzzles from the Internet helped.Also I talked to my seniors which gave me a good idea as to what to expect of the interview. Basic preparation on all the core courses. Reading from the materials provided by the BC. Reading TIME material,brushing up on coding concepts (from NPTEL lectures), learning R(analytics software) from coursera helped.
Skills: Analytics
College Name: IIT MADRAS
Interview Preparation Tips
General Tips: Do’s :
• PREPARE FOR APTITUDE TESTS. Many of us believe that our profile will lead us getting
shortlisted on resume basis. That may be true, but I have not seen a process as random as
placements. It might happen that you are getting closely rejected in 3-4 firms for which you have
prepared. In such a case, having a good aptitude will give you more no. of shortlists, which will give
you a psychological security to fall back. APTITUDE PREPARATION IS BORING, so you may start it
and then leave it. Don’t do it. It is the only thing that is going to be with you in case something
unexpected happens.
• Be prepared for random and unexpected events like unexpected shortlisting results, irregularities in interview procedures etc.
• Prepare in a group, and help each other. The entire placement preparation phase is very taxing,
and support from people around you helps.
Dont’s :
• Don’t leave things for the end.
• Don’t underestimate yourself. Don’t overestimate yourself too.
• Don’t have pre-conceived notions about anything: no. of people a company is going to hire, who is
better than you, who is worse than you etc. Let the company decide what they want.
Final Tips :
• Prioritize the sectors and analyse your chances.
• Don’t keep too high or too low expectations from yourself.
• PREPARE APTITUDE. If you don’t get placed in big firms, aptitude is your only fall back.
• Be prepared for unexpected outcomes.
• Trust yourself for what you know, because there are a lot of things and you cant know everything.
The interview is driven by what you write on your resume. Know what you write.
• In all preparation aspects, one never gets a feeling of satisfaction. Due to paucity of time and so
much pressure around, we are unable to do things as per our expectations. So don’t worry too
much. Give ample time to things, but don’t overdo them.
• Go to the interview empty-headed. Thinking too much about things makes you feel nervous. An empty mind works most efficiently.
College Name: IIT Kanpur
• PREPARE FOR APTITUDE TESTS. Many of us believe that our profile will lead us getting
shortlisted on resume basis. That may be true, but I have not seen a process as random as
placements. It might happen that you are getting closely rejected in 3-4 firms for which you have
prepared. In such a case, having a good aptitude will give you more no. of shortlists, which will give
you a psychological security to fall back. APTITUDE PREPARATION IS BORING, so you may start it
and then leave it. Don’t do it. It is the only thing that is going to be with you in case something
unexpected happens.
• Be prepared for random and unexpected events like unexpected shortlisting results, irregularities in interview procedures etc.
• Prepare in a group, and help each other. The entire placement preparation phase is very taxing,
and support from people around you helps.
Dont’s :
• Don’t leave things for the end.
• Don’t underestimate yourself. Don’t overestimate yourself too.
• Don’t have pre-conceived notions about anything: no. of people a company is going to hire, who is
better than you, who is worse than you etc. Let the company decide what they want.
Final Tips :
• Prioritize the sectors and analyse your chances.
• Don’t keep too high or too low expectations from yourself.
• PREPARE APTITUDE. If you don’t get placed in big firms, aptitude is your only fall back.
• Be prepared for unexpected outcomes.
• Trust yourself for what you know, because there are a lot of things and you cant know everything.
The interview is driven by what you write on your resume. Know what you write.
• In all preparation aspects, one never gets a feeling of satisfaction. Due to paucity of time and so
much pressure around, we are unable to do things as per our expectations. So don’t worry too
much. Give ample time to things, but don’t overdo them.
• Go to the interview empty-headed. Thinking too much about things makes you feel nervous. An empty mind works most efficiently.
College Name: IIT Kanpur
Interview Preparation Tips
Round: Test
Experience: It was held couple of days before their interview process. Test consisted of Quant, Logical reasoning and Verbal Ability, similar to CAT pattern but was comparatively easy. They shortlisted approximately 80 students for interview process.
Round: Other Interview
Experience: It was a mix of mostly HR + few probability questions. It was a 40min interview. It was a good interview as I was able to answer all his question and could easily solve the probability questions.
Round: Technical Interview
Experience: It was all technical wherein the interviewer asked me 4-5 puzzles and some probability questions. I was able to answer most of the puzzles correctly but got stuck in one of the probability questions.
Round: HR Interview
Experience: Final HR round. Here the interviewer was continuously grilling me by stating that my profile is not coherent with their job description. I maintained my composure and was able to handle the situation with ease.
General Tips: Do’s :
Apart from all preparation :
• Take proper sleep whenever given a chance to. Do not skip meals.
• Prepare about the company in advance, last minute preparation might lead to a panic situation. Ask your friends (not sitting in placements) to help you prepare.
• Take someone to the interviews. He/She will manage your interviews accordingly. It’s also a motivating factor.
• Always carry a smile when going to an interview. You should not appear stressed.
Don’ts :
• Don’t try to delay things. Prepare a timeline for preparation. Don’t accumulate things post end sem, because you will have to appear for a lot of tests after that. Hence you get limited time for preparation.
• Don’t be in a false assumption that if you possess a strong profile (PORs, Extra currics etc.) you will make it through the interviews. It can only help you fetch an interview. You have to work hard to clear that interview.
College Name: IIT Kanpur
Experience: It was held couple of days before their interview process. Test consisted of Quant, Logical reasoning and Verbal Ability, similar to CAT pattern but was comparatively easy. They shortlisted approximately 80 students for interview process.
Round: Other Interview
Experience: It was a mix of mostly HR + few probability questions. It was a 40min interview. It was a good interview as I was able to answer all his question and could easily solve the probability questions.
Round: Technical Interview
Experience: It was all technical wherein the interviewer asked me 4-5 puzzles and some probability questions. I was able to answer most of the puzzles correctly but got stuck in one of the probability questions.
Round: HR Interview
Experience: Final HR round. Here the interviewer was continuously grilling me by stating that my profile is not coherent with their job description. I maintained my composure and was able to handle the situation with ease.
General Tips: Do’s :
Apart from all preparation :
• Take proper sleep whenever given a chance to. Do not skip meals.
• Prepare about the company in advance, last minute preparation might lead to a panic situation. Ask your friends (not sitting in placements) to help you prepare.
• Take someone to the interviews. He/She will manage your interviews accordingly. It’s also a motivating factor.
• Always carry a smile when going to an interview. You should not appear stressed.
Don’ts :
• Don’t try to delay things. Prepare a timeline for preparation. Don’t accumulate things post end sem, because you will have to appear for a lot of tests after that. Hence you get limited time for preparation.
• Don’t be in a false assumption that if you possess a strong profile (PORs, Extra currics etc.) you will make it through the interviews. It can only help you fetch an interview. You have to work hard to clear that interview.
College Name: IIT Kanpur
Interview Preparation Tips
Round: stress interview
Experience: During EXL, the first interview was a totally stressful one. The interviewer was interrupting me all the time and countering me when I was answering him. Then he gave me a puzzle, which seemed fairly easy to me. But as I started on the puzzle, he started asking me about my hobbies to interrupt me again. I patiently answered the question and then solved the puzzle. He gave me 2 more puzzles, which again I was able to solve. Then, he asked me to give an approach for a guess estimate, which I was able to do easily. My preparation on Cases, Puzzles and Guesstimates was fairly low as compared to others. But I was able to solve them because I was very relaxed in the interview.
Tips: Keeping calm is imperative.
Round: HR interview
Experience: The second round was a complete HR interview. All the questions were either from my resume or about my interest in EXL. Once, he was through with them, he asked me a puzzle which I’d never heard before. But I was able to solve it with a small hint from the interviewer.
Tips: It is important to think loud and let the interviewer know what is going through your mind.
General Tips: Do’s –
Manage Time well, try to attend all classes so that you don’t have to study too much before the exams (or simply choose such courses).
Try to keep your personal database of which companies you’ve applied for, which day are they coming and what your status of preparation for them is etc.
If you have more than 1 interview in a slot, try to take a friend along with you who can attend your calls when you’re in an interview. Even if you have 1 interview, still I’d recommend taking a friend along with you. Talking with a friend always eases pressure.
Stay Relaxed. You might have to wait for 2-3 hours for your interview slot.
Don'ts-
Don’t waste time in the semester. Prepare.
Don’t get nervous in the interview. You might not be able to solve a puzzle or a case if you are nervous. Try to be as normal as you can be.
Don’t rely heavily on one company. A company might reject you on the basis of a small mistake. Prepare for more than one.
College Name: IIT Kanpur
Experience: During EXL, the first interview was a totally stressful one. The interviewer was interrupting me all the time and countering me when I was answering him. Then he gave me a puzzle, which seemed fairly easy to me. But as I started on the puzzle, he started asking me about my hobbies to interrupt me again. I patiently answered the question and then solved the puzzle. He gave me 2 more puzzles, which again I was able to solve. Then, he asked me to give an approach for a guess estimate, which I was able to do easily. My preparation on Cases, Puzzles and Guesstimates was fairly low as compared to others. But I was able to solve them because I was very relaxed in the interview.
Tips: Keeping calm is imperative.
Round: HR interview
Experience: The second round was a complete HR interview. All the questions were either from my resume or about my interest in EXL. Once, he was through with them, he asked me a puzzle which I’d never heard before. But I was able to solve it with a small hint from the interviewer.
Tips: It is important to think loud and let the interviewer know what is going through your mind.
General Tips: Do’s –
Manage Time well, try to attend all classes so that you don’t have to study too much before the exams (or simply choose such courses).
Try to keep your personal database of which companies you’ve applied for, which day are they coming and what your status of preparation for them is etc.
If you have more than 1 interview in a slot, try to take a friend along with you who can attend your calls when you’re in an interview. Even if you have 1 interview, still I’d recommend taking a friend along with you. Talking with a friend always eases pressure.
Stay Relaxed. You might have to wait for 2-3 hours for your interview slot.
Don'ts-
Don’t waste time in the semester. Prepare.
Don’t get nervous in the interview. You might not be able to solve a puzzle or a case if you are nervous. Try to be as normal as you can be.
Don’t rely heavily on one company. A company might reject you on the basis of a small mistake. Prepare for more than one.
College Name: IIT Kanpur
Interview Preparation Tips
Round: Test
Duration: 45 minutes minutes
Total Questions: 40
Round: guesstimate interview
Experience: As I belong to the Civil Engineering background, I was initially asked to justify how I am suited for analytics. I had an intern on marketing so he asked few simple questions on that. After that he gave me guesstimate. As I was solving the guesstimate, the interviewer was constantly questioning my approach and asking me to specify the source of every data (for eg. Population of India 1.2 bn, Source: Census report 2%) and he also kept questioning my approach and made me do the same guesstimate by three approach. After that he asked few puzzles which were simple and I was able to solve them.
Round: hr interview
Experience: Initially some HR questions and some simple probability questions. This was a very friendly and easy interview.
Round: hr interview
Experience: It was with the partner and it was a short interview (10 mins) and was entirely HR and he also asked few questions on my resume. It was more of a normal chit chat that an interview. I was given the offer.
General Tips: Do’s :
1. Practice in groups (aptitude, cases, guesstimates).
2. For HR preparation, if you are not sure about your communication skills it is good to practice aloud in your room or record while rehearsing.
3. Be energetic in the interview, try to drive the interview on your own.
Don’ts :
1. Take HR for granted if you have good soft skills.
2. For cases its better to practice mock rather than just reading through the case books.
College Name: IIT Kanpur
Duration: 45 minutes minutes
Total Questions: 40
Round: guesstimate interview
Experience: As I belong to the Civil Engineering background, I was initially asked to justify how I am suited for analytics. I had an intern on marketing so he asked few simple questions on that. After that he gave me guesstimate. As I was solving the guesstimate, the interviewer was constantly questioning my approach and asking me to specify the source of every data (for eg. Population of India 1.2 bn, Source: Census report 2%) and he also kept questioning my approach and made me do the same guesstimate by three approach. After that he asked few puzzles which were simple and I was able to solve them.
Round: hr interview
Experience: Initially some HR questions and some simple probability questions. This was a very friendly and easy interview.
Round: hr interview
Experience: It was with the partner and it was a short interview (10 mins) and was entirely HR and he also asked few questions on my resume. It was more of a normal chit chat that an interview. I was given the offer.
General Tips: Do’s :
1. Practice in groups (aptitude, cases, guesstimates).
2. For HR preparation, if you are not sure about your communication skills it is good to practice aloud in your room or record while rehearsing.
3. Be energetic in the interview, try to drive the interview on your own.
Don’ts :
1. Take HR for granted if you have good soft skills.
2. For cases its better to practice mock rather than just reading through the case books.
College Name: IIT Kanpur
Pharmaace Analytics Interview FAQs
How many rounds are there in Pharmaace Analytics interview?
Pharmaace Analytics interview process usually has 2-3 rounds. The most common rounds in the Pharmaace Analytics interview process are One-on-one Round, HR and Resume Shortlist.
How to prepare for Pharmaace Analytics interview?
Go through your CV in detail and study all the technologies mentioned in your CV. Prepare at least two technologies or languages in depth if you are appearing for a technical interview at Pharmaace Analytics. The most common topics and skills that interviewers at Pharmaace Analytics expect are Analytics, Consulting, Market Research, Project Management and Business Strategy.
Tell us how to improve this page.
Pharmaace Analytics Interviews By Designations
Interview Questions for Popular Designations
- Executive Interview Questions
- Team Lead Interview Questions
- Software Developer 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
View more
Interview Questions from Similar Companies
Pharmaace Analytics Reviews and Ratings
based on 62 reviews
Rating in categories
PharmaACE - General Manager - Human Resources (12-15 yrs)
12-15 Yrs
Not Disclosed
PharmaACE - Associate Consultant/Senior Consultant - Advanced Analytics (1-8 yrs)
1-8 Yrs
Not Disclosed
PharmaACE - Consultant - Advanced Analytics (3-6 yrs)
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 |
Compare Pharmaace Analytics with
EXL Service
Compare
Access Healthcare
Compare
AGS Health
Compare
Straive
Compare
Popular Calculators
Did you find this page helpful?
Yes No
- Home >
- Interviews >
- Pharmaace Analytics Interview Questions
Share an Interview