QA Automation Lead

Job Role: QA Automation Lead

Location: San Ramon, CA

Job Description:

1. 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.
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.
4. Key Responsibilities
5. Establish and implement a formal QA program for data integration and ETL workflows.
6. Build and mentor a QA team to support enterprise data initiatives.
7. Design, develop, and execute test plans for SSIS and ADF pipelines, validating data transformations and load accuracy.
8. Define and implement QA automation frameworks for data validation and regression testing.
9. Optimize data validation scripts for performance and accuracy.
10. Collaborate with data engineers and developers to align QA efforts with project goals.
11. Validate data against business rules and regulatory requirements.
12. Conduct performance and scalability testing for ETL jobs and data flows.
13. Manage QA configurations and ensure best practices for data quality and governance.
14. Support CI/CD workflows using Azure DevOps for automated testing and deployment.
15. Create technical documentation and knowledge transfer plans for operational teams.
16. Required Qualifications
17. 15+ years of experience in QA/testing, with at least 5 years focused on data integration and ETL testing.
18. 5+ years of experience testing Snowflake and Azure cloud services (ADF, ADLS, Function App, Batch etc.).
19. Strong hands-on experience with SSIS and Azure Data Factory (ADF).
20. 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.
21. Experience with Azure DevOps for CI/CD pipelines and test automation.
22. Familiarity with investment management domain.
23. Proficiency in Python for automation and experience with Playwright or similar automation tools
24. Exposure to API testing for data services is preferred.
25. Strong understanding of data governance and compliance frameworks.
26. Excellent communication and leadership skills for cross-functional collaboration.