QA Lead - Data Warehouse BI Testing

Overview

On Site
$55+
Contract - W2
Contract - 6 Month(s)

Skills

Testing
Quality Assurance
Regulatory Compliance
Data Validation
Data Governance
Data Migration QA
Data Modeling
Data Quality
Data Warehouse
Data Integration
DevOps
Collaboration
Communication
Continuous Delivery
Continuous Integration
ETL QA
ADF
API QA
Automated Testing
Business Rules
Cloud Computing
Data Flow
Extract
Transform
Load
Investment Management
Knowledge Transfer
Leadership
Microsoft Azure
Microsoft SQL Server
Microsoft SSIS
Python
Regression Testing
SQL
Scalability
Scripting
Snow Flake Schema
Technical Writing
Test Plans
Workflow

Job Details

** No Fake GCc | BGV Mandatary with Passport Number
Location: ONSITE- San Francisco OR San Ramon CA
Experience requested: 15+YRS
Description:
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.)."
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.
Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.