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

Surety Title Company

Title Production Associate Job at Surety Title Company

 ...Job Title: Title Production Associate Alternative Job Titles: Commitment Typist, Policy Typist FLSA Status: Non-Exempt...  ...documents. Updates file and all necessary documents according to Company policy and procedures, communicating with internal teams... 

Ceribell, Inc

Senior Sales Compensation Analyst Job at Ceribell, Inc

Job Description Job Description About Ceribell Ceribell is a medical technology company focused on transforming the diagnosis and management of patients with serious neurological conditions. The Ceribell System is a novel, point-of-care electroencephalography ...

Good Samaritan

Nursing Home Administrator - Long Term Care Job at Good Samaritan

 ...work in business and human resources. Location will determine experience required. The ability to be a licensed as a Nursing Home Administrator in the state of practice is required. Other licenses as appropriate by state requirements and facility needs.... 

Ajulia Executive Search

Quality Assurance Manager(Manufacturing) Job at Ajulia Executive Search

 ...Quality Assurance Manager Quality Manager that requires manufacturing ISO9001:2015 and/or AAR experience. Excellent work environment...  ...firm specializing in Manufacturing, Finance, IT, Legal and Pharmaceutical positions. This is a confidential search for one of our... 

Onward Search

Sign Language Interpreter [78243] Job at Onward Search

 ...Onward Search Education is actively seeking a dedicated Sign Language Interpreter for a contracted, on-site position supporting secondary school students in the Silverdale, Washington area for the 202526 school year. Position Details: Start Date: September...