ETL Test Lead

Capgemini; London; On-site; GBP 50,000 - 75,000; Full time

Job summary

Capgemini seeks an ETL Test Lead to oversee test planning and execution for ETL and visualization projects. This role demands strong ETL and SQL expertise, as well as familiarity with Azure data services. Join us in transforming global businesses through technology while enhancing your career within a supportive environment.

Qualifications

• Expertise in ETL and Data Warehouse testing.
• Proficient in writing complex SQL queries.
• Knowledge of data testing automation tools.

Responsibilities

• Develop and execute test plans and test cases.
• Manage end-to-end testing activities.
• Collaborate with team members to address project risks.

Skills

ETL Testing

SQL Scripting

Automation

Communication Skills

Python

Data Testing

Tools

Azure Data Services

Data Factory

Databricks

Synapse

Cosmos DB

Data Lake

Job description

Job Title

ETL Test Lead

Get The Future You Want!

Choosing Capgemini means choosing a company where you will be empowered to shape your career in the way you'd like, where you'll be supported and inspired by a collaborative community of colleagues around the world, and where you'll be able to reimagine what's possible. Join us and help the world's leading organizations unlock the value of technology and build a more sustainable, more inclusive world.

Your Role

• Develop and execute Test Plans, Test Cases for Manual, ETL, and Visualization projects.
• Publish test results and track defects through the QA lifecycle.
• Collaborate with Test Leads, BAs, Designers, and Developers to address issues and risks.
• Create and maintain testing artifacts in alignment with QA processes.
• Manage end-to-end execution of testing activities across project phases.
• Take ownership of test automation initiatives.
• Ensure adherence to Quality Assurance processes including planning, testing, defect reporting, and resolution.
• Work within Agile development methodologies, contributing to sprints and ceremonies.

Your Profile

• Strong expertise in ETL and Data Warehouse (DW) testing, including ELT processes.
• Proficient in SQL scripting, writing complex queries, and test script development.
• Experience with structured and unstructured data testing.
• Hands-on knowledge of Azure data services like Data Factory, Databricks, Synapse, Cosmos DB, and Data Lake.
• Familiarity with data testing automation tools and frameworks.
• Domain knowledge in Insurance is a plus.
• Skilled in Python and PySpark for scripting and automation.
• Excellent written and verbal communication skills for effective collaboration.

About Capgemini

Capgemini is a global business and technology transformation partner, helping organizations to accelerate their dual transition to a digital and sustainable world while creating tangible impact for enterprises and society. It is a responsible and diverse group of 340,000 team members in more than fifty countries. With its strong over 55-year heritage, Capgemini is trusted by its clients to unlock the value of technology to address the entire breadth of their business needs. It delivers end-to-end services and solutions leveraging strengths from strategy and design to engineering, all fuelled by its market-leading capabilities in AI, cloud, and data, combined with its deep industry expertise and partner ecosystem. The Group reported 2023 global revenues of €22.5 billion.

Get The Future You Want | www.capgemini.com