Ab Initio Data Integration Architect

Capgemini
Birmingham
2 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

Ab Initio Data Integration Architect

Ab Initio Data Integration Architect

Senior Solution Architect

Senior Data Consultant - Data Excellence

Data Scientist I, Growth Analytics

Senior Data Scientist - Marketing Technology

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.

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

Data science has taken centre stage in the modern workplace. Organisations rely on data-driven insights to shape everything from product innovation and customer experience to operational efficiency and strategic planning. As a result, there is a growing need for skilled data scientists who can analyse large volumes of data, build predictive models, communicate findings effectively, and collaborate cross-functionally. If you are looking to accelerate your data science career—or even land your first role—attending data science career fairs can be a game-changer. Unlike traditional online applications, face-to-face interactions let you showcase your personality, passion, and communication skills in addition to your technical expertise. However, to stand out in a busy environment, you need a clear strategy: from polishing your personal pitch and asking thoughtful questions to following up with a memorable message. In this article, we’ll guide you through every step of making a strong impression at data science career fairs in the UK and beyond.

Common Pitfalls Data Science Job Seekers Face and How to Avoid Them

Data science has become a linchpin for decision-making and innovation across countless industries, from finance and healthcare to tech and retail. The demand for data scientists in the UK continues to climb, with businesses seeking professionals who can interpret complex datasets, build predictive models, and communicate actionable insights. Despite this high demand, the job market can be extremely competitive—and many applicants unknowingly fall into avoidable traps. Whether you’re an aspiring data scientist fresh out of university, a professional transitioning from a quantitative role, or a seasoned analyst looking to expand your skill set, it’s crucial to navigate your job search effectively. In this article, we explore the most common pitfalls data science job seekers face and provide pragmatic advice to help you stand out. By refining your CV, portfolio, interview strategies, and communication skills, you can significantly increase your chances of landing a rewarding data science role. If you’re looking for your next data science job in the UK, don’t forget to explore the listings at Data Science Jobs. Read on to discover how to avoid critical mistakes and position yourself for success.

Career Paths in Data Science: From Entry-Level Analysis to Leadership and Beyond

Data is the lifeblood of modern business, and Data Scientists are the experts who turn raw information into strategic insights. From building recommendation engines to predicting market trends, the impact of data science extends across virtually every industry—finance, healthcare, retail, manufacturing, and beyond. In the UK, data-driven decision-making is critical to remaining competitive in a global market, making data science one of the most sought-after career paths. But how does one launch a career in data science, and how can professionals progress from entry-level analysts to senior leadership roles? In this comprehensive guide, we’ll explore the typical career trajectory, from junior data scientist to chief data officer, discussing the key skills, qualifications, and strategic moves you need to succeed. Whether you’re a recent graduate, transitioning from another technical field, or an experienced data scientist aiming for management, you’ll find actionable insights on forging a successful career in the UK data science sector.