ETL Testing Lead

4 weeks ago


Melbourne, Australia Capgemini Full time

About Capgemini:

Capgemini is a global leader in partnering with companies to transform and manage their business by harnessing the power of technology. The Group is guided everyday by its purpose of unleashing human energy through technology for an inclusive and sustainable future. It is a responsible and diverse organization of 270,000 team members in nearly 50 countries. With its strong 50-year heritage and deep industry expertise, Capgemini is trusted by its clients to address the entire breadth of their business needs, from strategy and design to operations, fueled by the fast evolving and innovative world of cloud, data, AI, connectivity, software, digital engineering, and platforms. The Group reported in 2020 global revenues of €16 billion.

Role Description:

The ETL Testing Lead will lead a team of ETL data testers & performance testers and report to Project Manager or Platform Technical Group Lead. The ETL Testing Lead will work with others who perform technical “T” shaped roles who may be providing testing functions.

Candidate must have Australian Citizenship

Job Overview

The resource is expected to lead testing team & be hands on in performing QA tasks with the requirement to perform technical coding for testing purposes. The majority of the testing will require the technical creation of scripts and or providing QA direction as well as technical direction to write relevant scripts/jobs to perform end to end ETL data testing. Responsibilities include authoring Test Strategy Plan, Test Summary Report, testing (System testing, System Integration testing, UAT,etc), automating testing as required, to assist others around the QA process providing guidance, assistance and oversight of all QA activities across the full delivery lifecycle. Perform standard sets of QA/Data Test activities and produce deliverables or artefacts that are part of quality assurance. (Eg. TSR, Test Cases, Test Strategy.)

Standard Responsibilities and Duties The responsibilities, skills and duties of this job include:

  • Review and analyze system specifications/design to consider the testing approach
  • Collaborate with QA Data Engineersto develop effective strategies and test plans
  • Build test strategy documents
  • Determine what level of testing is required
  • analyzing users stories and/use cases/requirements for validity and feasibility for tests
  • Build data / test files for testing purposes with the assistance of the delivery team if required
  • Design and develop automation scripts when needed
  • Build Test cases which will be based on script development
  • Be able to execute all levels of testing (System, Integration, Regression, UAT)
  • Execute test cases (manual or automated) and analyze results
  • Evaluate product code according to specifications or expected outputs
  • Create logs to document testing phases and defects
  • Report bugs and errors to development teams
  • Help troubleshoot issues including in production
  • Produce test summary reports
  • Conduct post-release/ post-implementation testing
  • Work with cross-functional teams to ensure quality throughout the software development lifecycle
  • Consider performance
  • Automate and reduce turnaround testing time
  • As a part-time engineer - Managing master data, including creation, updates, and deletion.
  • As a part-time engineer – assist in writing algorithms used to perform data ingestion and consumption tasks
  • As a part-time engineer - work with stakeholders to assess potential risks.
  • As a part-time engineer - provide software solution recommendations under the directions of other technical staff

Technical Responsibilities and Duties

  • The responsibilities, skills and duties of this job include:
  • The ability to write scripts using Java & Python
  • Be able to work in an AZURE environment

Skills:

  • More than 4 years proven experience as a Quality Data Assurance Test Lead or similar role
  • Experience in project management and QA methodology
  • More than 2 years’ experience in data analysis would be useful
  • Familiarity with Agile frameworks
  • Understanding of Scrum process and working in Agile environment is required
  • Ability to document and troubleshoot errors
  • Working knowledge of test management software and SQL
  • Automation framework past experience would be highly desirable.
  • Experience in Java is required – preferably more than 2 years
  • Experience in Python is required – preferably more than 2 years
  • Understanding of AZURE (or similar Cloud) would be required
  • Experience in continuous integrations tools
  • Knowledge on GitHub would be advantageous
  • Knowledge of UNIX Scripting would be advantageous
  • SQL, HIVE, Big data ingestion concepts would be desirable
  • Control M, Jenkins for Testing would be highly desirable
  • Analytical mind and problem-solving aptitude
  • Strong organizational skills
  • Excellent communication skills
  • Attention to detail

Qualifications The following qualifications would be advantageous:

  • Education level – Degree in Computer Science or related field
  • A minimum of 7+ years of QA/Data Test knowledge is required
  • Big Data/Analytics frameworks – AZURE or like
  • Underlying infrastructure for Big Data Solutions would be advantageous
  • Ability to code using scripting languages is required – Eg Unix, Java, Python, R
  • Understanding of Financial Services Industry could be advantageous

#LI-AR1



  • Melbourne, Australia Carecone Full time

    **JD-** **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 Test Manager

    2 months ago


    Melbourne, Australia Carecone Full time

    **Locations**:Sydney/Melbourne/Brisbane **Skill Sets-** ETL testing, data warehouse testing JD - hands on experience with **Data warehouse testing/ETL testing**. - Strong **SQL/PL-SQL **skills to write complex SQL queries for validating the data against different kinds of reports. - Experience in various testing like - Functional, Manual, Automated,...

  • Etl Test Manager

    3 weeks ago


    Melbourne, Australia Carecone Full time

    **Locations**:Sydney/Melbourne/Brisbane **Skill Sets-** ETL testing, data warehouse testing JD - hands on experience with **Data warehouse testing/ETL testing**. - Strong **SQL/PL-SQL **skills to write complex SQL queries for validating the data against different kinds of reports. - Experience in various testing like - Functional, Manual, Automated,...


  • Melbourne, Victoria, Australia Carecone Full time

    JD-**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 teams and...

  • Etl Test Manager

    2 months ago


    Melbourne, Australia CareCone Australia Full time

    **Skill Sets - 1-2yrs of exp as test manager, ETL Test, DW, API** **Roles & Responsibilities**: - Good years of experience in data any analytics testing preferably ETL with manging team. - Strong expertise in analysing source to target testing - Demonstrated ability to continuously learn, work independently, and make decisions with mínimal supervision -...

  • Etl Test Manager

    6 days ago


    Melbourne, Victoria, Australia Carecone Full time

    Locations:Sydney/Melbourne/BrisbaneSkill Sets- ETL testing, data warehouse testingJD- hands on experience with Data warehouse testing/ETL testing. Strong SQL/PL-SQL skills to write complex SQL queries for validating the data against different kinds of reports. Experience in various testing like Functional, Manual, Automated, Regression, Integration and User...

  • Etl Tech Lead

    2 weeks ago


    Melbourne, Australia Delivery Centric Technologies Full time

    **Role Title - ETL Tech Lead** **Location: Melbourne** **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 - Experience in writing Test automation scripts - Good working knowledge of ETL testing & SQL -...

  • Etl Test Manager

    6 days ago


    Melbourne, Australia Carecone Pty. Ltd. Full time

    **Key Responsibilities**: - Good expertise on ETL Test Manager or related roles. - Delivery of multiple testing projects to approved scope, budget, schedule, and quality expectations. - Responsible for working closely with external testing service providers to deliver test functions - Responsible for assurance activities across all test deliverables such as...

  • Etl Test Manager

    6 days ago


    Melbourne, Victoria, Australia Carecone Pty. Ltd. Full time

    Key Responsibilities: Good expertise on ETL Test Manager or related roles. Delivery of multiple testing projects to approved scope, budget, schedule, and quality expectations. Responsible for working closely with external testing service providers to deliver test functions Responsible for assurance activities across all test deliverables such as review of...


  • Melbourne, Australia Carecone Full time

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


  • Melbourne, Australia Carecone Full time

    **JD-** **Skill Sets - ETL Test, SQL, Banking domain, JIRA / Confluence, AGILE** - Overall 5+ Years of **experience in testing**: - **Experience in test planning**: - Experience in test **estimation, creating SQL based test cases, SQL based test execution**: - Experience in **writing Test automation scripts**: - Good working knowledge of **ETL testing &...

  • Etl Test Analyst

    2 months ago


    Melbourne, Australia Delivery Centric Technologies Full time

    **Job description** Hello Folks, We are looking for passionate professionals who are passionate about their job and want to make a difference with their consulting and solutioning skills, who are ready to take challenges and test their skills to provide the best solutions. We are currently looking for the below roles **About Delivery Centric**: Delivery...


  • Melbourne, Victoria, Australia Carecone Full time

    JD-**Skill Sets ETL Test, SQL, Banking domain, JIRA / Confluence, AGILE* Overall 5+ Years of experience in testing: Experience in test planning: Experience in test estimation, creating SQL based test cases, SQL based test execution:Experience in writing Test automation scripts: Good working knowledge of ETL testing & SQL:Good practical knowledge of Jira,...

  • Etl Test Analyst

    6 days ago


    Melbourne, Victoria, Australia Delivery Centric Technologies Full time

    Job descriptionHello Folks,We are looking for passionate professionals who are passionate about their job and want to make a difference with their consulting and solutioning skills, who are ready to take challenges and test their skills to provide the best solutions. We are currently looking for the below rolesAbout Delivery Centric:Delivery Centric is a...

  • ETL Testers

    5 days ago


    Melbourne, Victoria, Australia Zone IT Solutions Full time

    We are currently seeking experienced ETL Tester. As an ETL Tester, you will be responsible for ensuring the quality and reliability of our ETL processes and data. This is a great opportunity to work on challenging projects in a dynamic and collaborative environment.RequirementsMinimum of 3 years of experience as an ETL Tester or in a similar role Strong...

  • Etl Tester/api

    2 months ago


    Melbourne, Australia Carecone Full time

    **Skill Sets - ETL testing, API testing** **Responsibilities-** - 5+ Years of Software ETL testing which includes Data Warehouse Testing, api testing - Experience in writing complex SQL queries, ability to determine the types of testing that must be conducted (i.e., data validation, regression, etc.), including evaluating the testability of requirements and...

  • Etl Tester/api

    5 days ago


    Melbourne, Victoria, Australia Carecone Full time

    **Skill Sets ETL testing, API testing**Responsibilities 5+ Years of Software ETL testing which includes Data Warehouse Testing, api testing Experience in writing complex SQL queries, ability to determine the types of testing that must be conducted (i.e., data validation, regression, etc.), including evaluating the testability of requirements and create a...

  • Etl Tester/SQL/banking

    2 months ago


    Melbourne, Australia Carecone Full time

    **Job Description ;** **Skill Sets - ETL Test, SQL, Banking domain** - Experience on ETL testing. - Creating test plans and test cases for assigned modules. - Knowledge on ETL tool and process. - Knowledge on basic Database objects and relational data model. - Experience on SQL query and script. - Testing experience with different file types. - ETL test...


  • Melbourne, Victoria, Australia Carecone Full time

    Job Description ;**Skill Sets ETL Test, SQL, Banking domain* Experience on ETL testing. Creating test plans and test cases for assigned modules. Knowledge on ETL tool and process. Knowledge on basic Database objects and relational data model. Experience on SQL query and script. Testing experience with different file types. ETL test validations and checks /...

  • Test Manager

    3 weeks ago


    Melbourne, Australia Carecone Pty. Ltd. Full time

    Must have **Oracle E-business Suite **or **GL/Finance Reconciliation experience**: - Delivery of **multiple ETL testing projects** to approved **scope**, **budget**, **schedule**, and **quality expectations**. - Should have good understanding of **DW / ETL / Reporting**: - Responsible for working closely with external testing service providers to deliver...