Etl Test Lead

2 weeks ago

Sydney, New South Wales, Australia Cognizant 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 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 (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.
- 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

**Date of posting**:04/10/2024

**About Cognizant**:
LI-CTSAPAC

  • ETL Test Lead

    4 days ago

    Sydney, New South Wales, Australia ALOIS Solutions Full time $80,000 - $120,000 per year

    Role : ETL Test LeadLocation : SydneySkills:-SQLData WarehousingSnowflake

  • ETL Test Lead Specialist

    2 weeks ago

    Sydney, New South Wales, Australia beBeeInformatica Full time $110,000 - $140,000

    We are seeking a seasoned Informatica ETL Test Lead to join our team. This role involves designing and implementing test strategies, creating and executing test cases, and ensuring the quality of our data warehousing projects.Key responsibilities include:Designing and implementing test strategies that meet business requirementsCreating and executing test...

  • ETL Test

    2 weeks ago

    Sydney, New South Wales, Australia CareCone Group Full time $96,000 - $124,000 per year

    Role : ETL Test - Data WarehousePermanent PositionLocation : Sydney AustraliaJob Description :No of years of hands on experience with Data warehouse / ETL testing.Good experience on Match, Merge, Survivorships rules.Extensive Experience in Manual Testing, Database Testing, ETL Testing. Understand the behaviour of complex data warehousing and business...

  • Test Lead-Etl Testing

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

  • ETL Test Professional

    2 weeks ago

    Sydney, New South Wales, Australia beBeeEtlTesting Full time $80,000 - $120,000

    Job OverviewWe are seeking an experienced ETL test professional to fill a critical role.Significant experience in ETL testing is crucial for success.Detailed knowledge of JMeter principles and methodologies is also required.The ideal candidate will possess a solid understanding of ETL testing concepts, excellent analytical skills, and the ability to resolve...

  • Etl Test Lead/Banking/Cognos

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

  • ETL Testing Expert

    7 days ago

    Sydney, New South Wales, Australia beBeeTest Full time US$170,000

    Job DescriptionWe are seeking an experienced ETL Test Consultant to join our team. The successful candidate will possess excellent expertise in ETL test management and related roles, with a focus on delivering high-quality test outcomes.The ideal candidate will have experience leading large teams and programs for delivery of technical outcomes, as well as...

  • Etl Testing

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

  • ETL Testing Expert

    2 weeks ago

    Sydney, New South Wales, Australia beBeeDataTesting Full time $128,191 - $136,132

    Job OverviewAs a senior consultant in ETL testing, you will play a pivotal role in driving data testing strategies and solutions for multiple teams. This position involves end-to-end data testing for ETL/DW/BIG Data & Cloud migration projects, as well as engaging with customers and stakeholders to drive project releases and technical discussions.Key...

  • Etl Test Analyst

    2 weeks ago

    Sydney, New South Wales, Australia Wipro Full time

    Join to apply for the ETL Test Analyst role at Wipro1 day ago Be among the first 25 applicants Join to apply for the ETL Test Analyst role at Wipro You are an experienced ETL Tester with 5+ years in SQL, Control-M, Unix, and data warehousing, skilled in testing, reporting, and collaboration tools like JIRA and Confluence6 months Fixed Term Employement, Based...