ETL Test Lead

3 weeks ago

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

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

  • ETL Testing

    4 weeks ago

    Sydney, Australia XPT Software Australia Pty Ltd Full time

    Job Description:·       Strong knowledge of ETL testing methodologies and processes.·       Extensive experience with ETL tools - Informatica·       Strong ETL and SQL scripting technical background.·       Strong Control M / job schedulers ·       Extensive experience within data warehousing and reporting ·      ...

  • Test Lead-etl Testing

    8 hours ago

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

  • Etl Tech Lead

    4 weeks ago

    Sydney, Australia Delivery Centric Technologies Full time

    _**We are currently hiring ETL Tech Lead who is based out of Sydney!!!**_ **Role Title** :ETL Tech Lead **Location**: Sydney **Employment Type** : Full Time **Key Responsibilities**: - Experience in **ETL testing** | Experience in **test planning**: - Experience in **test estimation**, creating **SQL based test cases**, **SQL based test execution**: -...

  • Etl Test Lead with Informatica

    4 weeks ago

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

  • Test Manager

    4 weeks ago

    Sydney, Australia Delivery Centric Technologies Full time

    **Job Title: Test Manager - ETL** **Location: Sydney, Australia** **Employment Type - Full Time** **Skills Required: ETL Test Manager (BFSI Domain)** - Previous successful test management of several projects including at least 5 years' experience as a Test Manager is essential - Deep knowledge of the software Systems Development Lifecycle is essential -...

  • Etl Test Manager/banking Domain

    1 month ago

    Sydney, Australia Carecone Full time

    **JD**: **Exp - 8+yrs** Onshore and Offshore Team Handling experience ETL, Testing, SQL experience is must Domain - Banking **Location: Sydney/ Melbourne/ Brisbane** **Skill Sets - ETL Testing, SQL Queries, JIRA / Confluence, AGILE** - Overall 8+ Years of **experience in testing | Experience in test planning**: - Experience in test **estimation,...

  • Test Lead

    1 month ago

    Sydney, 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/...

  • Test Lead

    6 days ago

    Sydney, Australia Ontrack Systems 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,...

  • Etl Test Lead/data Test Lead

    4 weeks ago

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

  • ETL Developer

    1 week ago

    Sydney, Australia Northbridge Recruitment Full time

    PurposeThe purpose of this role is to architecture tasks including data models, reverse engineering, and performance optimisation by designing, developing, unit testing and maintaining ETL jobs to create or enhance data warehouses / datamarts, to integrate data from multiple sources. Responsibilities• Design ETL via source-to-target mapping and design...

  • Etl Tester

    1 month ago

    Sydney, Australia GoTech Solutions Pty Ltd Full time

    **About Us**: GOSOL, IT consulting and Staffing organization, can help you enhance Technology, Digital, Project and Business Transformation. Guided by integrity and trust, we believe in offering an unparalleled experience as your Tech of choice. For businesses, this means providing you with access to the quality solution. - Sound experience in ETL and...

  • Etl Test Analyst(Cloud+data Modelling)

    4 weeks ago

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

  • ETL Developer

    3 weeks ago

    Sydney, Australia Attribute Group Full time

    The Company:Attribute Group are proud to be working with an established boutique software solutions provider. Their portfolio of clients range from some of the biggest companies through to highly specialised SMEs in Australia. They currently have an exciting opportunity available for an ETL Developer to uplift data capability across some key Salesforce CMS...

  • Cognos Test Consultant

    1 month ago

    Sydney, Australia Carecone Full time

    **Job description**: - 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...

  • Data Test Analyst

    4 weeks ago

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

  • Test Lead

    1 month ago

    Sydney, Australia Excolo Full time

    Multiple Technology Programs to be delivered - Sydney, CBD | True Flexible WFH - Newly created permanent position High Profile Financial Services Organisation are looking for a Test Lead to work across multiple high-profile technology transformations! In this role you will be responsible for analyzing requirements, test scope, approach and planning,...

  • Test Lead

    1 month ago

    Sydney, Australia Excolo Partners Full time

    IT & Telecomms - Testing & QA - Sydney Permanent / Full Time 21/3/2023 - Multiple Technology Programs to be delivered - Sydney, CBD | True Flexible WFH - Newly created permanent position High Profile Financial Services Organisation are looking for a Test Lead to work across multiple high-profile technology transformations! In this role you will be...

  • Test Lead

    1 month ago

    Sydney, Australia Horizon Consulting Full time

    Fantastic Opportunity for an experienced Test Lead to join a large organization Our client is looking for an experienced Test Lead to join their dynamic team on an initial 6 months contract(with a view to extend), located in Sydney, NSW The **Test Analyst **is responsible for ongoing quality assurance of all technical deliverables produced by the IT team...

  • Test Lead

    1 month ago

    Sydney, Australia Fyndr Group Pty Ltd Full time

    6 months with possibility of extension - Sydney CBD location - $800-1000 / day **Test Lead** 6 months with possibility of extension Sydney CBD (close to Central station) requires some working in the office location $800-1000 / day **Project scope** The organisation has been going through a large HCM upgrade, moving data from legacy systems to the new...