ETL Test Lead - Azure Synapse Data Warehouse

Cognizant; Sydney; Presencial; AUD 90.000 - 110.000; Jornada completa

Descripción de la vacante

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.

Formación

• 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.

Responsabilidades

• 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.

Conocimientos

ETL Testing

Data Warehouse Testing

Azure Synapse

SQL

JIRA/Agile

Offshore team leadership

Educación

Tricentis Data Integrity Consultant

Azure Fundamentals AZ-900

Azure Data Fundamentals DP-900

Certified Scrum Master CSM

Oracle SQL Fundamentals I

Descripción del empleo

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.