ETL Specialist

Role :- ETL Tester

Location:- Philadelphia, PA

Immediate hire role

Please submit suitable resume to

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.