ETL Test Lead - Azure Synapse Data Warehouse

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

Job summary

Cognizant is seeking an ETL Test Lead to oversee E2E data warehouse testing for an insurance program in Australia. The role involves Azure Synapse, Guidewire & Evolve data sources, and managing offshore teams to deliver robust Power BI reporting solutions.

You will create test strategies, design scenarios, and drive defect triages while collaborating with BA and development teams to meet functional and technical requirements. Strong ETL, DW, and cloud experience are essential.

Qualifications

• Experience in ETL and Datawarehouse testing across cloud platforms (AWS/Azure).
• Hands-on with Synapse pipeline logs analysis and debugging.
• Proficient in SQL, Unix, VB scripting, Oracle, Snowflake, Redshift.

Responsibilities

• Perform E2E Datawarehouse testing for large programs.
• Gather business requirements and design walkthroughs; raise clarifications.
• Define scope from functional and technical documents; perform gap analysis.
• Collaborate with BSA to understand requirements; prepare test strategy.
• Create detailed test plans, scenarios, cases, scripts, and data guidelines for multiple portfolios.
• Identify testable scenarios and maintain traceability matrix with test scenarios.
• Design/modify SQL test scripts per mapping documents and specs; run jobs.
• Execute automation and manual tests; maintain testing evidence and status.
• Prepare data mocks when needed; ensure data migration aligns with logic.
• Log defects, track to closure; participate in triages and root-cause analysis.
• Publish daily status and defect metrics to client; prepare dashboards and test summaries.
• Design and implement a data warehouse QA automation framework.
• Coordinate with stakeholders and inform progress to BA & development teams.

Skills

ETL Testing

Data Warehouse Testing

Azure Synapse

SQL

JIRA/Agile

Offshore team leadership

Education

Tricentis Data Integrity Consultant

Azure Fundamentals AZ-900

Azure Data Fundamentals DP-900

Certified Scrum Master CSM

Oracle SQL Fundamentals I

Job description

Cognizant is seeking an ETL Test Lead to oversee E2E data warehouse testing for an insurance program in Australia. The role involves Azure Synapse, Guidewire & Evolve data sources, and managing offshore teams to deliver robust Power BI reporting solutions.

You will create test strategies, design scenarios, and drive defect triages while collaborating with BA and development teams to meet functional and technical requirements. Strong ETL, DW, and cloud experience are essential.