About the Role
Our client is seeking a Senior QA Automation Lead specializing in data integration and ETL testing responsible for leading enterprise QA programs, validating large-scale data pipelines, and ensuring data quality across Azure-based data platforms. (Hybrid- Toronto 3 days/wk)
Must Have Skills
15+ years of QA/testing experience with strong leadership experience
Strong experience in data integration and ETL testing (ADF and SSIS)
Advanced SQL skills (Snowflake and SQL Server) for data validation and query-based testing
Hands-on experience with Azure Data Factory (ADF), Azure cloud services, and Snowflake
Experience building QA automation frameworks using Python and Playwright
Experience with CI/CD pipelines and QA automation using Azure DevOps
Nice to Have Skills
Experience with API testing for data services
Familiarity with investment management or financial services domain
Experience with data warehousing, data modeling, and data migration testing
Understanding of data governance and compliance frameworks
Experience working with cross-shore teams (onshore, offshore, nearshore)
Strong technical documentation and knowledge transfer experience
Responsibilities
Establish and implement a formal QA program for enterprise data integration and ETL workflows
Lead and mentor a QA team supporting enterprise data initiatives
Design, develop, and execute comprehensive test plans for SSIS and Azure Data Factory pipelines
Validate data transformations, data loads, and pipeline accuracy across enterprise systems
Develop QA automation frameworks for data validation and regression testing
Optimize SQL-based data validation scripts for performance and scalability
Collaborate with data engineers, developers, and business analysts to align QA with project goals
Conduct performance and scalability testing for ETL jobs and data workflows
Manage QA configurations and enforce data quality and governance standards
Implement automated testing and deployment processes using Azure DevOps CI/CD pipelines
Create technical documentation and knowledge transfer materials for operational teams
Additional Information
Testing Focus: Data integration, ETL pipelines, and enterprise data platforms
Cloud Platform: Microsoft Azure
Key Technologies: Azure Data Factory (ADF), SSIS, Snowflake, Azure Data Lake Storage (ADLS), Azure Functions, Azure Batch
Automation: Python, Playwright or similar testing frameworks
Data Validation: SQL (Snowflake & SQL Server)
DevOps Tools: Azure DevOps CI/CD
Collaboration Model: Work closely with data engineers, business analysts, and cross-regional teams
Domain Preference: Investment management / financial services experience preferred
#LI-SB1