QA Automation

Job title: QA Automation (Mandate to have- Azure Data Factory (ADF) SSIS, SQL, ETL and data integration

Job Location: San Ramon, CA - Onsite

Job Type: Fulltime

Job Description:

• We are seeking a highly experienced QA Lead with 15+ 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.
• 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.
• 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