Sr. ETL QA

Job Title: Senior ETL QA

Experience: 8-12 yrs

Must Have Skills: Performance Testing, snowflake, Automation, Comprehensive ETL Testing, Documentation Skills, Talend, Regulatory Compliance, Data Masking, sql, Python

Primary Skillsets:

• Comprehensive ETL Testing
• Performance Testing
• Data Masking
• SQL
• Snowflake

Responsibilities:

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.

• 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.
• Strong Hands on, experience in SQL.
• Good to have testing experience ETL build using DBT, Pyspark, Glue, Lambda.

sudhanshu.mishra@truelancer.com