Quality Assurance Engineer - ETL/Datawarehouse Testing (8-13 yrs)

We are seeking a highly skilled and detail-oriented Senior ETL QA with expertise in ETL Testing, Automation, Performance Testing, Data Masking, and strong documentation skills. The ideal candidate will play a key role in ensuring the integrity, performance, and security of our data processes while adhering to regulatory compliance standards. Design, develop, and execute comprehensive ETL testing strategies and test plans specific to Snowflake data pipelines.

Responsibilities :

- Create and maintain test cases to validate data extraction, transformation, and loading processes within Snowflake.

- Conduct end-to-end testing of ETL workflows to ensure data integrity and accuracy throughout the entire pipeline.

- Collaborate closely with data engineers, developers, and stakeholders to understand data requirements and business logic.

- Identify, document, and report defects or discrepancies in data transformations or loading processes.

- Develop and maintain automated test scripts and frameworks for ETL testing in Snowflake.

- Perform performance testing to evaluate the efficiency and scalability of Snowflake data pipelines.

- Troubleshoot issues and work with cross-functional teams to resolve data-related problems.

- Ensure compliance with data governance, security, and regulatory standards during testing processes.

- Document test results, findings, and recommendations for improvements in testing procedures.

Requirements :

- Strong Hands on, experience in SQL.

- Good to have testing experience in Ein TL build using DBT, Pyspark, Glue, and Lambda.

Skills And Expertise :

Primary Skillsets :

- ETL Testing

- Python Scripting

- SQL

- Snowflake

- Performance Testing

Good to Have :

- DBT

- Pyspark

- Glue

- Lambda