ETL Automation Tester

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.

About the Organization:
builds and maintains capabilities using cutting edge technologies like most prominent tech companies. What differentiates 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 the enterprise.

About The Business Function
Business Units is a global organization strategically positioned so that through information and technology leadership and solutions, we create meaningful connections and remarkable experiences, so people feel genuinely cared for. The Business Unit organization is accountable for designing, developing, and supporting commercial or customer engagement services and capabilities that span multiple Business Units (Bio-Medicines, Diabetes, Oncology, International), functions, geographies, and digital channels. The areas supported by Business Unit includes: Customer Operations, Marketing and Commercial Operations, Medical Affairs, Market Research, Pricing, Reimbursement and Access, Customer Support Programs, Digital Production and Distribution, Global Patient Outcomes, and Real-World Evidence.

Job Title: ETL Automation Tester
An Automation Tester at BU plays a crucial role in ensuring the reliability, performance, and quality of software products within the Business Unit IDS organization. This position involves designing and executing automated test frameworks and scripts that support commercial or customer engagement services across multiple Business Units. Utilizing cutting-edge automation tools (Selenium, Playwright, Cypress), scripting languages (Java, Python, JavaScript), and CI/CD pipelines, the Automation Tester collaborates closely with developers, QA analysts, and product teams to build robust and continuous testing strategies. Senior Automation Testers define QA best practices, optimize test coverage, and contribute to agile delivery processes, ensuring that the solutions we provide meet the highest standards of excellence. Additionally, they mentor junior testers, drive test automation architecture, and play a key role in aligning testing processes with the overarching goals of our Business Units, ultimately enhancing user satisfaction and operational efficiency.

What You'll Be Doing

• Design, develop, and maintain test automation frameworks for data pipelines and integration testing.
• Collaborate with developers, product owners, and QA team members to understand requirements and define test strategies.
• Drive continuous testing and integration in CI/CD pipelines using GitHub Actions, or Azure DevOps.
• Ensure comprehensive test coverage and defect traceability across functional and regression test suites.
• Identify, document, and track defects, working with development teams to ensure timely resolution.
• Perform code reviews and contribute to automation architecture decisions & improvements.
• Contribute to release planning by estimating test efforts, timelines, and risks.
• Develop, maintain, and document a software test environment.
• Create and review test reports.
• Implement automated regression testing tools and processes.
• Promote, encourage, and champion the use of automated testing.
• Participate in regular SAFe Agile framework team ceremonies.
• Create required Artifacts and get them reviewed and approved by the required stakeholders.

How You Will Succeed:

• Deliver reliable and efficient test automation solutions that reduce manual effort and enhance product quality.
• Collaborate effectively across agile teams to ensure early identification and resolution of defects.
• Drive QA excellence by promoting coding standards, automation reusability, and continuous integration.
• Continuously improve test systems through framework enhancements, root cause analysis, and proactive monitoring.
• Communicate effectively to ensure testing transparency and stakeholder alignment.

What You Should Bring

• Strong proficiency in test automation scripting using Java, Python, or JavaScript.
• Familiarity with version control systems (Git), CI/CD tools (Jenkins, GitHub Actions, Azure DevOps), and containerized environments.
• Good understanding of Agile testing methodologies, test planning, and defect lifecycle.
• Knowledge of test design techniques, test data management, and risk-based testing approaches.
• Experience with performance testing tools like JMeter or Gatling is a plus.
• A keen eye for detail, strong debugging skills, and a passion for building robust test solutions.
• Strong verbal and written communication skills, with the ability to collaborate across technical and non-technical teams.

Basic Qualifications And Experience Requirement

• Bachelor's degree in Computer Science, Engineering, or a related technical field.
• 6–8 years of experience in test automation across web, mobile, and API layers.
• Proven experience designing and maintaining scalable automation frameworks using Selenium, Cypress, or similar tools.
• Hands-on experience integrating automated tests into CI/CD pipelines.
• Experience working in Agile/Scrum environments, with strong collaboration in cross-functional teams.
• Working knowledge of defect tracking and test management tools such as JIRA, TestRail, or Zephyr.
• Familiarity with testing in cloud-based environments (AWS, Azure, or GCP) and container platforms like Docker.
• Demonstrated ability to mentor junior QA engineers and lead automation initiatives.
• Ability to translate user stories and business requirements into detailed test cases and automation scripts.
• Understanding of software development lifecycle (SDLC) and software testing lifecycle (STLC).
• 3+ years of experience on Agile, version control (GitHub) and CI/CD.
• ETL Tester with 3+ years of experience on SQL, Python, AWS / Azure.
• Data warehousing concepts.

Additional Skills/Preferences

• Domain experience in healthcare, pharmaceutical ( Customer Master, Product Master, Alignment Master, Activity, Consent etc. ), or regulated industries is a plus.
• Test ISTQB Certified will be an added advantage.
• Partner with and influence vendor resources on solution development to ensure understanding of data and technical direction for solutions as well as delivery
• Exposure to security testing or accessibility testing frameworks.
• Ability to drive automation in a DevOps or SRE-driven environment.

Additional Information

• N/A

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.