Senior Test Lead Job in Indium Software

QA Testing Lead (ETL Testing)

Role Overview

We are seeking an experienced QA Testing Lead with expertise in ETL testing to ensure the accuracy, integrity, and performance of data processes. The ideal candidate should have team-handling experience, strong communication skills, and a solid understanding of data warehouse concepts.

This role requires close collaboration with onshore and offshore teams to coordinate test strategies, perform data validations, and ensure seamless ETL testing execution.

Key Responsibilities

Test Strategy & Execution

• Review business requirements and prepare comprehensive test plans.
• Develop and execute ETL test cases, test scripts, and test plans.
• Perform data validations, reconciliations, and integrity checks.
• Ensure accurate data transformations, mappings, and loading processes.

ETL Testing Expertise

• Conduct various types of ETL testing, including:
• Metadata Testing
• Data Completeness Testing
• Data Accuracy Testing
• Data Transformation Testing
• Data Quality Testing
• Initial/Incremental Load Testing
• Run SQL queries to verify data consistency between source and target systems.
• Work on dimensional modeling concepts (star schemas, snowflakes, dimensions, and facts).

Team Coordination & Collaboration

• Lead onshore-offshore testing teams and ensure smooth project execution.
• Collaborate with data architects, developers, and business teams.
• Coordinate with stakeholders to provide timely status updates and solutions.

Process Improvement & Reporting

• Ensure testing best practices, including automation where applicable.
• Prepare test reports, defect tracking, and performance analysis.
• Proactively identify, troubleshoot, and resolve testing challenges.

Required Qualifications & Skills

Technical Expertise:

• ETL testing experience in large-scale enterprise projects.
• Strong SQL skills for data validation and reconciliation.
• Hands-on experience in ETL tools (Informatica, Talend, DataStage, etc.).
• Familiarity with data warehousing concepts and dimensional modeling.

Leadership & Coordination:

• Proven team-handling skills in an onshore-offshore model.
• Strong communication and stakeholder management abilities.
• Ability to work independently and drive testing initiatives.

Domain Knowledge (Preferred):

• Experience in eCommerce, online shopping, sales, or retail domain.

Apply Now & Join a High-Impact QA Team!