Find a job 
Featured Companies 
Featured Universities 
For Companies At a Glance
- Tasks: Lead testing for ETL and data projects, ensuring quality and collaboration.
- Company: Capgemini is a global leader in tech transformation, driving digital and sustainable change.
- Benefits: Enjoy a supportive community, career growth opportunities, and a diverse work environment.
- Why this job: Join a mission-driven team that values innovation and social impact in technology.
- Qualifications: Expertise in ETL testing, SQL, Azure services, and strong communication skills required.
- Other info: Experience in the insurance domain and knowledge of automation tools is a plus.
The predicted salary is between 48000 - 72000 £ per year.
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.
ETL Test Lead | London, UK employer: Capgemini
Contact Detail:
Capgemini Recruiting Team
StudySmarter Expert Advice 🤫
We think this is how you could land ETL Test Lead | London, UK
✨Tip Number 1
Familiarise yourself with the specific ETL tools and technologies mentioned in the job description, such as Azure Data Factory and Databricks. Having hands-on experience or even a project to showcase your skills with these tools can set you apart from other candidates.
✨Tip Number 2
Brush up on your SQL skills, especially complex queries, as this is crucial for the role. Consider creating a portfolio of sample queries or testing scenarios that demonstrate your proficiency, which you can discuss during interviews.
✨Tip Number 3
Network with professionals in the data testing field, particularly those who work with Capgemini or similar companies. Engaging in relevant online forums or LinkedIn groups can provide insights into the company culture and expectations, which can be beneficial during your application process.
✨Tip Number 4
Prepare to discuss your experience with Agile methodologies, as this is a key aspect of the role. Be ready to share examples of how you've contributed to sprints and ceremonies in past projects, highlighting your collaborative skills.
We think you need these skills to ace ETL Test Lead | London, UK
Some tips for your application 🫡
Understand the Role: Before applying, make sure you fully understand the responsibilities of the ETL Test Lead position. Familiarise yourself with the key skills required, such as expertise in ETL and Data Warehouse testing, SQL scripting, and familiarity with Azure data services.
Tailor Your CV: Customise your CV to highlight relevant experience and skills that align with the job description. Emphasise your expertise in ETL processes, data testing automation tools, and any experience you have in Agile methodologies.
Craft a Compelling Cover Letter: Write a cover letter that showcases your passion for the role and the company. Mention specific projects or experiences that demonstrate your ability to manage testing activities and collaborate effectively with teams.
Proofread Your Application: Before submitting, carefully proofread your application materials. Check for any spelling or grammatical errors, and ensure that all information is clear and concise. A polished application reflects your attention to detail.
How to prepare for a job interview at Capgemini
✨Showcase Your ETL Expertise
Make sure to highlight your strong expertise in ETL and Data Warehouse testing during the interview. Be prepared to discuss specific projects where you developed and executed test plans, as well as any challenges you faced and how you overcame them.
✨Demonstrate SQL Proficiency
Since proficiency in SQL scripting is crucial for this role, be ready to showcase your ability to write complex queries. You might even be asked to solve a SQL problem on the spot, so brush up on your skills beforehand.
✨Familiarise Yourself with Azure Services
Capgemini values hands-on knowledge of Azure data services. Familiarise yourself with tools like Data Factory, Databricks, and Synapse, and be prepared to discuss how you've used these technologies in past projects.
✨Communicate Effectively
Excellent written and verbal communication skills are essential for collaboration. Practice articulating your thoughts clearly and concisely, especially when discussing technical concepts or past experiences related to testing and automation.
