QA Lead ETL / Data

Tanisha Systems Inc
Santa Clara, United States
3 months ago
Apply on dice.com
Prepare application

Role details

Contract type
Permanent contract
Employment type
Full-time (> 32 hours)
Experience level
Expert
Experience required
5 years minimum
Working hours
Regular working hours
Job source

Tech stack

Testing (Software) Artificial Intelligence Automation of Tests Microsoft Azure Code Coverage Databases Data Validation Information Engineering Data Infrastructure Extract Transform Load (ETL) Data Transformation Data Warehousing
+14 more
Database Testing Operational Databases Scrum Methodology Regression Testing Power BI Standard Sql Software Deployment Data Streaming Scripting Data Ingestion Microsoft Fabric Integration Tests SQL Server Management Studio (SSMS) Data Pipelines

Job description

We are looking for a QA Lead who is proficient in ETL/ Data testing to join our dynamic team who are at the forefront of enabling enterprises in Retail sectors. This engagement is the foundation of claims modernization program, delivering a Microsoft Fabric-based claims data platform and eligibility workflow application for five priority TPAs. The solution will standardize claims and eligibility data from multiple file formats and intake channels, automate manual validation processes, and provide curated Gold-layer data for claim creation, reporting, analytics, and future AI/ML initiatives. Phase 1 serves as the production foundation for scaling across broader network of 250+ TPAs. The quality, accuracy, and scalability of the data platform, ingestion pipelines, and eligibility workflows established in this phase will directly impact future onboarding, operational efficiency, and business-critical claims processing across the enterprise. Effectively Communicate and collaborate with internal teams and customer and aligning to standard coding principles and guidelines., * Lead a strategic claims modernization initiative: Help establish the quality foundation for this Microsoft Fabric-based claims platform, supporting 50,000+ annual claims and laying the groundwork for onboarding 250+ TPAs; Work with AI-powered accelerators at scale: Leverage WinWire’’s WinAIDM - Data Ingestion Agent for automated source onboarding, schema detection, metadata extraction, and compliance tagging, significantly accelerating TPA integration

  • Drive intelligent data quality engineering: Utilize WinAIDM - Data Quality Agent to automate validation rule generation, data reconciliation, and quality checks, enabling faster and more reliable testing outcomes; Accelerate transformation delivery: Gain exposure to WinAIDM - Data Transformation Agent and WinAIDM - Data Consumption/Reporter Agent, supporting streamlined data engineering, reporting, and analytics delivery across the modernization lifecycle
  • Build the foundation for AI-driven claims operations: Ensure trusted Gold-layer data that powers claim creation, eligibility verification, reporting, analytics, and future AI/ML initiatives; Create enterprise-wide impact: The quality standards, testing framework, and governance processes established in Phase 1 will serve as the blueprint for scaling the platform across the broader TPA ecosystem and future modernization phases

Expected Outcome / What Success Looks Like - Successfully validate end-to-end claims and eligibility data pipelines across all five Phase 1 TPAs. Establish a robust QA framework covering data ingestion, transformation, Gold-layer validation, and eligibility workflow testing. Achieve high confidence in data quality through automated reconciliation, source-to-target validation, and regression testing. Support successful UAT execution and production deployment with minimal critical defects. Implement repeatable QA processes, test assets, and quality metrics that can scale to onboard additional TPAs in future phases. Phase 1 solution successfully deployed with QA sign-off and business acceptance. 95%+ test coverage across critical claims and eligibility workflows. Automated data validation and reconciliation processes established. Reduction in production data quality issues and post-release defects. Trusted, accurate Gold-layer datasets available for downstream consumption and analytics.

Requirements

  • 6+ years of experience in Data warehouse testing, ETL/DB testing and designing test plan/ strategy, and test cases
  • 5+ years of experience in leading Quality Assurance teams (Minimum of 5+ team members) and customer interaction experience
  • Strong experience in Fabric and Azure related testing experience like validating ADLS files, ADF Pipelines, Logic App, SSMS, performing aggregate checks along with source Vs target counts and data reconciliation
  • 5 years of experience in writing complex SQL (t-SQL) queries and execute Stored Procs, Functions to test them
  • Experience in integration testing, unit, functional and automation testing
  • Should have Fabric and Azure related testing experience like validating ADLS files, ADF Pipelines, Logic App, SSMS, performing aggregate checks along with source Vs target counts and data reconciliation
  • Should have strong experience testing Database centric application that involves complex data flows and transformations
  • Experience in preparing quality reports and customer interaction
  • Strong interpersonal skills to build and maintain productive relationships with team members
  • Prior experience in working on Agile/Scrum projects with exposure to tools like Jira/Azure DevOps
  • Provides regular updates, proactive and due diligent to carry out responsibilities
  • Secondary Skills / Good to have - Good at Power BI testing; Experience with Python scripting for data validation; Certification in software testing or quality assurance

Apply for this position

This job is hosted externally. Click below to view the full posting and apply.

Apply on dice.com
Prepare application

Good distractions

Talks and stories from around this role — technically off-topic, practically not.

2:06 min

Elevating the QA engineering role for complex challenges

Ondřej Gróf Ondřej Gróf · World Congress 2026 Europe

1:04 min

Introduction to Bitcoin script parsing tools

Steve Shadders · LIVE

3:04 min

Database evolution and the funding behind vector databases

Erik Bamberg · LIVE

1:24 min

Moving the semantic layer upstream to avoid vendor lock-in

Piotr Menclewicz Piotr Menclewicz · Europe 2026 Virtual

6:08 min

Applying software engineering environments and testing to data pipelines

Matthias Niehoff Matthias Niehoff · World Congress 2024

1:53 min

Evaluating traditional scripting languages for modern development tasks

Jens Knipper Jens Knipper · Europe 2026 Virtual

Videos

See all

Related articles

See all