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

  • Etl Test Lead

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

  • Etl Test Lead

    1 week ago

    Sydney, New South Wales, Australia Carecone Full time

    Skills and experience needed: Proven experience as a Test Lead. Comprehensive understanding of Data Warehouses, Business Intelligence and Analytics systems. 5+ years of Database and ETL testing Experience carrying out Test Planning, stakeholder management, manual testing Knowledge of testing principles, methods, tools and technologies, including plans,...

  • Test Lead-etl Testing

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

  • Etl Test Lead/banking/cognos

    1 week ago

    Sydney, New South Wales, Australia Carecone Full time

    Job Description-**Skill Sets ETL Test, SQL, Banking domain, cognos* Experience in DWH ,Cognos and ETL Testing: Extensive experience in testing of COGNOS, DWH and database In depth knowledge of the full testing life cycle:Experience workingin Banking / Financial Services: Strong analytical qualities: Experience of working on agile projects:Leading Offshore...

  • Test Lead-ETL testing

    3 weeks ago

    Sydney, New South Wales, Australia Cognizant Full time

    Job Description Looking for a great opportunity to join the team at Cognizant? A place where you can grow rapidly in an international and dynamic environment? We are seeking individuals with an entrepreneurial mindset who are eager to make a meaningful impact. Join forces with colleagues worldwide at Cognizant to craft solutions for top-tier companies,...

  • Test Lead-ETL testing

    1 month ago

    Sydney, New South Wales, Australia Cognizant Full time

    Job Description Looking for a great opportunity to join the team at Cognizant? A place where you can grow rapidly in an international and dynamic environment? We are seeking individuals with an entrepreneurial mindset who are eager to make a meaningful impact. Join forces with colleagues worldwide at Cognizant to craft solutions for top-tier companies,...

  • Test Lead-ETL testing

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

  • Etl Test Analyst/banking

    1 week ago

    Sydney, New South Wales, Australia Carecone Full time

    Skill Sets- ETL Testing, DW, Banking domainKey Responsibilities:Skills: Experience in testing data validation scenarios and Data ingestion, pipelines, and transformation processes (e.g.,ETL). An understanding of big data engineering tools and how they can be used strategically (e.g. Spark, Hive, Hadoop, Dask). Demonstrated experience of working with...

  • Etl Testing

    1 week ago

    Sydney, New South Wales, Australia XPT Software Australia PTY Ltd Full time

    About us:About XPT XPT Software Australia PTY Ltd, incorporated in 2016, is a Software Services company XPT works with top clients across Australia in Banking, Insurance, Telecom, Retail, Energy, Mining and Manufacturing domains. We have 120+ technocrats in Australia working at our client locations. XPT Software Australia is part of group companies which has...

  • Etl Testing with QA

    1 week ago

    Sydney, New South Wales, Australia XPT Software Australia PTY Ltd Full time

    About us:About XPT XPT Software Australia PTY Ltd, incorporated in 2016, is a Software Services company XPT works with top clients across Australia in Banking, Insurance, Telecom, Retail, Energy, Mining and Manufacturing domains. We have 120+ technocrats in Australia working at our client locations. XPT Software Australia is part of group companies which has...

  • Etl QA Testing

    1 week ago

    Sydney, New South Wales, Australia XPT Software Australia PTY Ltd Full time

    About us:About XPT XPT Software Australia PTY Ltd, incorporated in 2016, is a Software Services company XPT works with top clients across Australia in Banking, Insurance, Telecom, Retail, Energy, Mining and Manufacturing domains. We have 120+ technocrats in Australia working at our client locations. XPT Software Australia is part of group companies which has...

  • Etl Test Analyst, Nsw, 6 Months

    1 week ago

    Sydney, New South Wales, Australia Infopeople Full time

    ETL Test Analyst NSW 6 MonthsThe role performs test and evaluation activities, including liaising with Test Manager, System Architects, business users, business analysts, Business SMEs and vendor developers to ensure that planned testing meets their requirements and assisting with writing test plans, developing and executing Sprints, SIT, business End-to-End...

  • Test Lead

    1 week ago

    Sydney, New South Wales, Australia SG Consulting Limited Full time

    SG Consulting is an IT consulting firm based in New Zealand, Australia, and India and the business leaders come to us when they want enduring results. We find value across boundaries, develop insights to act on, and energize teams to sustain success.We are looking for a Test Lead - COGNOS | ETL | SQL for one of our clients in Sydney/ Brisbane/Melbourne,...

  • Test Lead

    1 week ago

    Sydney, New South Wales, Australia Ontrack Systems Aus Pty Ltd Full time

    Test Analyst with 4 to 5 years of experience in Data warehouse/ETL testing and a minimum of 6 months to 1 year of testing experience in Microsoft Azure.Must have skills: Know how or experience in different components of Hadoop like HDFS, HIVE, Sqoop, HBASE, MapReduce. Experience and knowledge in Microsoft Azure tools such as ADLS, ADF, Azure DevOps, Dremio,...

  • ETL Developer

    1 week ago

    Sydney, New South Wales, Australia HiTech Group Full time

    Leading Federal Government Department Initial contract until 30th June month extension options Rewarding hourly rate paired with flexible working arrangements A supportive and prominent Federal Government Department is looking to engage an experienced ETL Developer for the design and development of software solutions that extract, transform and load...

  • Test Lead

    1 week ago

    Sydney, New South Wales, Australia Halcyon Knights Full time

    Our Government client is seeking a Test Lead to join its Data and Analytics Branch in Surry Hills, NSW. As the Test Lead, you will be responsible for implementing the ADA Quality Assurance framework in all projects, products, and initiatives within the team. You will define the scope of testing for each release, build test cases, and ensure test coverage of...

  • Test Lead

    1 week ago

    Sydney, New South Wales, Australia Bluefin Resources Full time

    Contract role 12 months with extension Australian Government / NSW / WFHTest Lead 12 months contract with extension Australian Government Surry Hills + WFHAbout the role:The Test Lead has up to 5 reports, will build up and lead the implementation of the Quality Assurance framework in all projects, products or initiatives for an Australian Government...

  • Test Lead

    1 week ago

    Sydney, New South Wales, Australia Human Capital Management Australia Full time

    A federal government agency is looking to bolster its Testing capability and needs a Test Lead to assist with a number of data focussed initiatives.The team develops, governs, and maintains an enterprise data warehouse as well as the Agencies' reporting platforms and production content. They design and build Business Intelligence (BI) interventions and...

  • Etl-dw Test Manager

    1 week ago

    Sydney, New South Wales, Australia SG Consulting Limited Full time

    SG Consulting is an IT consulting firm based in New Zealand, Australia, and India and the business leaders come to us when they want enduring results. We find value across boundaries, develop insights to act on, and energize teams to sustain success.We are looking for an ETL-DW Test Manager (BFSI Domain) for one of our clients in Sydney/Melbourne/Brisbane,...

  • Lead Test Analyst/manager, Nsw, 6 Months

    1 week ago

    Sydney, New South Wales, Australia Infopeople Full time

    Lead Test Analyst/Manager NSW 6 MonthsKey Responsibilities: Developing reusable ETL test artefacts for Data Migration. Performing Functional and ETL test execution ensuring solutions meet agreed migration, mapping and performance standards. Demonstrated experience testing in an Agile environment. Good understanding of Data Migration and Mapping exercise....