ETL Specialist Job at Comtech Global, Inc, Philadelphia, PA

b0NrYWJYY3k0bDVrNkcrY2s3WWNUR2pyMlE9PQ==
  • Comtech Global, Inc
  • Philadelphia, PA

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

Immediate start,

Similar Jobs

Solution Community

Director of Grants Writing & Foundation Relations - Volunteer Job at Solution Community

 ...community of compassion, uniting individuals and organizations to solve the world's social problems. We are the bridge that connects non-profits, businesses, philanthropists, and volunteers, empowering them to create meaningful change for current and future generations. _... 

Stanley Cowton International

Quality Assurance Specialist Job at Stanley Cowton International

&##127775; Now Hiring: Quality Specialist Advanced Pharmaceutical Manufacturing | Hopewell, VA Were supporting a pioneering pharmaceutical manufacturer on a mission to transform how critical medicines are made in the U.S. As they scale operations and technology... 

Tutor Me Education

Online Tutor Job at Tutor Me Education

 ...Job Description Job Description Tutor Me Education is reshaping how students learn. We are looking for tutors and teachers provide 1:1 or group instruction to students all across the country! Here are the details: Virtual instruction from your home computer,... 

Wilson's NAPA Auto Parts

Automotive Parts Counter Sales / Heavy Duty Store Job at Wilson's NAPA Auto Parts

 ...Description: Job Title: Heavy Duty Automotive Parts Sales Associate Our company is seeking a highly motivated and customer-oriented individual to join our team as an Automotive Parts Heavy Duty Associate. In this role, you will be responsible for providing exceptional... 

PMI - San Francisco Bay Area Chapter

Outreach Coordinator for Sponsor (Unpaid Volunteer) Job at PMI - San Francisco Bay Area Chapter

The Volunteer Outreach Coordinator plays a pivotal role in expanding and nurturing relationships with both potential and existing sponsors, ensuring their needs are met and aligning PMI San Francisco's offerings with their expectations.Key Responsibilities:Sponsor Engagement...