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 Business Function**:
**Job Title**:ETL** Automation Tester**

**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 does not discriminate on the basis of age, race, color, religion, gender, sexual orientation