Upload Button Icon Add office photos

Eli Lilly and Company

Compare button icon Compare button icon Compare

Filter interviews by

Eli Lilly and Company Senior Data Analyst Interview Questions and Answers

Updated 27 Jun 2024

Eli Lilly and Company Senior Data Analyst Interview Experiences

1 interview found

Senior Data Analyst Interview Questions & Answers

user image Adithya pythireddi

posted on 27 Jun 2024

Interview experience
5
Excellent
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Technical 

(2 Questions)

  • Q1. Using sql extract substring of name
  • Ans. 

    Using SQL to extract substring of name

    • Use the SUBSTRING function in SQL to extract a specific portion of a string

    • Specify the starting position and length of the substring to be extracted

    • Example: SELECT SUBSTRING('John Doe', 1, 4) AS First_Name will return 'John'

  • Answered by AI
  • Q2. Using sql print cummulative sum of sales
  • Ans. 

    Use SQL to print cumulative sum of sales

    • Use the SUM() function to calculate the cumulative sum of sales

    • Utilize the OVER() clause with ORDER BY to specify the order of the cumulative sum

    • Example: SELECT date, sales, SUM(sales) OVER (ORDER BY date) AS cumulative_sales FROM table_name

  • Answered by AI

Skills evaluated in this interview

Interview questions from similar companies

Interview experience
4
Good
Difficulty level
Moderate
Process Duration
4-6 weeks
Result
Not Selected

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

Round 1 - HR 

(1 Question)

  • Q1. Why did you choose to work at Pfizer?
Round 2 - One-on-one 

(1 Question)

  • Q1. Tell me about your project
Round 3 - Group Discussion 

Time management and organization skills

I applied via Recruitment Consulltant and was interviewed before May 2021. There were 4 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 

(3 Questions)

  • Q1. Questions related to Data analytics and SharePoint for my role.
  • Q2. Previous projects and their solutions.
  • Q3. Tool used in previous company. (SharePoint, Power BI, Nintex, InfoPath, Power Apps, Workflows)
Round 3 - Interview 

(1 Question)

  • Q1. Related to professional life and assurance to work.
Round 4 - HR 

(1 Question)

  • Q1. Salary details and candidature check.

Interview Preparation Tips

Interview preparation tips for other job seekers - Prepare well with you technical rounds. It will be medium level (not to easy or difficult in cracking the interview).
Round 1 - Assignment 

Tableau Developer

I was given an assignment where I had to build dashboard with final story within 1 hour

Round 2 - One-on-one 

(1 Question)

  • Q1. Why Novo? Why this role?
Round 3 - One-on-one 

(1 Question)

  • Q1. Director Round with department head
Round 4 - One-on-one 

(1 Question)

  • Q1. Affiliate Round with either US folks or Denmark folks
Round 5 - HR 

(4 Questions)

  • Q1. What is your family background?
  • Q2. What are your strengths and weaknesses?
  • Q3. Tell me about yourself.
  • Q4. What are your salary expectations?

Interview Preparation Tips

Interview preparation tips for other job seekers - Be true with respect to tour resume
Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
-
Result
Selected Selected
Round 1 - One-on-one 

(1 Question)

  • Q1. How to handle noise in data
Interview experience
5
Excellent
Difficulty level
-
Process Duration
-
Result
-
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 - Interview 

(1 Question)

  • Q1. Tell me about all your Candidature Background.
Round 3 - HR 

(1 Question)

  • Q1. Salary Negotiation

Interview Preparation Tips

Interview preparation tips for other job seekers - My Interview was quite impressive. Your interview in AKUMS done by your Department HOD. The Interview process is simple you answers all the questions without any hesitation. So All The Best & Do Your Best.

I applied via Company Website and was interviewed before Jun 2021. There were 3 interview rounds.

Round 1 - One-on-one 

(1 Question)

  • Q1. It was very cool and the recruiter was very energetic.
Round 2 - Case Study 

Business usecases technical discussion and written test

Round 3 - HR 

(1 Question)

  • Q1. Professional experiences

Interview Preparation Tips

Interview preparation tips for other job seekers - Be confident while answering and the answers should be very detail and neat.

Interview Questionnaire 

1 Question

  • Q1. HR interview , manager interview,case studies (this was actually data based case study. You will have data in excel sheet you need to answer the question using charts and other insights)

Interview Preparation Tips

Interview preparation tips for other job seekers - They must’ve done the case study first and then manager interview.
Interview experience
1
Bad
Difficulty level
Easy
Process Duration
4-6 weeks
Result
Selected Selected

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

Round 1 - Assignment 

There was an assignment which needed basic excel skills.

Round 2 - Technical 

(1 Question)

  • Q1. Journal Entries

Interview Preparation Tips

Interview preparation tips for other job seekers - To start with my background, i have a good number of experience with some of the top notch MNC’s. It was two months back i had an opportunity to sit for an interview with Novonordisk. The panel was highly disrespectful, insulting and very egoistic who neither knows on how to lead an interview.
It was Ashwini K and Yukti Agarwal who took my interview. I felt them intentionally trying to bully and insult me for each point that i speak right from the beginning of the interview. These happened once they got to know of my salary expectation, which was a standard 35% of my CCTC, which was agreed by the HR before the call was scheduled. The interview didn’t start with any kind of formal introduction from their side, instead the first point they started with asking my CCTC and my ECTC post which the insulting session started.
I wouldn’t suggest anyone reading this to sit for an interview with Novo Nordisk if its with the same panel. Questions asked was very irrelevant to the role and it felt very intentional. I would especially like to highlight Ashwini K’s behaviour to be very casual and unprofessional, and her knowledge is very limited.
I am glad that i have withdrawn myself in advance than proceeding further with my candidature with Novonordisk as i believe currently i am in a much better place than being in a company that doesn’t know to respect its people.

I applied via Naukri.com and was interviewed in Apr 2021. There were 3 interview rounds.

Interview Questionnaire 

4 Questions

  • Q1. Key roles , responsibilities and initiatives taken during the journey in the organization
  • Q2. Any certified support the process or the project
  • Q3. Strength and weaknesses
  • Q4. Changes in KPI every quarter
  • Ans. 

    Changes in KPI every quarter - how to handle?

    • Understand the reason for the changes

    • Analyze the impact on business goals

    • Communicate the changes to stakeholders

    • Adjust strategies and plans accordingly

    • Track and measure the new KPIs

    • Continuously evaluate and improve

    • Examples: sales targets, customer satisfaction, employee retention

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - Explain the roles and the process that you follow in every organization and be positive

Eli Lilly and Company Interview FAQs

How many rounds are there in Eli Lilly and Company Senior Data Analyst interview?
Eli Lilly and Company interview process usually has 1 rounds. The most common rounds in the Eli Lilly and Company interview process are Technical.
How to prepare for Eli Lilly and Company Senior Data Analyst 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 Analytics, Healthcare, Pharma, CRO and Clinical Data Management.
What are the top questions asked in Eli Lilly and Company Senior Data Analyst interview?

Some of the top questions asked at the Eli Lilly and Company Senior Data Analyst interview -

  1. using sql extract substring of n...read more
  2. using sql print cummulative sum of sa...read more

Tell us how to improve this page.

Eli Lilly and Company Senior Data Analyst Interview Process

based on 1 interview

Interview experience

5
  
Excellent
View more

Interview Questions from Similar Companies

Hetero Interview Questions
3.8
 • 228 Interviews
Abbott Interview Questions
4.1
 • 150 Interviews
Viatris Interview Questions
4.2
 • 139 Interviews
Piramal Pharma Interview Questions
4.0
 • 93 Interviews
Novo Nordisk Interview Questions
4.1
 • 83 Interviews
Sanofi Interview Questions
4.2
 • 74 Interviews
View all
Eli Lilly and Company Senior Data Analyst Salary
based on 11 salaries
₹20 L/yr - ₹33.3 L/yr
122% more than the average Senior Data Analyst Salary in India
View more details

Eli Lilly and Company Senior Data Analyst Reviews and Ratings

based on 1 review

5.0/5

Rating in categories

5.0

Skill development

5.0

Work-life balance

5.0

Salary

5.0

Job security

5.0

Company culture

3.0

Promotions

5.0

Work satisfaction

Explore 1 Review and Rating
Senior Associate Manager
225 salaries
unlock blur

₹9 L/yr - ₹30.1 L/yr

Associate Consultant
190 salaries
unlock blur

₹9 L/yr - ₹25.7 L/yr

Associate Manager
163 salaries
unlock blur

₹8.1 L/yr - ₹21.5 L/yr

Consultant
112 salaries
unlock blur

₹21 L/yr - ₹41 L/yr

Senior Associate Consultant
110 salaries
unlock blur

₹16 L/yr - ₹34 L/yr

Explore more salaries
Compare Eli Lilly and Company with

Hetero

3.9
Compare

Viatris

4.2
Compare

Abbott

4.1
Compare

Akums Drugs & Pharmaceuticals Limited

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