ETL Testing Lead: Data Quality & MDM Expert

Robotic Process Automation LLC

Irving (TX)

On-site

USD 102,000 - 139,000

Full time

43 hours ago
Be an early applicant

Get a reply from this recruiter

Your resume and cover letter, tailored to exactly what they’re hiring for.

Get past ATS filters

Job summary

Robotic Technologies Automation LLC is seeking an ETL Testing Lead in Irving, TX to design and execute comprehensive validation of complex ETL pipelines and MDM workflows. You will lead a QA team, coordinate with data engineers, and ensure data quality across batch and streaming processes.

The role focuses on Informatica and Databricks testing, advanced SQL validation, and integration with Jira/Azure DevOps for defect tracking and release sign-off.

Qualifications

  • Engineering Degree – BE/ME/BTech/MTech/BSc/MSc.
  • Technical certification in multiple technologies is desirable.

Responsibilities

  • 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

Skills

Lead ETL QA
Data Warehouse Testing
MDM Validation
SQL & Spark SQL
Informatica Testing
Databricks
MDM Testing
Jira/Azure DevOps

Education

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

Tools

Informatica PowerCenter
Informatica IICS

Job description

Robotic Technologies Automation LLC is seeking an ETL Testing Lead in Irving, TX to design and execute comprehensive validation of complex ETL pipelines and MDM workflows. You will lead a QA team, coordinate with data engineers, and ensure data quality across batch and streaming processes.

The role focuses on Informatica and Databricks testing, advanced SQL validation, and integration with Jira/Azure DevOps for defect tracking and release sign-off.

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

ETL Testing Lead - Data Quality & MDM (SQL, Databricks)
ETL Testing Lead - Data Quality & MDM (SQL, Databricks)

Robotics Technologies • Irving (TX)

On-site
USD 100,000 - 142,000
Senior ETL Tester | Data Quality & Databricks Expert
Senior ETL Tester | Data Quality & Databricks Expert

Robotic Process Automation LLC • Irving (TX)

On-site
USD 85,000 - 116,000
ETL Testing Lead — Data Quality & MDM Champion
ETL Testing Lead — Data Quality & MDM Champion

CloudBigD • Irving (TX)

On-site
USD 96,000 - 152,000
ETL QA Lead — Data Warehouse & MDM Expert
ETL QA Lead — Data Warehouse & MDM Expert

Quantum Technologies LLC • Irving (TX)

On-site
USD 100,000 - 142,000
Senior ETL Tester - Azure & Databricks Data Quality
Senior ETL Tester - Azure & Databricks Data Quality

Robotics Technologies LLC • Irving (TX)

On-site
USD 90,000 - 150,000
Senior ETL Tester: Azure & Databricks Data Validation
Senior ETL Tester: Azure & Databricks Data Validation

Robotic Process Automation LLC • Irving (TX)

On-site
USD 110,000 - 150,000
Senior ETL QA Lead – Data Warehouse & MDM
Senior ETL QA Lead – Data Warehouse & MDM

Ethereum Technologies LLC • Irving (TX)

On-site
USD 103,000 - 139,000
Senior Data Engineer & ETL Technical Lead
Senior Data Engineer & ETL Technical Lead

Robotic Process Automation LLC • Rhode Island

On-site
USD 96,000 - 165,000
ETL Automation Lead — Ab Initio & Big Data QA
ETL Automation Lead — Ab Initio & Big Data QA

Robotic Technologies Automation • Tampa (FL)

On-site
USD 95,000 - 136,000
Senior ETL & Data Quality Engineer (Python/PySpark)
Senior ETL & Data Quality Engineer (Python/PySpark)

Robotic Process Automation LLC • Boston (MA)

On-site
USD 86,000 - 123,000