Discover your dream Career
For Recruiters

ETL Test Lead

Cognizant Sydney, Australia
Posted 6 days ago Permanent Competitive
Job Description

What makes Cognizant a unique place to work? The combination of rapid growth and an 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:
  • Need ETL Test Lead to work with functional, integration and E2E business process testing for an insurance account in Australia.
  • This roll is for ETL Test lead who can work individually on the Azure migration project from Guidewire/DB2 and EVOLVE sources 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.
Mandatory Skills:
  • Strong experience of ETL and Datawarehouse Testing using AWS/Azure Cloud services.
  • 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 (ApacheSpark, 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.
  • Liaison with BSA to understand the requirements.
  • Prepare test strategy.
  • 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.
  • 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.
  • Internal review and share for stakeholder review and feedback. Collaborate closely with BA & development team.
Salary Range: >$100,000

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-100: CTSH) is one of the world's leading professional services companies, transforming clients' business, operating and technology models for the digital era. Our unique industry-based, consultative approach helps clients envision, build, and run more innovative and efficient businesses. Learn how Cognizant helps clients lead with digital at www.cognizant.com or follow us @Cognizant.
Job ID  00058876851
More Jobs From Cognizant
Cognizant
Technical lead Data Engineer
Cognizant
Sydney, Australia
6 days ago Full time Competitive
Cognizant
SR. Test Lead
Cognizant
Riyadh, Saudi Arabia
6 days ago Full time Competitive
Cognizant
ServiceNow QA Test Lead
Cognizant
Singapore
6 days ago Full time Competitive
Cognizant
Senior Java Developer
Cognizant
Sydney, Australia
6 days ago Full time Competitive
Cognizant
Guidewire Tech Lead.
Cognizant
Sydney, Australia
6 days ago Full time Competitive
Cognizant
Guidewire Senior Developer
Cognizant
Sydney, Australia
6 days ago Full time Competitive
Cognizant
AEM Technical Lead
Cognizant
Sydney, Australia
6 days ago Full time Competitive
Cognizant
Senior MuleSoft Developer
Cognizant
Sydney, Australia
6 days ago Full time Competitive
Cognizant
Data Engineer
Cognizant
Sydney, Australia
6 days ago Full time Competitive
Cognizant
Automation Engineer
Cognizant
Sydney, Australia
6 days ago Full time Competitive

Boost your career

Find thousands of job opportunities by signing up to eFinancialCareers today.
More Jobs Like This
Cognizant
Technical lead Data Engineer
Cognizant
Sydney, Australia
ING Group
Chapter Lead - Test
ING Group
Sydney, Australia
Hays
Test Lead
Hays
Sydney, Australia
Commonwealth Bank of Australia
Chapter Lead Payments Quality Engineering and Testing
Commonwealth Bank of Australia
Sydney, Australia
State Street Corporation
Automation - ETL - test engineer - Tech Lead
State Street Corporation
Bangalore, India