Eli Lilly and Company Interview Questions, Process, and Tips

Q1. Mostly on project
Add your answer
Q2. Briefly explain any of your project
Add your answer

Resume round that mainly focused on relevant projects

Q1. Why are you looking for a switch?
Ans. 
Seeking new challenges and opportunities for growth.
• Looking for new challenges and opportunities to expand my skills

• Interested in working with a different client base or industry

• Seeking a more collaborative team environment

• Want to take on more leadership responsibilities
Answered by AI
Add your answer
Q2. Why switching to Eli Lilly?
Add your answer

Business case about increasing market share

Q1. Why this role and this company
Add your answer
Q2. Tell me about a time you failed and what did you learn from it?
Add your answer

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
Add your answer
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
Add your answer

Basic python and one simple coding exercise

Q1. Technical experience
Add your answer

Q1. Situational scenarios based on experience
Add your answer

Q1. Expectations from the new role
Add your answer