ETL Test Lead, Sydney,NS-Level37 TowerTwo, New South Wales, Australia

What makes Cognizant a unique place to work? The combination of rapid growth and a unique place international and innovative environment! This is creating many opportunities for people like YOU — people with an entrepreneurial spirit who want to make a difference in this world.

At Cognizant, together with your colleagues from all around the world, you will collaborate on creating solutions for the world’s leading companies and help them become more flexible, more innovative, and successful. Moreover, this is your chance to be part of the success story.

Position Summary:

Cognizant is seeking a ETL Test Lead to work with Functional, Integration and E2E business process testing for an insurance account in Australia. This role is for an ETL Test lead who can work individually on the Azure migration project from Guidewire/DB2 and EVOLVE sources to Power BI reports and can handle offshore team. Should have hands on experience and strong knowledge on ETL/DWH concepts with Azure cloud knowledge. Should be having hands on experience on Azure Synapse, Synapse Pipeline, Db2, SQL server experience. Should be able to create scenarios and Defect tracking in JIRA and able to manage offshore team.

Mandatory Skills:

Strong experience of ETL and Datawarehouse Testing using AWS/Azure Cloud services
Synapse pipeline logs analysis and debug
SQL, Unix, VB Scripting, Oracle, Snowflake, Redshift
Technical skills on SQL query, data modelling and data pipeline is essential for this role
Understanding complex business problems/requirements to develop test cases
Experience with Agile development methodology
Hands on use of the Atlassian toolset of JIRA, Confluence, Bitbucket, Jenkins and GIT
Big Data Stack (Apache Spark, Hive, Hbase)
MongoDB, Python
Insurance Domain Knowledge
Data migration projects with Insurance COTS products like Guidewire and Evolve

Roles And Responsibilities:

Responsible to perform E2E Datawarehouse testing for large program
Responsibility includes Business Requirement gathering & Design walkthrough sessions and Understanding the Functional Specification documents and raising of clarifications
Defining the Scope based on the Functional and Technical Documents
Performing gaps analysis by comparing technical documents with Business Requirements and ensuring whether all functional requirements are implemented in technical document
Liaison with BSA to understand the requirements
Prepare test strategy
Provide Detailed Test Plan & Test strategy and Preparing Test Scenarios, Test Cases, Test Scripts & Data Guidelines based on the Functional Specification documents and tools across multiple portfolios to reduce the cost of quality and contribute towards organizational testing policy
Identify testable scenarios (test scenario document)
Create / update the Requirements traceability matrix with test scenarios
Identify test cases for automation and seek sign off from customer
Create test cases based on the understanding of the requirements
Create/Modify the SQL test scripts as per the ETL mapping documents and technical specifications & Requirements
Run the jobs and perform smoke testing
Execute automation test scripts/manual test cases
Record and maintain testing evidence and track execution status of assigned test cases
Responsible for Data Mock up when any of the business scenarios not met and make sure that Data migrating from the source to target is in line with the logic specified
Identify defects and log failures
Track defects (defect log as generated from the QC tool/JIRA Tool) to closure
Participate in the defect triages to gather evidence for defect identification on periodic basis for defect prioritization and fix
Retest the defect and update the status
Performing Root Cause Analysis for Critical Defects and handled Defect Calls
Reporting the Bugs using Defect Tracking Tool and making sure all defects are closed and Publishing Daily Status and Defect Metrics to the client
Responsible in Preparation of Dashboard, weekly status report and Test Summary Report
Designing and implementing test automation framework for data warehouse quality assurance
Internal review and share for stakeholder review and feedback
Collaborate closely with BA & development team

Qualifications/Certifications:

Tricentis Data Integrity Product Consultant Certificate (Must have)
Azure Fundamentals Certificate (AZ-900) (Must have)
Azure Data Fundamentals (DP-900) (Must have)
Certified Scrum Master (CSM) (Must have)
Oracle Database 11g: SQL Fundamentals I (Optional)

Salary Range: >$100,000
Date of Posting: 20-Oct-26

Next Steps: If you feel this opportunity suits you, or Cognizant is the type of organization you would like to join, we want to have a conversation with you! Please apply directly with us.

For a complete list of open opportunities with Cognizant, visit http://www.cognizant.com/careers. Cognizant is committed to providing Equal Employment Opportunities. Successful candidates will be required to undergo a background check.

Sobre a Cognizant
Cognizant (NASDAQ: CTSH) é uma construtora de IA e fornecedora de serviços de tecnologia, criando a ponte entre o investimento em IA e o valor para as empresas por meio do desenvolvimento de soluções de IA completas para nossos clientes. Nossa profunda experiência em setores, processos e engenharia nos permite incorporar o contexto único de cada organização em sistemas tecnológicos que potencializam a capacidade humana, geram resultados tangíveis e mantêm empresas globais à frente em um mundo em rápida transformação. Saiba mais em cognizant.ai ou @cognizant.

A Cognizant é uma empregadora que investe em equidade. Sua candidatura não será pautada em raça, cor, gênero, sexualidade, credo, origem, deficiência, gravidez ou qualquer outra característica protegida pelas leis brasileiras.

Informações adicionais de emprego
Os candidatos podem ser obrigados a comparecer a entrevistas presenciais ou por videoconferência. Além disso, os candidatos podem ser obrigados a apresentar seu documento de identificação emitido pelo estado ou governo atual durante cada entrevista.

Embora nosso sistema permita a candidatura em todos os idiomas, o(s) idioma(s) e o(s) nível(is) de proficiência exigidos para o trabalho variam. No entanto, é necessário um nível básico de inglês para fins de comunicação em toda a empresa.

Se você tem uma deficiência que requer adaptações razoáveis para procurar uma vaga de emprego ou enviar uma candidatura, envie um e-mail para [email protected] com sua solicitação e informações de contato.