Description

You will lead QA testing efforts for Enterprise Data Warehouse projects to ensure data integrity and process compliance.

Responsibilities

• Develop test strategies and plans for Data Warehouse projects that map directly to requirements for full coverage.
• Perform ETL validation, including data profiling, reconciliation, metadata validation, and SCD type testing.
• Execute manual and automated test cases and run database queries within Azure DevOps.
• Analyze data, troubleshoot quality issues, and collaborate with project teams on defect triage and resolution.
• Coordinate test execution with application teams and UAT partners while communicating status to stakeholders.

Required Skills

• 5+ years of ETL testing experience in a data warehouse environment.
• 5+ years of experience writing SQL queries and troubleshooting data quality issues.
• Minimum 2 years of experience working with Snowflake and AWS Cloud.
• Proficiency with Snowflake, Snowsight, and Python/PySpark.
• Hands-on experience with DataStage and Azure DevOps.
• Experience leading QA Analysts on a project team.
• Knowledge of ETL technologies including ASG Zena, Infogix, and Tableau.
• Understanding of enterprise data warehousing best practices and standards.
• Bachelor's degree in a related field, such as Computer Science.

Key Skills

Education

Bachelor's degree