Data QA Lead

Tata Consultancy Services; San Ramon (CA); On-site; USD 110,000 - 130,000; Full time

Job summary

A leading IT services company is seeking a highly experienced QA Lead in San Ramon, CA, with over 15 years in QA/testing, including 5 years focused on data integration testing. The role involves establishing QA processes for ETL pipelines, mentoring a QA team, and collaborating with various stakeholders. Must have expertise in Azure cloud services and a solid background in SQL. This is a full-time position with competitive compensation and opportunities for advancement.

Qualifications

• 15+ years of experience in QA/testing, focusing on data integration and ETL testing.
• 5+ years of experience testing Snowflake and Azure cloud services.
• Strong hands-on experience with SSIS and Azure Data Factory.

Responsibilities

• Establish and implement a formal QA program for data integration.
• Build and mentor a QA team to support enterprise data initiatives.
• Design, develop, and execute test plans for SSIS and ADF pipelines.

Skills

Data integration testing

QA automation

SQL validation

ETL workflows

Azure DevOps

Python

API testing

Tools

SSIS

Azure Data Factory

Snowflake

Job description

Tata Consultancy Services provided pay range

This range is provided by Tata Consultancy Services. Your actual pay will be based on your skills and experience — talk with your recruiter to learn more.

Base pay range

$110,000.00/yr - $130,000.00/yr

Direct message the job poster from Tata Consultancy Services

Technical Recruiter at Tata Consultancy Services

Job Description

1. We are seeking a highly experienced QA Lead with 10+ years in QA/testing and 5+ years of specialized experience in data integration testing. This role involves leading the design, development, testing, and optimization of QA processes for ETL pipelines using Azure Data Factory (ADF) and SSIS.

2. The position requires close collaboration with data engineers, Business analysts, and stakeholders to ensure data integrity, scalability, and compliance across enterprise data platforms. Deep expertise in data integration testing, SQL validation, and QA automation is essential. This role requires coordinating and working with onshore, offshore, and nearshore teams.

3. Note: Candidate should be local and work from one of our offices in San Francisco or San Ramon.

Key Responsibilities

• Establish and implement a formal QA program for data integration and ETL workflows.
• Build and mentor a QA team to support enterprise data initiatives.
• Design, develop, and execute test plans for SSIS and ADF pipelines, validating data transformations and load accuracy.
• Define and implement QA automation frameworks for data validation and regression testing.
• Optimize data validation scripts for performance and accuracy.
• Collaborate with data engineers and developers to align QA efforts with project goals.
• Validate data against business rules and regulatory requirements.
• Conduct performance and scalability testing for ETL jobs and data flows.
• Manage QA configurations and ensure best practices for data quality and governance.
• Support CI/CD workflows using Azure DevOps for automated testing and deployment.
• Create technical documentation and knowledge transfer plans for operational teams.

Required Qualifications

• 15+ years of experience in QA/testing, with at least 5 years focused on data integration and ETL testing.
• 5+ years of experience testing Snowflake and Azure cloud services (ADF, ADLS, Function App, Batch etc.).
• Strong hands‑on experience with SSIS and Azure Data Factory (ADF).
• Proficiency in SQL (Snowflake & SQL Server) for data validation and query‑based testing; solid understanding of data warehousing concepts, data modeling, and data migration testing.
• Experience with Azure DevOps for CI/CD pipelines and test automation.
• Familiarity with investment management domain.
• Proficiency in Python for automation and experience with Playwright or similar automation tools.
• Exposure to API testing for data services is preferred.
• Strong understanding of data governance and compliance frameworks.
• Excellent communication and leadership skills for cross‑functional collaboration.

Seniority Level

Associate

Employment Type

Full-time

Job Function

Quality Assurance

Industries

IT Services and IT Consulting