ETL Test Lead

3 weeks ago

Sydney, New South Wales, Australia Cognizant Technology Solutions Full time

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 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 or follow us @Cognizant.

#LI-CTSAPAC

  • Technical lead Data Engineer

    7 days ago

    Sydney, New South Wales, Australia Cognizant Technology Solutions Full time

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

  • Technical lead Data Engineer

    7 days ago

    Sydney, New South Wales, Australia Cognizant Full time

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

  • Base 24 Engineering Lead

    1 week ago

    Sydney, New South Wales, Australia Robert Walters Full time

    An exciting opportunity has arisen for a seasoned Base 24 Engineering Lead to join a dynamic team within a leading financial institution. This role offers the chance to lead and manage a dedicated Cards and Payments Change team, delivering software development and scheme compliance projects. The successful candidate will have the opportunity to work on...

  • Guidewire Tech Lead

    3 weeks ago

    Sydney, New South Wales, Australia Cognizant Technology Solutions Full time

    Job DescriptionWhat 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...

  • Guidewire Tech Lead

    3 weeks ago

    Sydney, New South Wales, Australia Cognizant Full time

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

  • Pricing Implementation Lead

    4 weeks ago

    Sydney, New South Wales, Australia Chubb Full time

    Job DescriptionChubb celebrates diversity by fostering an inclusive, flexible and equitable workplace. We support applications from all members of our community and equitable access to our employment opportunities. We are open to discussing workplace flexibility in all our vacancies, to ensure we can attract the best candidates and accommodate individual...

  • AEM Technical Lead

    2 weeks ago

    Sydney, New South Wales, Australia Cognizant Technology Solutions Full time

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

  • Lead Analyst

    1 week ago

    Sydney, New South Wales, Australia Reserve Bank of Australia Full time

    We are hiring for a Lead Analyst x2. We have two positions available About the team: The Financial Stability Department advises the Governors and Board on risks to the stability of the financial system and produces the biannual Financial Stability Review (FSR). The Australian Financial System section (AFS) assesses the resilience of the financial system by...

  • Technical Lead Electronics Assembly

    4 weeks ago

    Sydney, New South Wales, Australia Signify Netherlands B.V. Full time

    We're looking for an Electronics Assembly Technical Lead to join our Manufacturing team at Philips Dynalite.Philips Dynalite is Signify's global brand in connected lighting control. Based in Mascot, Sydney, the Dynalite team works alongside our global network of sales and support staff to deliver on our unified purpose: to unlock the extraordinary potential...

  • Senior Guidewire Functional Consultant

    4 weeks ago

    Sydney, New South Wales, Australia Cognizant Technology Solutions Full time

    As a Senior Functional Guidewire Lead, you will be the driving force behind successful Guidewire implementations. Your expertise in configuring and optimizing Guidewire applications will be invaluable as you collaborate with cross-functional teams, lead projects, and ensure seamless integration of Guidewire solutions. If you're passionate about insurance...

  • Data Engineer

    7 days ago

    Sydney, New South Wales, Australia Cognizant Full time

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

  • Guidewire Senior Developer

    3 weeks ago

    Sydney, New South Wales, Australia Cognizant Technology Solutions Full time

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

  • Manager - Projects

    3 weeks ago

    Sydney, New South Wales, Australia Cognizant Full time

    Cognizant (NASDAQ: CTSH) is a leading provider of information technology, consulting, and business process services, dedicated to helping the world's leading companies build stronger businesses. Headquartered in Teaneck, New Jersey (U.S.), Cognizant combines a passion for client satisfaction, technology innovation, deep industry and business process...

  • Guidewire Senior Developer

    3 weeks ago

    Sydney, New South Wales, Australia Cognizant Full time

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

  • Automation Engineer

    7 days ago

    Sydney, New South Wales, Australia Cognizant Full time

    Cognizant (NASDAQ: CTSH) is a leading provider of information technology, consulting, and business process services, dedicated to helping the world's leading companies build stronger businesses. Headquartered in Teaneck, New Jersey (U.S.), Cognizant combines a passion for client satisfaction, technology innovation, deep industry and business process e...

  • Service Delivery Manager

    1 week ago

    Sydney, New South Wales, Australia FIS Global Full time

    Position Type : Full time Type Of Hire : Experienced (relevant combo of work and education) Travel Percentage : 5 - 10%FIS is a Fortune 500 global leader in financial services technology, with a focus on retail and institutional banking, payments, asset and wealth management, risk & compliance, as well as consulting and outsourcing solutions. FIS serves...

  • Senior Electrical Engineer

    3 weeks ago

    Sydney, New South Wales, Australia Sulzer Pumps US Inc. Full time

    [[title]] - [[cust3]] - [[filter4]], [[filter1]]Sulzer is a leading engineering company with a proud heritage of innovation. Join our global team to grow your expertise and develop innovative solutions that enable a prosperous and more sustainable society.Your main tasks and responsibilities: Interpret and define relevant standards for application across...

  • Regional Partner Program Manager

    2 weeks ago

    Sydney, New South Wales, Australia Dynatrace Full time

    Company DescriptionDynatrace exists to make the world's software work perfectly. Our unified software intelligence platform combines broad and deep observability and continuous runtime application security with the most advanced AIOps to provide answers and intelligent automation from data at an enormous scale. This enables innovators to modernize and...

  • Senior Cloud Security Analyst

    4 weeks ago

    Sydney, New South Wales, Australia Robert Walters Full time

    As a Senior Cloud Security Analyst, you will play a pivotal role in shaping the cyber governance landscape within the organisation. Your primary responsibility will be to provide robust assurance over the cloud environment, ensuring that all platforms and workloads adhere to the stringent security control objectives. You will be instrumental in implementing...

  • Senior Technology Risk Manager

    1 week ago

    Sydney CBD, New South Wales, Australia Robert Walters Full time

    As a Senior Technology Risk Manager, you will play a pivotal role in ensuring that the business manages its key technology risks effectively from a 1st line perspective. Key Responsibilities: Drive, coordinate and support the provision of business aligned quality and timely risk and compliance services within the business.Provide insights into emerging...