ETL Tester

Job Title: ETL Tester]

Location: Bangalore

Role Summary:

Reporting to the QA Manager, the ETL Tester is responsible for the timely planning, execution, and reporting of Quality Assurance testing activities for new and enhanced data and analytics solutions. This role focuses on ensuring data quality, reliability, and fitness for purpose across ETL pipelines, databases, and downstream analytics platforms. The role partners closely with Scrum teams, product owners, data engineers, and business stakeholders to embed quality-first principles throughout the delivery lifecycle, primarily within a SAFe Agile environment.

Key Responsibilities:

• Own and deliver QA targets for assigned projects, ensuring quality outcomes are met
• Develop deep product and data understanding and create effective test designs
• Execute test cases and log, track, and manage defects
• Define test priorities and create efficient execution plans
• Participate in defect triage sessions and root cause analysis
• Actively participate in PI planning, sprint planning, and Agile ceremonies
• Track and report test progress against agreed plans
• Contribute to sprint retrospectives and continuous improvement initiatives
• Apply appropriate test techniques, methodologies, and tools to maximise test coverage
• Mentor and support junior QA team members
• Adhere to Quality Engineering best practices and actively drive efficiency improvements

Required Skills and Experience:

• Bachelor’s degree in Computer Science or related discipline, or equivalent experience
• 3–8 years’ experience in Software QA with strong focus on ETL and data testing
• Proven experience validating ETL extraction, transformation, and load processes
• Strong SQL skills, including stored procedures and backend testing
• Experience testing across multiple database types
• Hands-on experience with ETL testing tools
• Test automation experience using code, preferably Python
• Strong understanding of the full test lifecycle
• Experience using Microsoft SQL Server tools
• Knowledge of healthcare insurance industry
• Strong understanding of SDLC and Agile delivery models
• Experience with automated testing and modelling tools
• Strong change management and test design skills
• Quality metrics, dashboards, and release readiness reporting
• Excellent written and verbal communication skills
• Strong analytical and problem-solving skills
• Ability to work independently or lead within a team
• High attention to detail and accuracy
• Commitment to continuous personal development

Desirable Skills and Experience:

• ISTQB Foundation or Intermediate certification
• Database and API testing experience
• Cloud Platforms: Hands-on testing experience in (AWS / Microsoft Azure)
• Ownership of data quality strategy and test approach across analytics platforms
• Test automation using Python
• ETL tools such as SSIS
• Relational database expertise using SQL (or PostgreSQL, DBeaver)
• Web technologies (Java, HTML)
• Salesforce and Vlocity experience
• Selenium or UFT experience

About The Cigna Group