Ab Initio Data Integration Architect

Jobleads
Woking
2 months ago
Create job alert

The Data Management practice within the Insights and Data business unit of Capgemini is a global practice involved on a broad range of business and IT focused topics from Information Strategy, Governance, Master Data Management, Data Architecture, Data Migration and Lifecycle Management. We help our clients build an enterprise class data platform that allows them to move ahead in their journey of big data and insights. Primarily working with leading software vendors like SAP, Informatica, IBM, Oracle et al, the team are first and foremost Consultants, putting client requirements and industry best practice at the heart of delivery.

Your Role

As an ETL Specialist your primary focus would be the technical delivery of migration and integration projects for our clients. Our ETL Specialists work closely with the project and client teams to understand the requirements, analyse source and target data architecture and systems, propose the most effective solution and work with a team of experts to deliver.
We are looking for our ETL Specialists to bring in the knowledge of new age ETL tools that work with Big Data and Cloud Computing environments and who have a broad range of scripting experience with multiple technologies. You will be working within the Data Management, Data Warehousing, Big Data and Analytics practices alongside some of the top experts in the country, on some of the largest and most complex client engagements across a variety of industry sectors. You will be given the opportunity to grow and take on responsibility from day one in a challenging but rewarding and meritocratic environment.

What you’ll do:

  1. Advise clients on how to build and run an effective Data Migration/Integration program, using industry best practices
  2. Analysis of Source and Target systems
  3. Analysis of Data Quality and advise on how to improve areas of concern
  4. Develop solutions using Ab Initio and cloud-based services like AWS, Azure, or Google Cloud for data storage and processing
  5. Design the new Ab Initio platform on Cloud
  6. Modify and migrate Ab Initio graphs on VMs to run on Kubernetes containers
  7. Work with offshore nearshore teams to execute the delivery of the project
  8. Design Ab Initio orchestration for real time graphs restart ability and logging
  9. Develop, set up or improve the ETL frameworks and process
  10. Understand the requirements from a programme perspective
  11. Work closely with the client for crafting the functional and technical solution
  12. Work with functional and technical teams
  13. Plan, coordinate, and supervise all activities related to the project implementation

Your Skills and Experience

Experience with Ab Initio:
• Extensive experience working with Ab Initio Co>OP, GDE, express>It, Metadata hub, Authorisation Gateway software.
• Good understanding of Ab Initio concepts like checkpoints, parallelism, graph dynamic layouts
• Continuous Flows in Ab Initio
• Good knowledge of the Google Cloud Platform offerings, storage options and compute options to design a new Ab Initio platform on Cloud.

Extracting data from data sources:
• Databases
• XML
• Flat files
• Excel
• Queues and Topics

Writing SQL queries, functions, procedures (in any of the following - in order of preference):
• Big Data Platforms
• Oracle
• SQL Server
• ERP Solutions
• AWS, Azure, or Google Cloud

What would be useful is experience in any of the following tools:
• Informatica
• Talend
• DataStage
• Similar

Your Security Clearance

To be successfully appointed to this role, it is a requirement to obtain Security Check (SC) clearance.
To obtain SC clearance, the successful applicant must have resided continuously within the United Kingdom for the last 5 years, along with other criteria and requirements.
Throughout the recruitment process, you will be asked questions about your security clearance eligibility such as, but not limited to, country of residence and nationality.
Some posts are restricted to sole UK Nationals for security reasons; therefore, you may be asked about your citizenship in the application process.

What Does 'Get The Future You Want' Mean To You?

You will be encouraged to have a positive work-life balance. Our hybrid-first way of working means we embed hybrid working in all that we do and make flexible working arrangements the day-to-day reality for our people. All UK employees are eligible to request flexible working arrangements.

You will be empowered to explore, innovate, and progress. You will benefit from Capgemini’s ‘learning for life’ mindset, meaning you will have countless training and development opportunities from think tanks to hackathons, and access to 250,000 courses with numerous external certifications from AWS, Microsoft, Harvard ManageMentor, Cybersecurity qualifications and much more.

Why You Should Consider Capgemini

Growing clients’ businesses while building a more sustainable, more inclusive future is a tough ask. But when you join Capgemini, you join a thriving company and become part of a diverse collective of free-thinkers, entrepreneurs and industry experts. A powerful source of energy that drives us all to find new ways technology can help us reimagine what’s possible. It’s why, together, we seek out opportunities that will transform the world’s leading businesses. And it’s how you’ll gain the experiences and connections you need to shape your future. By learning from each other every day, sharing knowledge and always pushing yourself to do better, you’ll build the skills you want. And you’ll use them to help our clients leverage technology to grow their business and give innovation that human touch the world needs. So, it might not always be easy, but making the world a better place rarely is.

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 over 360,000 team members in more than 50 countries. With its strong 55-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, fuelled by the fast evolving and innovative world of cloud, data, AI, connectivity, software, digital engineering and platforms. The Group reported 2023 global revenues of €22.5 billion.

When you join Capgemini, you don’t just start a new job. You become part of something bigger.

#J-18808-Ljbffr

Related Jobs

View all jobs

Senior Product Engineer - React Native/React London orRemote (UK)

Senior Product Manager, Demand (Basé à London)

CRM and Data Manager (Italian-speaking)

Experimentation Lead

Demand Generation Specialist

Principal / Lead Data Scientist (Basé à London)

Get the latest insights and jobs direct. Sign up for our newsletter.

By subscribing you agree to our privacy policy and terms of service.

Industry Insights

Discover insightful articles, industry insights, expert tips, and curated resources.

Contract vs Permanent Data Science Jobs: Which Pays Better in 2025?

Data science sits at the intersection of statistics, machine learning, and domain expertise, driving crucial business decisions in almost every sector. As UK organisations leverage AI for predictive analytics, customer insights, and automation, data scientists have become some of the most in-demand professionals in the tech job market. By 2025, data scientists with expertise in deep learning, natural language processing (NLP), and MLOps are commanding top-tier compensation packages. However, deciding whether to become a day‑rate contractor, a fixed-term contract (FTC) employee, or a permanent member of an organisation can be challenging. Each path offers a unique blend of earning potential, career progression, and work–life balance. This guide will walk you through the UK data science job market in 2025, examine the differences between these three employment models, present sample take‑home pay scenarios, and offer strategic considerations to help you determine the best fit for your career.

Data Science Jobs for Non‑Technical Professionals: Where Do You Fit In?

Beyond Jupyter Notebooks Ask most people what a data‑science career looks like and they’ll picture Python wizards optimising XGBoost hyper‑parameters. The truth? Britain’s data‑driven firms need storytellers, strategists, ethicists and project leaders every bit as much as they need statisticians. The Open Data Institute’s UK Data Skills Gap 2024 places demand for non‑technical data talent at 42 % of all data‑science vacancies—roles focused on turning model outputs into business value and trustworthy decisions. This guide highlights the fastest‑growing non‑coding roles, the transferable skills many professionals already have, and a 90‑day action plan to land a data‑science job—no pandas required.

McKinsey & Company Data‑Science Jobs in 2025: Your Complete UK Guide to Turning Data into Impact

When CEOs need to unlock billion‑pound efficiencies or launch AI‑first products, they often call McKinsey & Company. What many graduates don’t realise is that behind every famous strategy deck sits a global network of data scientists, engineers and AI practitioners—unified under QuantumBlack, AI by McKinsey. From optimising Formula One pit stops to reducing NHS wait times, McKinsey’s analytics teams turn messy data into operational gold. With the launch of the McKinsey AI Studio in late 2024 and sustained demand for GenAI strategy, the firm is growing its UK analytics headcount faster than ever. The McKinsey careers portal lists 350+ open analytics roles worldwide, over 120 in the UK, spanning data science, machine‑learning engineering, data engineering, product management and AI consulting. Whether you love Python notebooks, Airflow DAGs, or white‑boarding an LLM governance roadmap for a FTSE 100 board, this guide details how to land a McKinsey data‑science job in 2025.