Test Automation Database Expert

At Lilly, we unite caring with discovery to make life better for people around the world. We are a global healthcare leader headquartered in Indianapolis, Indiana. Our employees around the world work to discover and bring life-changing medicines to those who need them, improve the understanding and management of disease, and give back to our communities through philanthropy and volunteerism. We give our best effort to our work, and we put people first. We're looking for people who are determined to make life better for people around the world.

Test Automation DB Expert

Department:

Location:

Eli Lilly, Hyderabad

Position Type:

Full-Time

Level:

P2-P3

Job Description

Are you passionate about leveraging technology to automate and transform business processes? Do you have a deep understanding of test automation and a desire to drive innovation in enterprise systems? If so, the technology at Lilly Enterprise Test Automation team invites you to apply for the role of Test Automation Expert.

As a key Test Automation Expert, you will be responsible for driving the quality and reliability of automation solutions across the enterprise. In this role, you will work closely with functional IT teams to gain a deep understanding of their domains and applications, providing technical consultation, contributing to automation architecture design, and leading initial setup activities to enable effective test automation Are you innovative and curious about new technology that can make business processes easier and more efficient? Come join our team

Automation in Software Testing

Lilly's mission is to develop and maintain software products that meet the needs and requirements of both our internal and external customers. This typically involves a combination of activities such as gathering and analysing user requirements, designing, and implementing software solutions, testing and debugging code, and maintaining and improving the performance and reliability of the software over time. The goal of software engineering at Lilly is to create high-quality, reliable, and effective software utilizing cutting edge methodologies and integrations to solve Lilly's real-world problems and provide value to our customers.

At Lilly, our Technology Enablement initiatives—particularly within the Enterprise Test Automation Centre of Excellence (TACoE)—are designed to leverage modern tools and practices to enhance the quality, speed, and reliability of software delivery. We are committed to embedding automated testing into the core of our engineering processes, enabling innovation, reducing manual effort, and delivering sustainable value to our operations and customers.

As an Enterprise Test Automation Expert, you will play a pivotal role in driving the adoption of cutting-edge test automation frameworks, fostering a culture of continuous integration and deployment, and guiding teams across the enterprise to achieve robust, scalable, and efficient test automation practices.

Key responsibilities:

• Serve as a liaison across various technology at Lilly functional areas to promote and support enterprise-wide test automation initiatives.
• Lead and mentor a diverse team of Test Leads and Engineers to rapidly initiate and scale test automation efforts.
• Provide expert consultation on test automation tools, solution fit, and best practices.
• Champion an "automation-first" mindset in test execution strategies and software delivery.
• Develop deep technical expertise in test automation platforms and industry best practices to drive innovation and continuous improvement.
• Align people, tools, and processes to enable rapid and reusable automation solutions across the enterprise.
• Continuously evaluate and validate emerging automation tools and technologies to ensure Lilly remains at the forefront of innovation.
• Collaborate with the Test Automation Architect to ensure platform stability, security, performance, and scalability.
• Partner with peers to define and maintain automation metrics and KPIs, including dashboards and automated reporting.
• Work closely with delivery teams to anticipate demand, plan capacity, and ensure timely project execution.
• Act as a consulting partner to functional teams, identifying automation opportunities and guiding the implementation of scalable, sustainable test automation strategies.
• Serve in a techno-functional role, collaborating with various functional areas and the Enterprise Test Automation team to bridge gaps and ensure effective automation solutions.

Qualifications

• Bachelor's degree in computer science, Information Technology, or a related field.
• 8+ years of relevant experience in the field
• Proven experience as a technical leader, with the ability to influence strategic direction and drive implementation across multiple projects.
• Extensive hands-on experience in software testing and test automation tools and technologies.
• Proficiency in various testing types: functional, integration, regression, mobile, data, cross-platform, component, security, and UI/UX testing.
• Strong understanding of hybrid cloud and cloud-native architectures, integration strategies, and security considerations.
• Demonstrated ability to build relationships, lead diverse teams, and drive operational improvements.
• Should have experience with stakeholder management, influencing without authority, relationship management
• Should have experience leading testing teams in executing large scale test plans for complex systems
• Provide technical leadership and mentorship to team members, fostering a culture of continuous improvement.
• Exposure to Power BI, Splunk, or similar monitoring/reporting tools.
• Candidate should have prior experience working in the pharmaceutical or life sciences domain.

Preferred Skills

• Excellent analytical, problem-solving, and communication skills.
• High intellectual and technical curiosity with a passion for continuous improvement and innovation.

• Functional Testing and Database Testing

• Experience with Agile methodologies such as Scrum, Kanban, and SAFe.

• Hands-on experience testing database objects such as tables, views, indexes, stored procedures, functions, and triggers.
• Strong experience in data migration testing and ETL testing.
• Experience in performance tuning and database profiling.
• Experience with Agile methodologies such as Scrum, Kanban, and SAFe.
• Experience with ETL tools like Talend, PySpark, Informatica PowerCenter or similar
• Experience in Python scripting for automation and testing tasks

About the Organization:

Lilly IT builds and maintains capabilities using cutting edge technologies like most prominent tech companies. What differentiates Lilly IT is that we create new possibilities through tech to advance our purpose – creating medicines that make life better for people around the world, like data driven drug discovery and connected clinical trials. We hire the best technology professionals from a variety of backgrounds, so they can bring an assortment of knowledge, skills, and diverse thinking to deliver innovative solutions in every area of our business.

The Enterprise Automation team, part of DIGITAL CORE, drives technology platforms that enable business transformation through scale, speed, and innovation. Focused on delivering exceptional employee experiences and empowering teams through digital solutions, the team redefines ways of working to boost productivity. As technology leaders, they serve as a catalyst for innovation and agility across the enterprise, playing a key role in shaping and executing the company's broader technology strategy.

Will this position support sponsorship:

No

Travel percentage for this position:

0-10%

Lilly is dedicated to helping individuals with disabilities to actively engage in the workforce, ensuring equal opportunities when vying for positions. If you require accommodation to submit a resume for a position at Lilly, please complete the accommodation request form ) for further assistance. Please note this is for individuals to request an accommodation as part of the application process and any other correspondence will not receive a response.

Lilly does not discriminate on the basis of age, race, color, religion, gender, sexual orientation, gender identity, gender expression, national origin, protected veteran status, disability or any other legally protected status.