Find a job 
Featured Companies 
Featured Universities 
For Companies At a Glance
- Tasks: Join us as an ETL Specialist, delivering data migration and integration projects for top clients.
- Company: Capgemini is a global leader in tech-driven business transformation with a diverse team of over 360,000.
- Benefits: Enjoy flexible working arrangements, extensive training opportunities, and a positive work-life balance.
- Why this job: Work with industry experts on complex projects while making a real impact in the tech world.
- Qualifications: Experience with Ab Initio and cloud platforms; scripting skills are a plus.
- Other info: Security clearance required; must have resided in the UK for the last 5 years.
The predicted salary is between 43200 - 72000 £ per year.
Explore our latest thought leadership, ideas, and insights on the issues that are shaping the future of business and society.
Choose a partner with intimate knowledge of your industry and first-hand experience of defining its future.
Discover our portfolio – constantly evolving to keep pace with the ever-changing needs of our clients.
Become part of a diverse collective of free-thinkers, entrepreneurs, and experts – and help us to make a difference.
See our latest news, stories from across the business, and explore our archives.
We are a global leader in partnering with companies to transform and manage their business by harnessing the power of technology.
The Data Management practice within the Insights and Data business unit of Capgemini is a global practice involved in a broad range of business and IT-focused topics, including Information Strategy, Governance, Master Data Management, Data Architecture, Data Migration, and Lifecycle Management. We help our clients build enterprise-class data platforms to advance their big data and insights journey. Working primarily with leading software vendors like SAP, Informatica, IBM, Oracle, etc., our team are consultants who prioritize client requirements and industry best practices.
Hybrid working: Your work location will vary based on your role, needs, and business requirements; it will be a blend of company offices, client sites, and your home, noting that you will not be able to work at home 100% of the time.
Successful candidates will undergo pre-employment checks, including identity, nationality or immigration status, employment history for the past 3 years, and a criminal record check (Disclosure and Barring Service).
Your Role
As an ETL Specialist, your primary focus will be the technical delivery of migration and integration projects. You will work closely with project and client teams to understand requirements, analyze data architectures, propose solutions, and collaborate with experts to deliver results. We seek candidates with knowledge of modern ETL tools compatible with Big Data and Cloud environments, and scripting experience across multiple technologies. You will work within Data Management, Data Warehousing, Big Data, and Analytics practices, engaging in complex client projects across various sectors. You will have opportunities to grow and assume responsibilities from day one in a challenging, meritocratic environment.
We promote an inclusive environment where you can bring your whole self to work. Capgemini values equity, diversity, and inclusion as part of everyday life.
What you’ll do:
- Advise clients on building and running effective Data Migration/Integration programs using industry best practices.
- Analyze Source and Target systems.
- Assess Data Quality and recommend improvements.
- Develop solutions using Ab Initio and cloud services like AWS, Azure, or Google Cloud.
- Design Ab Initio platforms on Cloud.
- Modify and migrate Ab Initio graphs to Kubernetes containers.
- Coordinate with offshore and nearshore teams for project delivery.
- Design Ab Initio orchestration for real-time graphs with restart and logging capabilities.
- Enhance ETL frameworks and processes.
- Understand program requirements and collaborate with clients to craft solutions.
- Plan and supervise project activities.
Your Skills and Experience
Experience with Ab Initio, including Co>OP, GDE, express>It, Metadata hub, and Authorization Gateway software. Good understanding of Ab Initio concepts like checkpoints, parallelism, and dynamic layouts. Knowledge of Google Cloud Platform offerings for designing cloud-based Ab Initio platforms. Experience in extracting data from various sources such as databases, XML, flat files, Excel, queues, and topics. Proficiency in SQL queries, functions, and procedures across Big Data platforms, Oracle, SQL Server, ERP solutions, and cloud providers. Useful experience with tools like Informatica, Talend, DataStage, or similar.
Your Security Clearance
Obtaining Security Check (SC) clearance is required, which involves residency in the UK for the last 5 years and other criteria. The process includes questions about your eligibility, residency, and nationality. Some roles may be restricted to UK nationals for security reasons.
What Does \’Get The Future You Want\’ Mean To You?
Capgemini promotes a positive work-life balance with flexible working arrangements, including hybrid work. You will have access to extensive training and development opportunities, including courses and certifications from AWS, Microsoft, Harvard, and others.
Why You Should Consider Capgemini
Joining Capgemini means contributing to a sustainable, inclusive future, working with industry leaders, and transforming businesses through technology. You will gain valuable experiences, build skills, and help clients innovate and grow, making a positive impact on the world.
About Capgemini
Capgemini is a global leader in business and technology transformation, with over 55 years of experience, 340,000 employees in more than 50 countries, and €22.1 billion in revenue in 2024. The company specializes in AI, generative AI, cloud, data, and industry expertise, delivering end-to-end solutions to clients worldwide.
Ref. code 164481-en_GB
Posted on 13 Feb 2025
Experience level: Experienced Professionals
Contract type: Permanent
Locations: London, Birmingham, Woking, Bristol
Business unit: I and D Global Business Line
Joining Capgemini means becoming part of a larger community dedicated to innovation and impact.
#J-18808-Ljbffr
Contact Detail:
Capgemini Recruiting Team
StudySmarter Expert Advice 🤫
We think this is how you could land Ab Initio Data Integration Architect
✨Tip Number 1
Familiarise yourself with the latest trends in ETL tools, especially those that integrate with Big Data and Cloud Computing. Being knowledgeable about platforms like AWS, Azure, and Google Cloud will give you an edge during discussions with potential employers.
✨Tip Number 2
Network with professionals in the data integration field. Attend industry meetups or webinars where you can connect with current ETL Specialists. This can lead to valuable insights and even job referrals.
✨Tip Number 3
Showcase your hands-on experience with Ab Initio and other relevant tools through personal projects or contributions to open-source initiatives. This practical experience can be a great conversation starter during interviews.
✨Tip Number 4
Prepare for technical interviews by practising problem-solving scenarios related to data migration and integration. Being able to articulate your thought process and solutions will demonstrate your expertise and confidence.
We think you need these skills to ace Ab Initio Data Integration Architect
Some tips for your application 🫡
Tailor Your CV: Make sure your CV highlights relevant experience with Ab Initio and other ETL tools mentioned in the job description. Use specific examples of projects you've worked on that align with the responsibilities outlined.
Craft a Compelling Cover Letter: In your cover letter, express your enthusiasm for the role and the company. Discuss how your skills in data integration and cloud computing can contribute to Capgemini's mission and the specific projects they undertake.
Showcase Technical Skills: Clearly list your technical skills related to Ab Initio, cloud platforms, and data extraction methods. Provide examples of how you've successfully used these skills in past roles to solve complex problems.
Highlight Soft Skills: Don't forget to mention your soft skills, such as teamwork and communication. Since the role involves working closely with clients and teams, demonstrating your ability to collaborate effectively is crucial.
How to prepare for a job interview at Capgemini
✨Know Your Ab Initio Inside Out
Make sure you have a solid understanding of Ab Initio tools and concepts. Be prepared to discuss your experience with Co>OP, GDE, and other relevant software. Highlight specific projects where you've successfully implemented these tools.
✨Demonstrate Cloud Knowledge
Since the role involves designing platforms on cloud services like AWS, Azure, or Google Cloud, brush up on your knowledge of these platforms. Be ready to explain how you've used cloud technologies in past projects and how they can enhance data integration.
✨Showcase Your ETL Expertise
Prepare to discuss your experience with ETL processes and frameworks. Provide examples of how you've improved data migration and integration programs, and be ready to suggest best practices based on your past experiences.
✨Understand the Client's Perspective
As a consultant, it's crucial to understand client needs. Think about how you can tailor your solutions to meet their specific requirements. During the interview, demonstrate your ability to analyse client challenges and propose effective solutions.
