Eli Lilly and Company Senior Data Engineer Interview Questions and Answers

Q1. Explain about project in detail
Add your answer
Q2. How did you manage so much cgpa?
Ans. 
I managed a high CGPA through consistent hard work, effective time management, seeking help when needed, and staying organized.
• Consistent hard work by studying regularly and staying focused on academics

• Effective time management to balance studies, assignments, and extracurricular activities

• Seeking help from professors, tutors, or classmates when facing challenges

• Staying organized with study schedules, notes, and deadli
Answered by AI
Add your answer

Q1. Difference rank dense rank and rownumber
Ans. 
Rank, Dense Rank, and Row Number are window functions used in SQL to assign a rank to each row based on a specific criteria.
• Rank assigns a unique rank to each row based on the specified order.

• Dense Rank assigns a unique rank to each row without any gaps, even if there are ties.

• Row Number assigns a unique sequential integer to each row, without any regard to the order of the rows.
Answered by AI
Add your answer
Q2. Questions from join condition
Add your answer

Q1. 2 technical Rounds and then managerial And HR
Add your answer

Q1. SQL , cloud , Unix , python , scripting
Add your answer

Q1. Behaviural Questions
Add your answer

Q1. Tableau Desktop Technical
Add your answer

17 questions including mcq, case study, sql coding

Q1. 10 quiz about ML questions, case study
Add your answer

Tableau Developer

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

Q1. Why Novo? Why this role?
Add your answer

Q1. Director Round with department head
Add your answer

Q1. Affiliate Round with either US folks or Denmark folks
Add your answer

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

Q1. Discussion with hiring manager
Add your answer
Q2. What is your career goal ?
Ans. 
To become a technical leader in software engineering, contributing to innovative projects and mentoring junior engineers.
• To continuously enhance my technical skills and stay updated with the latest technologies.

• To lead and deliver complex software projects successfully.

• To mentor and guide junior engineers, fostering their growth and development.

• To contribute to the development of innovative and impactful software solut...read more
Answered by AI
View 1 more answer

Q1. Behaviour questions on cloud hosting
Add your answer
Q2. How will you implement secure cloud deployments
Ans. 
Secure cloud deployments can be implemented through various measures such as encryption, access control, and regular security audits.
• Implement encryption for data at rest and in transit

• Use access control mechanisms to restrict unauthorized access

• Regularly conduct security audits to identify and address vulnerabilities

• Implement multi-factor authentication for added security

• Ensure compliance with industry standards and r...read more
Answered by AI
View 1 more answer

Q1. How will you troubleshoot 500 internal server error
Ans. 
Check server logs, review code, test endpoints, and verify database connections.
• Check server logs for error messages

• Review code for syntax errors or logical mistakes

• Test endpoints using tools like Postman or cURL

• Verify database connections and credentials

• Check for any recent changes or updates

• Consider scaling issues or server overload

• Consult with team members or experts if necessary
Answered by AI
View 1 more answer

Q1. What is your next career goals ?
Ans. 
My next career goal is to become a technical lead and mentor junior engineers.
• I want to take on more leadership responsibilities and guide a team towards success.

• I plan to enhance my skills in project management and communication.

• I aim to contribute to the growth and development of the organization.

• I aspire to continuously learn and stay updated with the latest technologies and industry trends.
Answered by AI
Add your answer