Job Title: Data Engineer
About Us
“Capco, a Wipro company, is a global technology and management consulting firm. Awarded with Consultancy of the year in the British Bank Award and has been ranked Top 100 Best Companies for Women in India 2022 by Avtar & Seramount. With our presence across 32 cities across globe, we support 100+ clients across banking, financial and Energy sectors. We are recognized for our deep transformation execution and delivery.
WHY JOIN CAPCO?
You will work on engaging projects with the largest international and local banks, insurance companies, payment service providers and other key players in the industry. The projects that will transform the financial services industry.
MAKE AN IMPACT
Innovative thinking, delivery excellence and thought leadership to help our clients transform their business. Together with our clients and industry partners, we deliver disruptive work that is changing energy and financial services.
#BEYOURSELFATWORK
Capco has a tolerant, open culture that values diversity, inclusivity, and creativity.
CAREER ADVANCEMENT
With no forced hierarchy at Capco, everyone has the opportunity to grow as we grow, taking their career into their own hands.
DIVERSITY & INCLUSION
We believe that diversity of people and perspective gives us a competitive advantage.
MAKE AN IMPACT
Role Description
Experience : 10-12 Years
Job Location : Bangalore/Pune/Hyderabad
Notice Period: 0 - 30 days
JD:
Role :
Key Responsibilities
· 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 robust data models and schema designs aligned to trade lifecycle (front-to-back processing).
· Onboard and integrate DTCC data sources, including RTTM and Settlement Web, into a Unified Trade Record (UTR) schema.
· Design and implement ingestion frameworks using messaging systems (MQ) and API-based data extraction.
· Process and normalize financial messages, including ISO 15022 formats.
· Populate and maintain Trade Exceptions databases, ensuring accuracy and consistency of exception workflows.
· Collaborate with business stakeholders (operations, reconciliation, settlements teams) to align data structures with business processes.
· Optimize SQL Server queries, indexing strategies, and database performance.
· Work with AWS cloud-native data services (e.g., S3, EKS (Kubernetes/Docker), 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.
Required Skills & Qualifications
· 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.
· Expertise in data modeling and schema design, particularly 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 (e.g., IBM MQ, Kafka) and REST APIs.
· Advanced SQL skills with strong experience in SQL Server (performance tuning, indexing, stored procedures).
· Experience with AWS cloud-native data platforms and services.
· Strong analytical, debugging, and problem-solving skills.
Preferred Qualifications
· Experience with unified data models such as Unified Trade Record (UTR) and Schema development and Trade Exceptions management experience.
· Familiarity with data governance, lineage, and cataloging tools.
· Experience with real-time or near-real-time data processing frameworks.
· Knowledge of regulatory reporting and compliance requirements in capital markets.
· Knowing FIX messages and processing FxML messages will be an add-on experience.
· Prior consulting or client-facing experience.
Soft Skills
· Excellent communication and stakeholder management skills.
· Strong attention to detail and data accuracy.
· Ability to work independently and in collaborative environments.
· Proactive approach to problem-solving and continuous improvement.
If you are keen to join us, you will be part of an organization that values your contributions, recognizes your potential, and provides ample opportunities for growth. For more information, visit www.capco.com. Follow us on Twitter, Facebook, LinkedIn, and YouTube.
Skills Required
- 10+ years experience in data engineering with capital markets focus
- Deep understanding of trade lifecycle (execution, clearing, settlement, reconciliation)
- 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 (e.g., IBM MQ, Kafka) and REST APIs
- Advanced SQL skills and SQL Server performance tuning, indexing, stored procedures
- Experience with AWS cloud-native data platforms and services (S3, EKS, RDS)
- Strong experience with ETL/ELT frameworks and large-scale data processing
- Expertise in data modeling and schema design for trade and transaction data
- Strong analytical, debugging, and problem-solving skills; stakeholder management
- Experience with Unified Trade Record (UTR) schema development and Trade Exceptions management
- Familiarity with data governance, lineage, and cataloging tools
- Experience with real-time or near-real-time data processing frameworks
- Knowledge of regulatory reporting and compliance requirements in capital markets
- Experience processing FIX messages and FxML (add-on)
- Prior consulting or client-facing experience
What the Team is Saying
Capco Compensation & Benefits Highlights
-
Healthcare Strength — Health, dental, and vision coverage are described as solid with low copays and a good variety of choices, complemented by mental‑health resources, an EAP, and wellbeing events. Company materials emphasize global availability of these supports.
-
Parental & Family Support — Enhanced maternity, paternity, adoption, and shared parental leave are highlighted, with several months of maternity leave noted in the U.S. in some accounts. Additional paid leave is called out for life events such as pregnancy loss, fertility treatment, menopause, and bereavement.
-
Wellbeing & Lifestyle Benefits — A global wellbeing program, coaching/mentoring, mental‑health initiatives, and wellness reimbursements (e.g., gym, fitness) are positioned as core parts of the offering. Flexible working is emphasized alongside regionally tailored wellbeing events.
Capco Insights
What We Do
Capco, a Wipro company, is a global management and technology consultancy specializing in driving transformation in the energy and financial services industries. Capco operates at the intersection of business and technology by combining innovative thinking with unrivalled industry knowledge to fast-track digital initiatives for banking and payments, capital markets, wealth and asset management, insurance, and the energy sector. Capco’s cutting edge ingenuity is brought to life through its award-winning Be Yourself At Work culture and diverse talent. TRUSTED ADVISORS - Our collaborative and entrepreneurial approach position us as trusted long-term partners to our clients. DEEP EXPERTISE - Clients look to us for clear guidance, proven expertise, and the support they need to set their companies up for success. DISRUPTIVE SOLUTIONS- We do not provide off -the-shelf answers to clients’ challenges. Instead, we work in close collaboration to understand the issues, and craft disruptive, bespoke solutions. ACCOUNTABILITY AND OWNERSHIP - We recognize every client has distinct needs and expectations, and we take ownership and accountability for the solutions we design, build, and deliver.
Why Work With Us
We support and encourage an inclusive culture, entrepreneurial outlook and independent thinking. Capco is not about organizational charts and rigid hierarchies – we want all employees to feel that Capco is their firm to own and run. We believe diversity powers innovation. Be Yourself At Work (#BYAW) is an integral and underlying part of our culture
Gallery
Capco Offices
Hybrid Workspace
Employees engage in a combination of remote and on-site work.
