ETL Automation Tester

About the Tech@Lilly Organization : u00A0

Tech@Lilly builds and maintains capabilities using cutting edge technologies like most prominent tech companies. What differentiates Tech@Lilly is that we create new possibilities through tech to advance our purpose u2013 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. u00A0

u00A0

About the Business Function : u00A0 u00A0

Tech@Lilly 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. u00A0

u00A0

Job Title : ETL Automation Tester u00A0

An Automation Tester at BU Tech@Lilly 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. u00A0

What youu2019ll be doing : u00A0 u00A0

Design, develop, and maintain test automation frameworks for data pipelines and integration testing. u00A0

u2022 Collaborate with developers, product owners, and QA team members to understand requirements and define test strategies. u00A0

u2022 Drive continuous testing and integration in CI / CD pipelines using GitHub Actions, or Azure DevOps. u00A0

u2022 Ensure comprehensive test coverage and defect traceability across functional and regression test suites. u00A0

u2022 Identify , document, and track defects, working with development teams to ensure timely resolution. u00A0

u2022 Perform code reviews and contribute to automation architecture decisions & improvements. u00A0

u2022 Contribute to release planning by estimating test efforts, timelines, and risks. u00A0

u2022 Develop, maintain , and document a software test environment. u00A0

u2022 Create and review test reports. u00A0

u2022 Implement automated regression testing tools and processes. u00A0

u2022 Promote, encourage, and champion the use of automated testing. u00A0

u2022 Participate in regular SAFe Agile framework team ceremonies. u00A0

u2022 Create required Artifacts and get them reviewed and approved by the required stakeholders. u00A0

u00A0

How You Will Succeed : u202F u00A0

Deliver reliable and efficient test automation solutions that reduce manual effort and enhance product quality. u00A0

Collaborate effectively across agile teams to ensure early identification and resolution of defects. u00A0

Drive QA excellence by promoting coding standards, automation reusability, and continuous integration. u00A0

Continuously improve test systems through framework enhancements, root cause analysis, and proactive monitoring. u00A0

Communicate effectively to ensure testing transparency and stakeholder alignment. u00A0

u00A0

What You should Bring : u00A0

u00A0u00A0 Strong proficiency in test automation scripting using Java, Python, or JavaScript. u00A0

Familiarity with version control systems (Git), CI / CD tools (Jenkins, GitHub Actions, Azure DevOps), and containerized environments. u00A0

Good understanding of Agile testing methodologies, test planning, and defect lifecycle. u00A0

Knowledge of test design techniques , test data management, and risk-based testing approaches. u00A0

Experience with performance testing tools like JMeter or Gatling is a plus. u00A0

A keen eye for detail , strong debugging skills, and a passion for building robust test solutions. u00A0

Strong verbal and written communication skills , with the ability to collaborate across technical and non-technical teams. u00A0

u00A0

u00A0

Basic Qualifications and Experience Requirement : u00A0 u00A0

Bacheloru2019s degree in Computer Science , Engineering, or a related technical field. u00A0

6u20138 years of experience in test automation across web, mobile, and API layers. u00A0

Proven experience designing and maintaining scalable automation frameworks using Selenium, Cypress, or similar tools. u00A0

Hands-on experience integrating automated tests into CI / CD pipelines. u00A0

Experience working in Agile / Scrum environments, with strong collaboration in cross-functional teams. u00A0

Working knowledge of defect tracking and test management tools such as JIRA, TestRail, or Zephyr. u00A0

Familiarity with testing in cloud-based environments (AWS, Azure, or GCP) and container platforms like Docker. u00A0

Demonstrated ability to mentor junior QA engineers and lead automation initiatives. u00A0

Ability to translate user stories and business requirements into detailed test cases and automation scripts. u00A0

Understanding of software development lifecycle (SDLC) and software testing lifecycle (STLC). u00A0

3 + years of experience on Agile, version control (GitHub) and CI / CD. u00A0

ETL Tester with 3 + years of experience on SQL, Python, AWS / Azure. u00A0

Data warehousing concepts. u00A0

u00A0

Additional Skills / Preferences : u00A0

Domain experience in healthcare, pharmaceutical ( Customer Master, Product Master, Alignment Master, Activity, Consent etc.u00A0 ) , or regulated industries is a plus. u00A0

Test ISTQB Certified will be an added advantage. u00A0

Partner with and influence vendor resources on solution development to ensure understanding of data and technical direction for solutionsu202Fas well as delivery u00A0

Exposure to security testing or accessibility testing frameworks. u00A0

Ability to drive automation in a DevOps or SRE-driven environment. u00A0

u00A0

Additional Information : u00A0

N / A u00A0

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.

Lillyu00A0does 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.

#WeAreLilly

Skills Required

Jira, Zephyr, Java, Testrail, Selenium, cypress , Aws, Python, Azure, Docker, Gcp, Javascript, Azure Devops