Upload Button Icon Add office photos

Eli Lilly and Company

Compare button icon Compare button icon Compare

Filter interviews by

Eli Lilly and Company Associate Consultant Interview Questions and Answers

Updated 11 Feb 2025

Eli Lilly and Company Associate Consultant Interview Experiences

6 interviews found

I applied via Naukri.com and was interviewed in Mar 2021. There was 1 interview round.

Interview Questionnaire 

1 Question

  • Q1. Question different aws services (like S3 policy, Lambda, Glue, Data lake)

Interview Preparation Tips

Interview preparation tips for other job seekers - There were 3 rounds of interview.

1st Round-
Basic questions on your experience and some behaviour related question.

2nd Round (Case study and Aws questions)
They gave me 1 hour of time to solve the case study and come up with some optimized sql queries and there where 12 mcq on Aws and then 30 min discussion time for explaining everything.

3rd Round-
Questions on Tableau, Sql and Aws and asked me about my aspiration work.
Interview experience
4
Good
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Selected Selected

I was interviewed before Feb 2024.

Round 1 - One-on-one 

(2 Questions)

  • Q1. How would you handle conflicts
  • Q2. Biggest escalation in your previous company and how did u handle it?

Interview Preparation Tips

Interview preparation tips for other job seekers - Be confident and answer, there is no right or wrong

Associate Consultant Interview Questions Asked at Other Companies

asked in IQVIA
Q1. There are 2 cricket teams, A and B, with 11 players each. If ever ... read more
asked in KPMG India
Q2. While working late at night, you figure out that the data availab ... read more
asked in Capgemini
Q3. Could you tell me, which tools do you have used in test managemen ... read more
Q4. Reverse the String Problem Statement You are given a string STR w ... read more
Q5. Find the Third Greatest Element Given an array 'ARR' of 'N' disti ... read more
Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
2-4 weeks
Result
-

I was interviewed in Aug 2023.

Round 1 - One-on-one 

(1 Question)

  • Q1. Some sql questions and queries on joins, windows function, Rank, group by. Tableau questions on parameters, blending & joining, Lods.
Round 2 - One-on-one 

(1 Question)

  • Q1. Project manager took this round Some guesstimates and puzzles were being asked.
Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Naukri.com and was interviewed in Mar 2023. 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 - Technical 

(1 Question)

  • Q1. Question on csqa and gxp standard
Round 3 - HR 

(1 Question)

  • Q1. Discussion on salary and designation

Interview Preparation Tips

Interview preparation tips for other job seekers - Be confident and focus on communication skills.More

Eli Lilly and Company interview questions for designations

 Senior Consultant

 (2)

 Consultant

 (3)

 Associate

 (1)

 Associate Manager

 (4)

 Senior Associate

 (1)

 Associate Director

 (1)

 Senior Associate Manager

 (3)

 Regulatory Affairs Associate

 (1)

Interview experience
3
Average
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via LinkedIn and was interviewed before May 2023. There were 3 interview rounds.

Round 1 - Technical 

(1 Question)

  • Q1. Questions on Projects
Round 2 - Technical 

(1 Question)

  • Q1. 2SQL and 2 Python Questions
Round 3 - HR 

(1 Question)

  • Q1. Reason for change
Round 1 - Technical 

(1 Question)

  • Q1. Know how of excel. Excel is way vast and we all know. Positioning ourselves on scale of 10 could be the most frequent question and then justifying it on potential grounds.
Round 2 - One-on-one 

(1 Question)

  • Q1. Stress environment question
Round 3 - HR 

(1 Question)

  • Q1. Behavioral round : HR wanted to understand my inclination towards roles and responsibilities.

Interview Preparation Tips

Interview preparation tips for other job seekers - Be confident. That's definitely the key. keep in mind the poise and formal look is always an add on.

Associate Consultant Jobs at Eli Lilly and Company

View all

Interview questions from similar companies

Interview experience
5
Excellent
Difficulty level
Easy
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Naukri.com and was interviewed in Feb 2024. There was 1 interview round.

Round 1 - Technical 

(4 Questions)

  • Q1. How many types of joins in sql
  • Ans. 

    There are four types of joins in SQL: INNER JOIN, LEFT JOIN, RIGHT JOIN, and FULL JOIN.

    • INNER JOIN: Returns rows when there is at least one match in both tables.

    • LEFT JOIN: Returns all rows from the left table and the matched rows from the right table.

    • RIGHT JOIN: Returns all rows from the right table and the matched rows from the left table.

    • FULL JOIN: Returns rows when there is a match in one of the tables.

  • Answered by AI
  • Q2. Diff between list and set
  • Ans. 

    List is an ordered collection of elements with duplicates allowed, while set is an unordered collection of unique elements.

    • List maintains the order of elements, while set does not guarantee any specific order.

    • List allows duplicate elements, while set does not allow duplicates.

    • List is implemented using classes like ArrayList, LinkedList, etc., while set is implemented using classes like HashSet, TreeSet, etc.

  • Answered by AI
  • Q3. Diff between map set
  • Ans. 

    Map is a collection of key-value pairs where each key is unique, while a set is a collection of unique elements with no duplicate values.

    • Map allows duplicate values but keys must be unique, while set does not allow duplicates.

    • Map is accessed using keys, while set is accessed using elements.

    • Example: Map - {1: 'apple', 2: 'banana'}, Set - {'apple', 'banana'}

  • Answered by AI
  • Q4. Write Fibonacci program
  • Ans. 

    Fibonacci program generates the Fibonacci sequence up to a specified number of terms.

    • Start with two variables initialized to 0 and 1

    • Use a loop to calculate the next Fibonacci number by adding the previous two numbers

    • Repeat the process until the desired number of terms is reached

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - Be confident

Skills evaluated in this interview

Interview experience
5
Excellent
Difficulty level
Easy
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Company Website and was interviewed in Feb 2024. There were 3 interview rounds.

Round 1 - Group Discussion 

They will give a topic on the spot we need to talk about it

Round 2 - Technical 

(1 Question)

  • Q1. They give some issue we need to answer what trouble shooting we have to perform
Round 3 - HR 

(1 Question)

  • Q1. About projects and achievements
Interview experience
1
Bad
Difficulty level
Moderate
Process Duration
2-4 weeks
Result
Selected Selected

I applied via LinkedIn and was interviewed before Sep 2023. There were 2 interview rounds.

Round 1 - Assignment 

Basic Excel Test on formulas

Round 2 - Technical 

(2 Questions)

  • Q1. Irrelevant Questions on Journal Entries
  • Q2. Irrelevant Questions asked

Interview Preparation Tips

Topics to prepare for Novo Nordisk Associate Business Analyst interview:
  • Rude Behaviour
  • unprofessional
  • Very toxic
  • irrelevant questions
Interview preparation tips for other job seekers - Suggest not to sit for the interview if the interview is taken by a lady named Ashwini K who is a people manager for one of the teams. She was very rude, and very unprofessional.. The interview was just for a period of 20mins but she has left a very wrong impression on the company culture within that period.. Not sure how someone like her with this behaviour is given to take interviews and how can someone be a people manager with such behaviour.. Its because of few people like her an organisation and its culture is blamed..

Associate Interview Questions & Answers

Sanofi user image Yerravalli Rakesh Goud

posted on 28 Mar 2023

Interview experience
5
Excellent
Difficulty level
Easy
Process Duration
Less than 2 weeks
Result
Not Selected

I applied via Campus Placement and was interviewed in Feb 2023. 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 - Case Study 

My self yerravally Rakesh Goud.
My graduation bsc biotechnology in osmania university my inter Geetanjali junior college.qnd SCC ZPHS in nemtoor

Round 3 - Aptitude Test 

My self yerravally Rakesh Goud.im came from Telangana district and my education background i studied at osmania university bsc biotechnology and intermediate Geethanjali junior college and my ssc ZPHS nemtoor current working in Sanofi Healthcare Pvt Ltd india

Interview Preparation Tips

Interview preparation tips for other job seekers - I want A Good realtionship company
And more my short term goal get a job reputed company and long term goal is to achieve a good position where I can build my career and help the organisation too

Eli Lilly and Company Interview FAQs

How many rounds are there in Eli Lilly and Company Associate Consultant interview?
Eli Lilly and Company interview process usually has 2-3 rounds. The most common rounds in the Eli Lilly and Company interview process are Technical, One-on-one Round and HR.
How to prepare for Eli Lilly and Company Associate Consultant 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 Eli Lilly and Company. The most common topics and skills that interviewers at Eli Lilly and Company expect are Healthcare, SQL, Analytics, Analytical and Project Management.
What are the top questions asked in Eli Lilly and Company Associate Consultant interview?

Some of the top questions asked at the Eli Lilly and Company Associate Consultant interview -

  1. Know how of excel. Excel is way vast and we all know. Positioning ourselves on ...read more
  2. Question different aws services (like S3 policy, Lambda, Glue, Data lak...read more
  3. Some sql questions and queries on joins, windows function, Rank, group by. Ta...read more

Tell us how to improve this page.

Eli Lilly and Company Associate Consultant Interview Process

based on 6 interviews

2 Interview rounds

  • Technical Round
  • HR Round
View more

Interview Questions from Similar Companies

Hetero Interview Questions
3.9
 • 201 Interviews
Abbott Interview Questions
4.1
 • 146 Interviews
Viatris Interview Questions
4.2
 • 135 Interviews
Piramal Pharma Interview Questions
4.0
 • 91 Interviews
Novo Nordisk Interview Questions
4.1
 • 82 Interviews
Sanofi Interview Questions
4.2
 • 72 Interviews
View all
Eli Lilly and Company Associate Consultant Salary
based on 156 salaries
₹9 L/yr - ₹25.7 L/yr
90% more than the average Associate Consultant Salary in India
View more details

Eli Lilly and Company Associate Consultant Reviews and Ratings

based on 31 reviews

3.6/5

Rating in categories

3.0

Skill development

3.9

Work-life balance

4.0

Salary

3.7

Job security

3.5

Company culture

2.8

Promotions

3.1

Work satisfaction

Explore 31 Reviews and Ratings
Associate Consultant - FMSO - GOSO

Bangalore / Bengaluru

2-7 Yrs

Not Disclosed

Explore more jobs
Senior Associate Manager
225 salaries
unlock blur

₹9 L/yr - ₹30.1 L/yr

Associate Manager
162 salaries
unlock blur

₹8.1 L/yr - ₹21.5 L/yr

Associate Consultant
156 salaries
unlock blur

₹9 L/yr - ₹25.7 L/yr

Consultant
109 salaries
unlock blur

₹21 L/yr - ₹45 L/yr

Senior Associate Consultant
98 salaries
unlock blur

₹17.5 L/yr - ₹34 L/yr

Explore more salaries
Compare Eli Lilly and Company with

Pfizer

4.0
Compare

GlaxoSmithKline Pharmaceuticals

4.1
Compare

Merck

4.3
Compare

Johnson & Johnson

4.0
Compare
Did you find this page helpful?
Yes No
write
Share an Interview