System Integration Engineer

Make it real:

Capgemini Global Insights & Data business line is a market leader in the data, platform, and analytics across all regions and cross many sectors (including financial services, consumer products, manufacturing & life sciences). Our offerings include end-2-end data integration to cloud platform, complete suite of AI engineering capabilities and a category of sector-based advanced analytics / AI solutions.

Your Role:

• Analyze source-system integration requirements and define data ingestion patterns into Snowflake.
• Build and support integrations from portfolio management systems, accounting platforms, investment systems, market data sources, file repositories, APIs, databases, and vendor platforms.
• Design ingestion workflows for batch, scheduled, file-based, API-based, and database-driven data feeds.
• Support secure connectivity, authentication, data transfer, encryption, and monitoring requirements.
• Work with Snowflake Data Engineers to ensure source data is landed, validated, transformed, and available for downstream processing.
• Support historical data migration and backfill from legacy systems, spreadsheets, file stores, and source platforms.
• Implement data ingestion controls, error handling, logging, retry mechanisms, and reconciliation checks.
• Support data lineage and metadata capture for ingested data sets.
• Troubleshoot integration issues across systems, networks, data formats, APIs, permissions, and source availability.
• Document integration specifications, data flows, schedules, dependencies, and operational runbooks.

Your Profile:

• 5+ years of experience in system integration, data integration, ETL/ELT, API integration, or middleware implementation.
• Experience integrating financial, investment, accounting, portfolio, or market data systems.
• Experience with batch files, APIs, databases, SFTP, schedulers, ETL/ELT tools, and cloud data platforms.
• Experience with Snowflake ingestion patterns is preferred.
• Experience supporting historical data loads and data migration activities.
• Familiarity with security, encryption, access controls, logging, and monitoring.

Skills:

• Data integration and interface design
• API, file-based, and database integration
• ETL/ELT pipeline understanding
• Troubleshooting and root-cause analysis
• Secure data movement
• Source-to-target mapping support
• Documentation and operational handover

Technical:

• Snowflake
• Cloud data platform
• ETL/ELT
• Data integration
• Governance
• Reconciliation
• BI/reporting consumption

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.

About Capgemini:

Capgemini is an AI-powered global business and technology transformation partner, delivering tangible business value. We imagine the future of organisations and make it real with AI, technology and people. With our strong heritage of nearly 60 years, we are a responsible and diverse group of over 420,000 team members in more than 50 countries. We deliver end-to-end services and solutions with our deep industry expertise and strong partner ecosystem, leveraging our capabilities across strategy, technology, design, engineering and business operations. The Group reported 2025 global revenues of €22.5 billion. Make it real | www.capgemini.com