Job Description

Role :- ETL Tester

Location:- Philadelphia, PA

Immediate hire role

Please submit suitable resume to soe@comtechglobal.com

Ideally we would love someone with strong ETL testing with Data Vault and Matillion experience – if we can’t find that – they are open to a strong ETL/Data QA that has extensive Snowflake experience

We are seeking a highly skilled and detail-oriented QA Engineer with a strong background in data warehousing, ETL testing, data integration, and data quality to ensure the successful migration of Salesforce CRM data into a Snowflake-based Data Vault. The ideal candidate will have strong experience in data validation, ETL pipeline testing, and performance optimization, working with Matillion and Snowflake stored procedures.

Key Responsibilities

• Review and understand business requirements, data models, and source-to-target mappings for integrating Salesforce data into the Data Vault.
• Analyze existing Snowflake-based Data Vault models, including hubs, satellites, and links, and validate modifications for business key adoption.
• Design, review, and execute test cases for Snowflake objects such as tables (hubs/links/satellites), views, and stored procedures.
• Perform data quality checks and reconciliation within Snowflake to ensure loaded data matches Salesforce source records and business rules.
• Monitor, analyze, and troubleshoot Snowflake query performance, warehouse sizing, and scaling during ETL testing.
• Design and maintain comprehensive test plans and cases for new and modified Data Vault structures and ETL workflows (Matillion, Snowflake Stored Procedures).
• Develop automated and manual test scripts for unit, integration, regression, and performance testing of ETL pipelines.
• Perform detailed data quality assessments and reconciliation between Salesforce and the Data Vault, identifying and documenting data discrepancies.
• Test ETL process error handling, logging, and auditing mechanisms.
• Support user acceptance testing (UAT) and help document and communicate findings to stakeholders.
• Contribute to ongoing process improvements and best practices in data integration QA and automation.

Requirements:

• 5+ years of experience as a QA Engineer with a strong focus on data warehousing, ETL, and data quality.
• Proven experience with Snowflake (schemas, working with SQL, stored procedures, SQL performance analysis & troubleshooting).
• Hands-on experience with Matillion ETL is highly preferred. Experience with other cloud-native ETL tools (e.g., Fivetran, DBT) is a plus.
• Solid knowledge of Data Vault concepts (hubs, satellites, links, business keys, load dates, record source) and best practices.
• Experience with data profiling tools and techniques.
• Familiarity with testing methodologies (e.g., Agile, Waterfall) and testing tools.

Nice-to-Have:

• Snowflake certifications.
• Experience with cloud platforms (AWS, Azure, GCP).
• Familiarity with CI/CD pipelines in a data context.
• Experience with automated data testing frameworks.

Job Tags

Similar Jobs