The ideal candidate will be responsible for validating end-to-end data pipelines, ensuring data quality, integrity, and accuracy across source systems, ETL processes, and target data warehouses.

The role requires hands-on experience in SQL, ETL testing methodologies, cloud-based data platforms, and automation testing frameworks.

Responsibilities :

- Perform end-to-end ETL/Data Warehouse testing for large-scale data migration and integration projects.

- Validate data extraction, transformation, and loading processes from multiple source systems.

- Develop and execute test cases, test scenarios, and test scripts for ETL workflows.

- Perform source-to-target data validation and reconciliation.

- Validate data quality, completeness, consistency, and accuracy across systems.

- Conduct database testing using complex SQL queries.

- Test Snowflake data warehouse objects including tables, views, stages, streams, and tasks.

- Validate data pipelines built on AWS services.

- Analyze ETL mappings, transformation logic, and business rules.

- Identify, document, and track defects through resolution.

- Collaborate with Data Engineers, Business Analysts, Developers, and Product Owners.

- Participate in Agile ceremonies and provide testing estimates and status updates.

- Support automation initiatives for ETL and data validation testing.

Requirements :

- 6-9 years of ETL Testing experience.

Mandatory Skills :

- ETL and Data Warehouse Testing: Data Warehouse Testing, Data Migration Testing, Data Validation and Reconciliation, Source-to-Target Validation, Data Quality Testing, Defect Management.

- Database and SQL: Advanced SQL, Query Optimization, Data Analysis, Database Testing.

- Snowflake: Snowflake Data Warehouse, Snowflake Tables and Views, Streams and Tasks, Snowflake Data Validation, and Data Loading and Transformation Validation.

- AWS Cloud: AWS S3, AWS Glue, AWS Lambda, AWS Redshift, AWS EMR, AWS Athena, Cloud Data Validation.

- Testing Tools: Jira, Azure DevOps, HP ALM / Quality Center, Test Management Tools.