Ab Initio Data Integration Architect

Capgemini
London
3 weeks 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

Security Engineer (12 Month FTC)

Cyber Security Consultant

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.

10 Must-Read Cyber Security Books for UK Professionals: Boost Your Career and Stay Ahead of Threats

With rapid advancements in digital infrastructure, cloud computing, and the Internet of Things (IoT), cyber threats continue to evolve at lightning speed. For organisations across the UK—and globally—robust cyber security is no longer optional: It’s a strategic imperative. From healthcare and finance to government agencies and tech start-ups, every sector needs skilled professionals to safeguard critical data and protect users. If you’re looking to break into or advance within the cyber security industry, staying updated on the latest techniques, threat landscapes, and defence strategies is paramount. One of the best ways to build and sharpen your expertise is by reading authoritative, high-quality books that combine foundational knowledge with cutting-edge insights. In this guide, we’ve compiled a list of ten books that cater to various skill levels, spanning ethical hacking and threat intelligence to secure software development and cryptography. By diving into these resources, you’ll fortify your understanding of cyber security fundamentals, explore hands-on techniques for defending systems, and gain the strategic perspective needed to excel in roles throughout the UK’s thriving cyber security landscape.

Navigating Cybersecurity Career Fairs Like a Pro: Preparing Your Pitch, Questions to Ask, and Follow-Up Strategies to Stand Out

In a world where digital threats are escalating and online infrastructure underpins nearly every aspect of our personal and professional lives, cybersecurity has swiftly become one of the most sought-after career fields. Demand for skilled cybersecurity professionals outstrips supply, both in the UK and globally. From ethical hackers and penetration testers to governance, risk, and compliance (GRC) specialists, the opportunities are extensive—and lucrative. Amidst this surge in demand, cybersecurity career fairs provide an invaluable chance to meet potential employers face-to-face, gain industry insights, and make connections that can accelerate your career trajectory. Unlike applying to countless jobs online, these events bring companies, security leaders, and aspiring candidates together under one roof. When approached with the right strategy, a single conversation at a cybersecurity fair can open the door to your dream job. In this comprehensive guide, we’ll explore how to prepare thoroughly, engage confidently, and follow up effectively after a cybersecurity career fair. By incorporating these insights into your approach, you’ll stand out from the crowd and maximise your chances of securing the perfect role in this fast-growing field.

Common Pitfalls Cyber Security Job Seekers Face and How to Avoid Them

The cyber security industry in the UK and worldwide is experiencing rapid growth. With cyber attacks growing in sophistication and frequency, organisations are investing more resources than ever into defending their digital assets. From penetration testers and threat analysts to security architects and compliance officers, cyber security professionals are in high demand across a variety of sectors—including finance, healthcare, government, and retail. Yet, in spite of this high demand, the process of landing a cyber security role can be more challenging than many candidates anticipate. The stakes are high: prospective employers entrust cyber professionals with their most sensitive data, their compliance posture, and often their core business operations. Therefore, they’re looking for candidates who can demonstrate not just technical know-how, but also excellent communication, adaptability, and an awareness of the broader business context. In this article, we’ll explore the most common pitfalls that cyber security job seekers face, especially in the UK market, and how to avoid them. Whether you’re a recent graduate, a professional transitioning from a different field, or an experienced practitioner aiming for a senior role, these insights will help you stand out and secure the opportunities that fit your skill set and career goals.