
ETL Testing Lead / Sr. Tester
People Force Consulting · Texas · United States
Weak hiring record · median 158 days open
- First seen
- 17 November 2026
- Reposted
- Not since September 2026
- Last checked
- Today · still on the employer's board
All reasons
- 71% of this employer's openings are over 60 days old
In its favour
- Posted 3 days ago
- Still listed on the employer's own board
Seeking for ETL Testing Lead / Sr. Tester with 10+ years of experience in end-to-end data pipeline testing, specializing in Azure Data Factory (ADF), Synapse, Databricks, Kafka, ETL/Data Warehouse validation, data migration testing, and leading offshore QA teams to ensure data quality, integrity, and successful enterprise-scale analytics delivery.
Skills
ETL Testing, Data Migration Testing, MDM Testing, SQL, Automated Data Testing.
Experience
-10+ Years
Location
- Irving, TX (Hybrid – 3 days' Work from Office)
Duration: - 6 month Contract
Roles and 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.
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.
Skills
- · Data Warehouse Testing
- Master Data Management (MDM) Validation
- Big Data Verification
More jobs at People Force Consulting
All 261- Sr DotNet Fullstack Developer with AIPeople Force Consulting · Remote2d ago
- Snowflake AdministratorPeople Force Consulting · Remote3d ago
- Senior QA Automation with Playwright Automation (UI & API testing) and Python ScriptingPeople Force Consulting · Irving, TX, United States3d ago
- Java Developer (EDIFECS, EDI & SQL)People Force Consulting · Remote7d ago
- Data Product ManagerPeople Force Consulting · Bismarck, ND, Boise, ID, Burlington, IA, Fargo, ND, Grand Forks, ND, Lewiston, ME, Minot, ND, Portland, OR, Renton, WA, Spokane, WA, Salt Lake City, UT, Vancouver, WA, United States7d ago
Similar roles
- Data Analyst, Business AnalyticsEurasia Group · São Paulo, Brazil · Washington, DC · New York, NY +1 · USD 90,000–110,000/yrtoday
- Data Engineer / Data ArchitectSidram Technologies · Irvine, CA, CA, United Statestoday
- Content Metadata / Data AnalystSidram Technologies · Mettawa, IL, United Statestoday
- Sr. Data ArchitectApetan Consulting · Washingtonville, PA, United Statestoday
- Senior Enterprise Data Architect – Cloud & DatabaseApetan Consulting · Raymond, OH, United Statestoday
- Senior Analytics EngineerTwilio · US · USD 141,520–176,900/yrtoday