Ab Initio Data Integration Architect

TN United Kingdom; Birmingham; Hybrid; GBP 50,000 - 90,000; Full time

Job description

Social network you want to login/join with:

Ab Initio Data Integration Architect, Birmingham

Client: Capgemini

Location: Birmingham, United Kingdom

Job Category: Other

EU work permit required: Yes

Job Reference:

479e0a04b01a

Job Views:

5

Posted:

24.04.2025

Expiry Date:

08.06.2025

Job Description:

The Job You're Considering

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 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.

Hybrid working: The places that you work from day to day will vary according to your role, your needs, and those of the business; it will be a blend of Company offices, client sites, and your home; noting that you will be unable to work at home 100% of the time.

If you are successfully offered this position, you will go through a series of pre-employment checks, including: identity, nationality (single or dual) or immigration status, employment history going back 3 continuous years, and unspent criminal record check (known as Disclosure and Barring Service).

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, analyze 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.

You can bring your whole self to work. At Capgemini, equity, diversity, and inclusion is part of everyday life, and will be part of your working reality. We have built an inclusive and welcoming environment for everyone.

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. When you join Capgemini, you’ll join a thriving company and become part of a collective of free-thinkers, entrepreneurs, and industry experts. We 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. You’ll use your skills to help our clients leverage technology to innovate and grow their business. So, it might not always be easy, but making the world a better place rarely is.