ETL Test Lead — Azure Synapse & Data Warehouse

Carecone Group; Sydney; On-site; AUD 90,000 - 110,000; Full time

Job summary

Cognizant is hiring an ETL Test Lead to oversee E2E data warehouse testing for an insurance account in Australia. The role involves Azure migration work from Guidewire/DB2 to EVOLVE sources and Power BI reporting, with coordination of offshore teams.

Strong ETL/DWH expertise and Azure cloud experience are essential. The candidate should perform defect tracking in JIRA, create test strategies, and lead automation efforts, SQL data validation, and data migration validation across multiple

Qualifications

• ETL and Datawarehouse testing experience
• Azure cloud knowledge required
• Experience with Guidewire and Evolve data migrations
• Experience with offshore teams and Jira defect tracking
• Strong SQL, Unix, and scripting skills
• Agile development experience

Responsibilities

• Lead E2E Datawarehouse testing for large programs
• Define test strategy, plans, and scenarios
• Prepare test cases, scripts, and data guidelines
• Develop automation test framework for data quality
• Coordinate defects tracking and triage with client
• Collaborate with BA and development teams

Skills

ETL testing

Azure cloud

SQL

JIRA

Offshore team management

Data warehouse testing

Scripting Python

Big Data tools

Education

Azure Fundamentals AZ-900

Azure Data Fundamentals DP-900

Cert. Scrum Master (CSM)

Oracle SQL Fundamentals I

Tools

Azure Synapse

Synapse Pipeline

DB2

SQL Server

JIRA

Confluence

Bitbucket

Jenkins

Git

Apache Spark

Hive

HBase

MongoDB

Python

Job description

Cognizant is hiring an ETL Test Lead to oversee E2E data warehouse testing for an insurance account in Australia. The role involves Azure migration work from Guidewire/DB2 to EVOLVE sources and Power BI reporting, with coordination of offshore teams.

Strong ETL/DWH expertise and Azure cloud experience are essential. The candidate should perform defect tracking in JIRA, create test strategies, and lead automation efforts, SQL data validation, and data migration validation across multiple