Senior ETL Quality Analyst - Data Integrity (8-12 yrs)

About the Role :

We are seeking a highly skilled and detail-oriented Senior ETL QA to ensure the integrity, performance, and security of our data processes. This role involves comprehensive ETL testing, performance testing, automation, and adherence to regulatory compliance standards.

The ideal candidate will bring expertise in Snowflake optimization, Talend, SQL, Python, and data masking techniques, driving quality assurance for critical data pipelines.

Key Responsibilities :

ETL Testing and Validation :

- Design, develop, and execute comprehensive ETL testing strategies and test plans.

- Validate the accuracy and integrity of ETL data flows, ensuring end-to-end coverage.

- Perform data mapping, transformations, and reconciliation validation for Talend and Snowflake pipelines.

Performance Testing :

- Conduct performance testing to evaluate the efficiency of data workflows and systems.

- Optimize Snowflake queries, pipelines, and workloads for peak performance.

- Identify and address performance bottlenecks in ETL processes.

Automation and Tool Development :

- Implement and maintain automation scripts for testing workflows using Python or other scripting languages.

- Create reusable test automation frameworks and data validation tools.

Data Masking and Security :

- Enforce data masking techniques to protect sensitive and confidential information.

- Ensure compliance with data protection and privacy regulations (i.e., GDPR, HIPAA).

Documentation and Reporting :

- Prepare detailed test plans, test cases, and defect reports with clear documentation.

- Communicate test results and quality metrics to stakeholders effectively.

Collaboration :

- Work closely with developers, data engineers, and product teams to align on data quality objectives.

- Participate in agile ceremonies, contributing to continuous improvement initiatives.

Regulatory Compliance :

- Ensure data pipelines comply with relevant regulatory standards and best practices.

- Identify risks and implement measures to address compliance-related challenges.

Must-Have Skills :

- Comprehensive ETL Testing : Strong expertise in validating complex ETL workflows and ensuring end-to-end data integrity.

- Performance Testing : Proven experience in assessing and optimizing ETL and database performance.

- Data Masking : In-depth knowledge of techniques to secure sensitive data during testing.

- SQL Proficiency : Advanced SQL skills for data analysis, validation, and troubleshooting.

- Snowflake Expertise : Deep understanding of Snowflake architecture, performance tuning, and optimization.

- Automation : Hands-on experience with test automation using Python or similar tools.

- Talend : Solid understanding of Talend for ETL processes and data integration.

- Documentation Skills : Ability to create clear and concise test plans, defect reports, and other quality assurance documentation.

- Regulatory Compliance : Awareness of industry standards and regulatory frameworks for data protection and compliance.

Preferred Qualifications :

- Familiarity with CI/CD pipelines and DevOps practices.

- Experience with cloud platforms (AWS, Azure, or GCP).

- Knowledge of other ETL tools and frameworks beyond Talend.

- Certification in Snowflake, SQL, or related technologies.

- Experience in agile methodologies and tools such as Jira, Confluence, etc

- -