ETL QA with Talend and Snowflake

Job Title: ETL QA with Talend and snowflake

Job Type: Remote

Experience: 8+ years

Location- USA

Overview

The ETL QA position focuses on ensuring the quality and integrity of data during the extraction, transformation, and loading (ETL) process utilizing Talend and Snowflake technologies. As data continues to play a pivotal role in decision-making across organizations, the importance of thorough QA practices becomes critical. The ETL QA will collaborate closely with data engineers and developers to establish robust testing frameworks, validate data transformations, and ensure that data processed through Talend pipelines is accurately loaded into Snowflake. The successful candidate will possess cutting-edge technology skills and a keen eye for detail, ensuring that the end product meets both quality standards and organizational goals. This role is vital for maintaining data reliability and performance, which ultimately improves overall operational efficiency and supports strategic initiatives.

Key Responsibilities
• Design and implement ETL testing strategies for Talend and Snowflake environments.
• Develop test plans and test cases focused on validating data integrity and transformation processes.
• Execute automated and manual test scripts to validate ETL processes.
• Collaborate with data engineers to identify and diagnose data quality issues.
• Participate in code reviews to assess code quality and adherence to best practices.
• Utilize SQL to perform data analysis and validation post-ETL processes.
• Document testing processes, including test plans, test cases, and results.
• Track defects and issues found during testing and work with development teams to resolve them.
• Perform regression testing to confirm the sustainability of existing functionalities.
• Monitor ETL performance and optimize testing procedures for efficiency.
• Ensure compliance with data governance and privacy policies.
• Provide feedback on project requirements and functional specifications.
• Conduct root cause analysis for data discrepancies and present findings.
• Participate in the planning and execution of user acceptance testing (UAT).
• Actively contribute to continuous improvement initiatives to enhance QA processes.

Required Qualifications
• Hands-on experience with Snowflake cloud data warehousing.
• Strong proficiency in SQL and database technologies.
• Experience in developing and executing automated test cases.
• Familiarity with data modeling principles and data warehousing concepts.
• Understanding of Agile methodologies and project management practices.
• Ability to work collaboratively within cross-functional teams.
• Excellent verbal and written communication skills.
• Detail-oriented with strong analytical and problem-solving abilities.
• Prior experience with version control systems such as Git.
• Knowledge of data visualization tools is a plus.
• Certifications in Talend or other ETL tools are advantageous.
• Ability to handle multiple tasks and meet deadlines effectively.
• Willingness to learn new technologies and tools as required.
• Experience with cloud-based data integration solutions.

Skills: talend,problem solving,etl testing,data analysis,agile methodologies,sql,version control,automated testing,data validation,snowflake,data modeling,analytical thinking,sql proficiency,etl,version control (git),data quality assessment