ETL Testing Lead

Quantum Technologies. LLC

Irving (TX)

Sur place

USD 100 000 - 142 000

Plein temps

Il y a 1 heure
Soyez parmi les premiers à postuler

Une candidature complète en une minute

Un CV et une lettre de motivation personnalisés, prêts à envoyer.

Passez les filtres ATS

Résumé du poste

Quantum Technologies. LLC is seeking an experienced ETL Testing Lead for a 12-month engagement in Irving, TX. The role focuses on test planning, end-to-end ETL validation, and MDM quality assurance across Informatica, Databricks, and large data pipelines.

You will lead a cross-functional QA team, design comprehensive test strategies, write complex SQL/Spark queries, and drive defects to resolution with data engineers and business analysts, ensuring data accuracy and pipeline reliability.

Qualifications

  • Engineering degree or equivalent engineering qualification.
  • Technical certification in multiple technologies is desirable.

Responsabilités

  • Test Planning & Execution: analyse business requirements, source-to-target mapping and data models to design test plans, scenarios and cases.
  • ETL & Pipeline Validation: validate batch and incremental ETL jobs built in Informatica and Databricks; verify data extraction, transformation rules and target loading.
  • MDM Quality Assurance: validate MDM workflows, data cleansing, match/merge thresholds and golden record accuracy across source systems.
  • SQL & Root-Cause Analysis: write complex SQL and Spark SQL queries to detect data anomalies, duplicates and referential integrity issues; drive defects to resolution with data engineers.
  • Regression & Reporting: maintain reusable test data sets, execute regression suites for pipeline releases and provide test metrics and sign-off reports to stakeholders.

Connaissances

Lead ETL QA
Data Warehouse Testing
MDM Validation
Big Data Verification
Automated Data Testing
Advanced SQL
Informatica Testing
Databricks
Lakehouse Verification
MDM Testing
QA Methodology
Defect Tracking
Test Automation
Cloud Data Platforms
CI/CD Integration
Communication & Alignment

Formation

Engineering Degree – BE/ME/BTech/MTech/BSc/MSc

Outils

Informatica
Databricks
SQL
Spark SQL
PySpark
Azure Data Services
Azure Synapse
IICS
Jira
Zephyr
Azure DevOps

Description du poste

US Citizen, Green Card, H-1B, OPT-EAD, CPT, Other

Job Title: ETL Testing Lead
Location: Irving, TX
Duration: 12 Months + Extension
Bill Rate: $88/hour
Job Type: W-2, 1099, C2C
Client: To Be Discussed Later
Work Authorization: US-Citizen, H-1B, OPT-EAD, GC-EAD
Job Description

Test Planning & Execution: Analyse business requirements, source-to-target mapping documents, and data models to design thorough test plans, test scenarios, and test cases.

  • ETL & Pipeline Validation: Execute end-to-end validation of batch and incremental ETL jobs built in Informatica and Databricks, verifying data extraction, transformation rules, and target loading.
  • MDM Quality Assurance: Validate MDM workflows, including data cleansing, standardization, match/merge thresholds, and golden record accuracy across source systems.
  • SQL & Root-Cause Analysis: Write complex SQL and Spark SQL queries to detect data anomalies, duplicates, truncation, and referential integrity issues, driving defects to resolution with data engineers.
  • Regression & Reporting: Maintain reusable test data sets, execute regression suites for pipeline releases, and provide clear test execution metrics and sign-off reports to stakeholders
Educational Qualifications

Engineering Degree – BE/ME/BTech/MTech/BSc/MSc.

Technical certification in multiple technologies is desirable.

Mandatory skills
  • Lead team and coordinate difference stakeholder for ETL QA
  • Data Warehouse Testing, Master Data Management (MDM) Validation, Big Data Verification, and Automated Data Testing (SQL, Informatica, Databricks).
  • Advanced SQL & Data Validation: Expert-level SQL skills to write complex queries for source-to-target data validation, data completeness, transformation logic, and reconciliation.
  • Informatica Testing: Hands-on experience testing, validating, and troubleshooting ETL workflows, mappings, and sessions in Informatica PowerCenter or Informatica Intelligent Cloud Services (IICS).
  • Databricks & Lakehouse Verification: Practical experience querying and validating large datasets in Databricks using Spark SQL, PySpark, and Delta Lake tables.
  • Master Data Management (MDM) Testing: Proven experience testing MDM hubs, validating match/merge rules, survivorship logic, golden record creation, and downstream data distribution.
  • QA Methodology & Defect Tracking: Strong understanding of SDLC/STLC, test plan creation, test case execution, and defect lifecycle management using tools like Jira, Zephyr, or Azure DevOps.
Preferred Skills
  • Test Automation: Experience automating ETL and data validation tests using Python, PyTest, Great Expectations, or commercial data testing tools.
  • Cloud Data Platforms: Familiarity with cloud storage and data warehousing ecosystems such as Azure (ADLS, Synapse), AWS (S3, Redshift), or Snowflake.
  • CI/CD Integration: Experience integrating automated data regression suites into CI/CD pipelines (Azure DevOps, Jenkins, or GitHub Actions).
  • Communication & Alignment: Strong analytical and communication skills to collaborate effectively with data engineers, business analysts, and product stakeholders across distributed teams.
  • We are looking for a detail-oriented ETL Tester to ensure the accuracy, integrity, and reliability of our enterprise data pipelines and Master Data Management (MDM) solutions.

We are an equal opportunity employer. All aspects of employment including the decision to hire, promote, discipline, or discharge, will be based on merit, competence, performance, and business needs. We do not discriminate on the basis of race, color, religion, marital status, age, national origin, ancestry, physical or mental disability, medical condition, pregnancy, genetic information, gender, sexual orientation, gender identity or expression, national origin, citizenship/ immigration status, veteran status, or any other status protected under federal, state, or local law.

Obtenez votre examen gratuit et confidentiel de votre CV.

ou faites glisser et déposez votre fichier ici.

Similar jobs

Postes similaires à comparer

ETL Testing Lead
ETL Testing Lead

Valiant Technologies LLC • Irving (TX)

Sur place
USD 96 000 - 152 000
ETL Testing Lead
ETL Testing Lead

Ethereum Technologies • Irving (TX)

Sur place
USD 103 000 - 139 000
Senior ETL Tester
Senior ETL Tester

Valiant Technologies LLC • Irving (TX)

Sur place
USD 83 000 - 118 000
ETL Tester Azure
ETL Tester Azure

Quantum Technologies LLC • Irving (TX)

Sur place
USD 77 000 - 110 000
ETL Tester Azure
ETL Tester Azure

Robotics Technologies LLC • Irving (TX)

Sur place
USD 90 000 - 150 000
ETL Tester Azure
ETL Tester Azure

Valiant Technologies LLC • Irving (TX)

Sur place
USD 90 000 - 130 000
ETL Tester Azure
ETL Tester Azure

Ethereum Technologies LLC • Irving (TX)

Sur place
USD 110 000 - 140 000
ETL Tester Azure
ETL Tester Azure

Robotic Process Automation LLC • Irving (TX)

Sur place
USD 110 000 - 150 000
Senior ETL Tester
Senior ETL Tester

Ethereum Technologies LLC • Boston (MA)

Sur place
USD 90 000 - 120 000
Senior ETL Tester
Senior ETL Tester

Valiant Technologies LLC • Boston (MA)

Sur place
USD 86 000 - 123 000