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:u00A0u00A0

Tech@LillyBusiness 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 Testeru00A0

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:u00A0u00A0

• Design, develop, and maintaintest automation frameworks for data pipelines and integration testing.u00A0

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

u2022Drive 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

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

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

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

u2022Develop, maintain, and document a software test environment.u00A0

u2022Create and review test reports.u00A0

u2022Implement automated regression testing tools and processes.u00A0

u2022Promote, encourage, and champion the use of automated testing.u00A0

u2022Participate in regular SAFe Agile framework team ceremonies.u00A0

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

u00A0

How You Will Succeed:u202Fu00A0

• 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:u00A0u00A0

• 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 deliveryu00A0

• 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/Au00A0