ETL Test Lead
Zishan ShaikhUnited StatesSENIORPosted 45m ago
ETL TestingData Migration TestingData WarehouseSQLDatabricksInformaticaMaster Data ManagementAzure Data FactorySynapseKafkaPythonPyTestGreat Expectations
About the Role
We are looking for a seasoned ETL Test Lead to lead end-to-end data pipeline, Data Warehouse, and MDM testing for an enterprise-scale analytics delivery in Irving, TX.
Key Responsibilities
• Lead ETL QA efforts and coordinate with onshore/offshore teams and business stakeholders
• Perform end-to-end validation of batch and incremental ETL pipelines built in Informatica (PowerCenter/IICS) and Databricks
• Validate MDM workflows including data cleansing, match/merge rules, survivorship logic, and golden record accuracy
• Write complex SQL and Spark SQL / PySpark queries for source-to-target data reconciliation, completeness, and root-cause analysis
• Design test plans, manage regression suites, and track defects using Jira or Azure DevOps
Requirements
• 10+ years of hands-on experience in ETL Testing, Data Migration Testing, and Data Warehouse (DWH) validation
• Strong expertise in Advanced SQL, Databricks (Delta Lake, Spark SQL, PySpark), and Informatica
• Proven experience in Master Data Management (MDM) Testing
• Hands-on familiarity with Azure Data Factory (ADF), Synapse, and Kafka
• Local candidates only (currently residing in Irving / DFW, TX metroplex)
• Work authorization: C2C for H1B candidates only (and USC/GC if applicable on W2)
• Not open for OPT candidates