Ab Initio Data Integration Architect

Capgemini; London; Hybrid; GBP 60,000 - 100,000; Full time

Job summary

An established industry player seeks a talented Ab Initio Data Integration Architect to join their dynamic team. This role focuses on delivering data migration and integration projects, collaborating with clients to design effective solutions using modern ETL tools and cloud technologies. You will have the chance to work in a hybrid environment, balancing office and remote work, while leveraging your skills in Ab Initio, SQL, and cloud services. Join a company that values innovation and offers extensive training opportunities, allowing you to grow your career while contributing to impactful projects that drive business transformation.

Benefits

Flexible working arrangements

Training and development opportunities

Certifications from AWS and Microsoft

Positive work-life balance

Qualifications

• Experience with Ab Initio and modern ETL tools.
• Strong SQL proficiency and data extraction skills.
• Knowledge of cloud platforms for data solutions.

Responsibilities

• Advise on Data Migration and Integration programs.
• Analyze and assess Data Quality and recommend improvements.
• Develop solutions using Ab Initio and cloud services.

Skills

Ab Initio

SQL

ETL Tools

Cloud Services (AWS, Azure, Google Cloud)

Data Migration

Data Quality Assessment

Kubernetes

Education

Bachelor's Degree in Computer Science or related field

Tools

Informatica

Talend

DataStage

Job description

Join to apply for the Ab Initio Data Integration Architect role at Capgemini.

3 weeks ago Be among the first 25 applicants.

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 topics, including Information Strategy, Governance, Master Data Management, Data Architecture, Data Migration, and Lifecycle Management. We assist our clients in building enterprise-class data platforms to advance their big data and insights journey. Our team primarily works with leading software vendors like SAP, Informatica, IBM, and Oracle, focusing on client requirements and industry best practices.

Hybrid Working

This role offers a blend of working from company offices, client sites, and your home, depending on role needs and personal circumstances. Note that remote working 100% of the time is not possible.

Pre-employment Checks

If offered the position, you will undergo 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, along with scripting experience across multiple technologies. You will have opportunities to grow and take on responsibilities in a challenging, meritocratic environment.

What You’ll Do

• Advise clients on building and managing 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.
• Migrate Ab Initio graphs to run on Kubernetes containers.
• Coordinate with offshore and nearshore teams for project delivery.
• Design orchestration for real-time graphs with restart and logging capabilities.
• Enhance ETL frameworks and processes.
• Understand project requirements from a program perspective.
• Collaborate with clients to craft functional and technical solutions.
• Work with functional and technical teams to 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. Strong understanding of Ab Initio concepts like checkpoints, parallelism, and dynamic layouts. Knowledge of cloud offerings, storage, and compute options for designing Ab Initio platforms on cloud. Experience in extracting data from various sources (databases, XML, flat files, Excel, queues). Proficiency in SQL queries, functions, and procedures on platforms like Big Data, Oracle, SQL Server, ERP solutions, and cloud services. Additional useful tools include Informatica, Talend, DataStage, or similar.

Security Clearance

This role requires obtaining Security Check (SC) clearance, which involves residence in the UK for the past 5 years and other criteria. You will be asked about your eligibility during recruitment, and some positions may require UK citizenship.

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

Capgemini promotes a positive work-life balance with flexible, hybrid working arrangements. You will have access to extensive training and development opportunities, including certifications from AWS, Microsoft, Harvard ManageMentor, and cybersecurity qualifications.

Why Consider Capgemini

Join a company committed to sustainable and inclusive growth, working with industry experts to innovate with technology. You will gain valuable experience, build skills, and help clients leverage technology for growth and transformation, contributing to a better world.

About Capgemini

Capgemini is a global leader in business and technology transformation, with over 55 years of experience and more than 340,000 employees in 50+ countries. It specializes in AI, generative AI, cloud, and data, delivering end-to-end solutions to unlock business value.