Capco

2 weeks ago

Senior Data Engineer

✓ Verified Job

Canonical indexed version, validated from employer's careers page.

Source: Company careers pageValidated by: Fursa AI

Last checked: 3 hours agoStatus: Live

Job Summary

Design, build, and maintain scalable cloud-native data pipelines for trade lifecycle processing. Develop and optimize ETL/ELT workflows for high-volume financial datasets, create robust data models aligned to front-to-back trade processing, and integrate DTCC sources (RTTM, Settlement Web) into a Unified Trade Record (UTR). Own ingestion frameworks using messaging systems and REST APIs, ensure data quality/governance/observability, and troubleshoot trade discrepancies using SQL Server and AWS services.

Location: Bengaluru, Pune, Hyderabad

Workplace: Onsite

Employment Type: Full time

Job Function: Solutions Engineering & Sales Engineering

Seniority: Mid level

Key Responsibilities

•Design, build, and maintain scalable cloud-native data pipelines for trade lifecycle data processing.
•Develop and optimize ETL/ELT workflows to ingest, transform, and load high-volume financial datasets.
•Create and maintain data models and schema designs aligned to trade lifecycle processing.
•Integrate DTCC sources (RTTM, Settlement Web) into a Unified Trade Record (UTR) schema and build ingestion frameworks using messaging systems and REST APIs.
•Ensure data quality, lineage, governance, and observability; troubleshoot data issues and support exception workflows.

Key Requirements

•10+ years of experience in data engineering with a strong focus on capital markets.
•Deep understanding of trade lifecycle (execution, clearing, settlement, reconciliation).
•Strong experience with ETL/ELT frameworks and large-scale data processing.
•Hands-on experience with DTCC data sources, especially RTTM and Settlement Web.
•Advanced SQL skills, especially SQL Server (performance tuning, indexing, stored procedures).

Experience:10-12 yearsCapital marketsFinancial services

Skills:Analytical thinkingProblem-solvingDebuggingStakeholder management

Languages:English

Tech Stack:AWSS3EKSKubernetesDockerRDSETLELTSQL ServerSQLIBM MQKafkaMQREST APIsISO 15022DTCCRTTMSettlement WebUTRMessaging systems

Company Brief

Capco

Global management and technology consultancy specializing in financial services. Capco advises banks, insurers, and capital markets firms on digital transformation, risk and compliance, technology implementation, and operational improvement, combining industry expertise with advisory and engineering capabilities.

Industry: Management Consulting

Company Size: Enterprise (1,001+ employees)

Growth: Established Company

Headquarters: London, United Kingdom

Founded: 1998

Glassdoor: 3.7

Website LinkedIn

Loading job details...

Preparing the role view and application actions.

Capco

2 weeks ago

Senior Data Engineer

✓ Verified Job

Canonical indexed version, validated from employer's careers page.

Source: Company careers pageValidated by: Fursa AI

Last checked: 3 hours agoStatus: Live

Job Summary

Location: Bengaluru, Pune, Hyderabad

Workplace: Onsite

Employment Type: Full time

Job Function: Solutions Engineering & Sales Engineering

Seniority: Mid level

Key Responsibilities

•Design, build, and maintain scalable cloud-native data pipelines for trade lifecycle data processing.
•Develop and optimize ETL/ELT workflows to ingest, transform, and load high-volume financial datasets.
•Create and maintain data models and schema designs aligned to trade lifecycle processing.
•Integrate DTCC sources (RTTM, Settlement Web) into a Unified Trade Record (UTR) schema and build ingestion frameworks using messaging systems and REST APIs.
•Ensure data quality, lineage, governance, and observability; troubleshoot data issues and support exception workflows.

Key Requirements

•10+ years of experience in data engineering with a strong focus on capital markets.
•Deep understanding of trade lifecycle (execution, clearing, settlement, reconciliation).
•Strong experience with ETL/ELT frameworks and large-scale data processing.
•Hands-on experience with DTCC data sources, especially RTTM and Settlement Web.
•Advanced SQL skills, especially SQL Server (performance tuning, indexing, stored procedures).

Experience:10-12 yearsCapital marketsFinancial services

Skills:Analytical thinkingProblem-solvingDebuggingStakeholder management

Languages:English

Tech Stack:AWSS3EKSKubernetesDockerRDSETLELTSQL ServerSQLIBM MQKafkaMQREST APIsISO 15022DTCCRTTMSettlement WebUTRMessaging systems

Company Brief

Capco

Industry: Management Consulting

Company Size: Enterprise (1,001+ employees)

Growth: Established Company

Headquarters: London, United Kingdom

Founded: 1998

Glassdoor: 3.7

Website LinkedIn