Capco

Capco is a global business and technology consultancy, part of Wipro, dedicated to the financial services and energy industries. With a focus on digital transformation, Capco delivers end-to-end data-driven solutions for banking, payments, capital mark...

Internet Software & Services

Information Technology

5K-10K (7000)

Founded 1998

19 open positions

Links

View All Jobs

Data Engineer

11 hours, 28 minutes ago

India

Senior

Data Engineer

Software Development

AWS Docker Kafka Kubernetes REST API SQL SQL Server

Apply Now

Capco

Internet Software & Services

5K-10K

Founded 1998

View All Jobs 19

Description

Design, build, and maintain scalable cloud-native data pipelines for trade lifecycle data processing.
Develop and optimize ETL/ELT workflows for ingesting, transforming, and loading high-volume financial datasets.
Create and maintain data models and schema designs aligned to front-to-back trade lifecycle processing.
Onboard and integrate DTCC data sources, including RTTM and Settlement Web, into a Unified Trade Record schema.
Design ingestion frameworks using messaging systems and API-based data extraction.
Process and normalize financial messages, including ISO 15022 formats.
Populate and maintain Trade Exceptions databases and ensure accuracy across exception workflows.
Collaborate with operations, reconciliation, and settlements stakeholders to align data structures with business processes.
Optimize SQL Server queries, indexing strategies, and overall database performance.
Work with AWS cloud-native services such as S3, EKS, and RDS for scalable data solutions.
Ensure data quality, lineage, governance, and observability across pipelines.
Troubleshoot complex data issues and provide analytical insights into trade discrepancies and exceptions.

Requirements

5-8 years of experience listed in the role description.
10+ years of experience in data engineering with a strong focus on capital markets.
Deep understanding of the trade lifecycle, including execution, clearing, settlement, and reconciliation.
Strong experience with ETL/ELT frameworks and large-scale data processing.
Expertise in data modeling and schema design for trade and transaction data.
Hands-on experience with DTCC data sources, especially RTTM and Settlement Web.
Strong knowledge of ISO 15022 message formats and financial data standards.
Experience building ingestion frameworks using MQ tools such as IBM MQ or Kafka and REST APIs.
Advanced SQL skills with strong experience in SQL Server, including performance tuning, indexing, and stored procedures.
Experience with AWS cloud-native data platforms and services.
Strong analytical, debugging, and problem-solving skills.
Experience with Unified Trade Record (UTR), trade exceptions management, or schema development is preferred.
Familiarity with data governance, lineage, and cataloging tools is preferred.
Experience with real-time or near-real-time data processing frameworks is preferred.
Knowledge of regulatory reporting and compliance requirements in capital markets is preferred.
Knowledge of FIX messages and FxML processing is an added advantage.
Prior consulting or client-facing experience is preferred.
Ability to work independently and collaboratively, with excellent communication and stakeholder management skills.
Strong attention to detail and a proactive approach to problem-solving and continuous improvement.
Notice period of 0-30 days.
Job location: Bangalore, Pune, or Hyderabad.

Benefits

Opportunity to work on engaging projects with major international and local banks, insurers, and payment service providers.
Exposure to transformative work in financial services and energy sectors.
Open, inclusive, and diverse workplace culture.
Career growth opportunities with no forced hierarchy.
Organization that values contributions and recognizes individual potential.
Presence across 32 cities globally and work with 100+ clients.

Interested in this position?

Apply directly on the company website

Apply Now

Similar Roles

Data Engineering Intern (Fall 2026)

Hone Health 11-50 Health Care Providers & Services

Hone is seeking a Data Engineering Intern to support the design, development, and maintenance of data systems and pipelines for a remote-first online medical clinic focused on healthcare and longevity.

Anywhere Internship Entry Level Data Engineer

Up to $0k

Apache Spark Azure CI/CD dbt Git GitHub Python SQL

11 hours, 13 minutes ago

Apply

11 hours, 13 minutes ago

Senior Python Data Scraping Engineer (Freelance)

Mindrift.ai: Be the “I” in AI Internet Software & Services

Mindrift is hiring a Senior Python Data Scraping Engineer for a part-time remote freelance Tendem project focused on building and validating accurate data extraction workflows for complex web sources within a hybrid AI + human system.

Poland Part-time Senior Backend Engineer Data Engineer

Up to $83k

AJAX AWS Docker GitHub JavaScript JSON LLM Python Selenium

11 hours, 13 minutes ago

Apply

11 hours, 13 minutes ago

Senior Python Data Scraping Engineer (Freelance)

Mindrift.ai: Be the “I” in AI Internet Software & Services

Mindrift is seeking a Senior Python Data Scraping Engineer for the Tendem project to support specialized web data extraction and validation within a hybrid AI plus human workflow.