Skip to main content

ETL Test Lead

00070964651

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.

About Cognizant: 
Cognizant (Nasdaq: CTSH) is an AI Builder and technology services provider, bridging the gap between AI investment and enterprise value by building full-stack AI solutions for our clients. Our deep industry, process and engineering expertise enables us to build an organization’s unique context into technology systems that amplify human potential, drive tangible outcomes and keep global enterprises ahead in a fast-changing world. See how at cognizant.ai or @cognizant.

Additional employment information
Compensation information is accurate as of the date of this posting. Cognizant reserves the right to modify this information at any time, subject to applicable law.

Applicants may be required to attend interviews in person or by video conference. In addition, candidates may be required to present their current state or government issued ID during each interview.

Cognizant is an equal opportunity employer. Your application and candidacy will not be considered based on race, color, sex, religion, creed, sexual orientation, gender identity, national origin, disability, genetic information, pregnancy, veteran status or any other characteristic protected by federal, state or local laws.

Benefits that help you thrive and grow

Our benefits program is built with you in mind—so you can enjoy a fulfilling, balanced and healthy life.

a blue line drawing of a plant with leaves

Financial wellbeing

We regularly review market data to ensure compensation reflects the value you bring. Your benefits extend beyond pay and may include retirement plans, financial education, etc.

Stay Healthy Midnight Blue RGB

Physical and mental health

We empower you to prioritize your wellbeing through paid time off, flexible working where possible, healthcare plans, counselling, our Mental Health Allyship program and more. 

Build The Career You Want Midnight Blue RGB

Your career, your way

With 350,000+ roles at Cognizant, you’ll have opportunities explore new technologies, industries and locations—and build the skills you need to grow your career.

Making A Meaningful Impact Midnight Blue RGB

Real-world impact

Think about the biggest brands you rely on. Chances are, they rely on us to help strengthen their business. Here, you’ll turn bold ideas into solutions that improve lives everywhere.

Your path to Cognizant

Here’s what you can expect from our hiring process. Please keep in mind that it may vary by role and location. Explore our FAQs to learn more.

a person sitting at a table using a laptop

Step 1: Apply to the right opportunity

Find an open role that matches your skills and career goals and show us why you’re the person for the job. Don’t see the right opportunity? Consider joining our Talent Community.

a person holding a tablet and talking on the phone

Step 2: Connect with your recruiter

If one of our recruiters sees a fit, they’ll set up a short intro call to learn more about you and how your experiences and skills match the role.

a person smiling at a table with a laptop

Step 3: Show off your skills

If you and our team would like to continue the process, you’ll interview with our hiring team. Some roles may also require technical assessments and/or client interviews.

a group of people sitting around a table

Step 4: Decision time

Our team will then review each candidates’ potential to succeed in the role. This step may take some time because we want to find the right fit for both you and us—but you can count on us to keep you updated.

a person with long blonde hair wearing a white shirt with orange and purple flowers
What I value most about working at Cognizant is the opportunity to innovate while delivering real business impact. My role allows me to combine strategy, technology, and collaboration across global teams, which makes every project meaningful. The support for continuous learning and innovation has been instrumental in my growth.
Beata Ogorzala Senior Event Manager
a person in a blue jacket
Cognizant has one of the best learning ecosystems you can ask for. From sponsored certifications to training platforms to mentorship, we have all that we need to grow.
Debashish Mishra SAP MM Developer
2
Cognizant offers me more than a job; it offers a community. We support each other, collaborate across borders and celebrate wins together. If you’re looking for a culture that values flexibility, diversity and growth, this is the place to be.
Laura Reynaud Lead Counsel
a person with long hair wearing a pink shirt
When I first joined, I was quiet and hesitant to share my thoughts. The leadership programs and the mentoring I’ve received have helped me find my voice and grow as a leader.
Sujatha Gopalakrishnan Portfolio Delivery Lead
4
I’ve had the chance to work on impactful projects and shadow colleagues, all while getting involved in internal initiatives. The world is your oyster at Cognizant—you just need to take advantage of it!
Lucas Hoffman Consultant

Haven't yet found the right opportunity?

Get the latest updates on job opportunities, recruitment events and company news—tailored just for you!

Be in the know