Role :- ETL Tester
Location:- Philadelphia, PA
Immediate hire role
Please submit suitable resume to (see below)
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 withMatillion ETL is highly preferred. Experience with other cloud-native ETL tools (eg, 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 (eg, 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.