ETL Test Lead

Aarushi Infotech; Hyderabad; On-site; INR 1,500,000 - 1,900,000; Full time

Job summary

Aarushi Infotech in Hyderabad seeks an experienced QA professional for data warehouse and ETL testing. You will validate BI reporting, write complex SQL queries, and ensure data quality across ETL processes.

Role requires 8–12 years of hands-on testing experience, STM validation, Unix/Linux familiarity, and collaboration with cross-functional teams in an Agile environment.

Qualifications

• 8–12 years of hands-on software testing/QA experience.
• Extensive Data Warehouse and ETL testing expertise.
• BI applications exposure and reporting validation.
• Strong SQL with complex queries, joins, subqueries, and validations.
• STM validation experience and ETL concepts knowledge.
• Data validation, reconciliation and quality checks.
• Unix/Linux command proficiency and relational DBs (Oracle, SQL Server, PostgreSQL, MySQL, Teradata).

Responsibilities

• Lead end-to-end Data Warehouse and ETL testing efforts.
• Design and execute test plans, cases, and data validation scripts.
• Validate BI reports and ensure data quality across layers.
• Collaborate with cross-functional teams and stakeholders.
• Participate in Agile/Scrum processes and DevOps practices.

Skills

Software Testing

Data Warehouse

ETL Testing

SQL

STM Validation

BI Reporting

Unix/Linux

Relational Databases

Jira

Confluence

Agile Scrum

DevOps

Test Data Management

Stakeholder Management

API Testing

Swagger/OpenAPI

CI/CD

Tools

Informatica

DataStage

Talend

SSIS

Azure Data Factory

Job description

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)