ETL Test Lead

Aarushi Infotech; Chennai District; On-site; INR 1,500,000 - 2,300,000; Full time

Job summary

Aarushi Infotech in Chennai seeks a Senior QA professional with 8–12 years of hands‑on experience in Software Testing and Quality Assurance, focusing on Data Warehouse and ETL testing. You will validate BI reporting and perform STM validation.

The role requires Unix/Linux proficiency, experience with Oracle, SQL Server, PostgreSQL, MySQL or Teradata, and familiarity with Jira/Confluence. You will work in an Agile/DevOps environment and collaborate with cross‑functional teams to deliver quality

Qualifications

• 8–12 years of hands-on experience in Software Testing / Quality Assurance.
• Strong experience in Data Warehouse and ETL Testing.
• Good exposure to Business Intelligence (BI) applications and reporting validation.
• Strong SQL skills with ability to write complex queries involving joins, subqueries, aggregations, and validations.
• Experience in Source-to-Target Mapping (STM) validation.
• Knowledge of ETL concepts and testing methodologies.
• Good understanding of data validation, reconciliation, and data quality checks.
• Working knowledge of Unix/Linux commands.
• Experience working with relational databases such as Oracle, SQL Server, PostgreSQL, MySQL, or Teradata.

Skills

Software Testing

Data Warehouse

ETL Testing

BI Applications

SQL

STM Validation

ETL Concepts

Data Validation

Unix/Linux

Relational Databases

Jira

Confluence

Agile Scrum

DevOps

Test Data Management

Stakeholder Communication

Tools

Jira

Confluence

Job description

• 8–12 years of hands-on experience in Software Testing / Quality Assurance.
• Strong experience in Data Warehouse and ETL Testing.
• Good exposure to Business Intelligence (BI) applications and reporting validation.
• Strong SQL skills with ability to write complex queries involving joins, subqueries, aggregations, and validations.
• Experience in Source-to-Target Mapping (STM) validation.
• Knowledge of ETL concepts and testing methodologies.
• Good understanding of data validation, reconciliation, and data quality checks.
• Working knowledge of Unix/Linux commands.
• Experience working with relational databases such as Oracle, SQL Server, PostgreSQL, MySQL, or Teradata.

Required Technical Skills

• 8–12 years of hands-on experience in Software Testing / Quality Assurance.
• Strong experience in Data Warehouse and ETL Testing.
• Good exposure to Business Intelligence (BI) applications and reporting validation.
• Strong SQL skills with ability to write complex queries involving joins, subqueries, aggregations, and validations.
• Experience in Source-to-Target Mapping (STM) validation.
• Knowledge of ETL concepts and testing methodologies.
• Good understanding of data validation, reconciliation, and data quality checks.
• Working knowledge of Unix/Linux commands.
• Experience working with relational databases such as Oracle, SQL Server, PostgreSQL, MySQL, or Teradata.

Must Have

• 8–12 years of hands-on experience in Software Testing / Quality Assurance.
• Strong experience in Data Warehouse and ETL Testing.
• Good exposure to Business Intelligence (BI) applications and reporting validation.
• Strong SQL skills with ability to write complex queries involving joins, subqueries, aggregations, and validations.
• Experience in Source-to-Target Mapping (STM) validation.
• Knowledge of ETL concepts and testing methodologies.
• Good understanding of data validation, reconciliation, and data quality checks.
• Working knowledge of Unix/Linux commands.
• Experience working with relational databases such as Oracle, SQL Server, PostgreSQL, MySQL, or Teradata.

Preferred Skills

• Exposure to ETL tools such as Informatica, DataStage, Talend, SSIS, Ab Initio, Azure Data Factory, or similar platforms.
• Knowledge of cloud-based data platforms such as Azure, AWS, or Google Cloud.
• Experience with Big Data technologies is an added advantage.

Project & Process Skills

Agile & DevOps

• Strong understanding of Agile Scrum methodologies.
• Good knowledge of DevOps processes and continuous testing practices.
• Experience participating in sprint planning, backlog grooming, and release activities.

Test Management Tools

Hands-on Experience With

• Jira
• Confluence (preferred)

Requirement Analysis

• Strong experience in requirement analysis and ambiguity identification.
• Ability to review business requirements and provide early feedback for quality improvements.
• Experience preparing test estimations and risk assessments.

Test Data Management

• Strong experience in identifying, creating, and maintaining test data.
• Ability to prepare mock data sets as required for testing scenarios.
• Experience handling large volumes of data for validation activities.

Stakeholder Management

• Excellent customer-facing and stakeholder communication skills.
• Experience collaborating with business users and cross-functional teams.
• Ability to manage multiple priorities in a fast-paced environment.
• Strong analytical and problem-solving skills.

Soft Skills

• Excellent verbal and written communication skills.
• Strong analytical and critical thinking abilities.
• Detail-oriented with a focus on data accuracy and quality.
• Ability to work independently as well as within distributed teams.
• Strong collaboration and stakeholder management capabilities.
• Proactive approach towards identifying risks and quality improvements.

Skills: rest api,jira,json,xray,agile scrum,postman / swagger / soap ui,api testing (rest / soap),jmeter,sql,xml,soap ui,ci/cd,oauth2 / jwt,swagger,microservices,api automation (rest assured / karate / playwright)