Kondor+ Integration - Data & Database Consultant

CAPCO POLAND 

*We are looking for Poland based candidate. 

At Capco Poland, we’re not just another consultancy - we’re the spark behind digital transformation in the financial world. As a global leader in technology and management consulting, we thrive on helping clients tackle the toughest challenges across banking, payments, capital markets, wealth, and asset management.

Role Purpose

The Kondor+ Integration, Data & Database Consultant will be responsible for the integration, data migration and database-related activities required as part of the Kondor+ / Fusion Kondor upgrade.

The role will analyse the existing Kondor+ integration and data landscape, assess impacts introduced by the target Kondor+ release, implement or coordinate required interface changes, support database upgrade/migration activities, and ensure the completeness and integrity of data throughout the upgrade.

The consultant will work closely with the Kondor+ Solution Architect, Technical Consultants, Functional Consultants, client DBA/infrastructure teams and downstream application owners.

Key Responsibilities

Kondor+ Integration

• Analyse the existing Kondor+ integration landscape, covering inbound and outbound interfaces.
• Assess the impact of the Kondor+ upgrade on existing interfaces, APIs, message structures, file exchanges and integration components.
• Design and implement or coordinate required modifications to Kondor+ interfaces.
• Support integration between Kondor+ and surrounding systems such as:
• Market data providers
• Electronic trading platforms
• Payment and settlement systems
• SWIFT/messaging platforms
• Core banking systems
• General Ledger and accounting platforms
• Risk and regulatory systems
• Data warehouses and reporting platforms
• Analyse and troubleshoot failed Kondor+ interfaces and data-processing issues.
• Validate end-to-end STP flows through Kondor+ and downstream applications.
• Support API, messaging, middleware and file-based integrations used by Kondor+.
• Support interface reconciliation during SIT, UAT, migration rehearsals and production cutover.

Kondor+ Data Migration & Reconciliation

• Analyse the Kondor+ data landscape and identify data impacted by the upgrade.
• Define the data migration/conversion approach together with the Kondor+ Solution Architect and functional SMEs.
• Support migration or conversion of Kondor+ static/reference and transactional data where required.
• Analyse and validate Kondor+ data structures and dependencies.
• Develop SQL queries and reconciliation controls to validate migrated/upgraded data.
• Reconcile relevant data between source and target Kondor+ environments, including:
• Trades and transactions
• Static/reference data
• Positions
• Cashflows
• Market data where applicable
• Valuations
• Accounting balances/postings
• Interface data
• Investigate and resolve data discrepancies between existing and upgraded Kondor+ environments.
• Support migration dry runs and cutover rehearsals.
• Define data validation and reconciliation criteria for production migration.
• Support post-go-live data reconciliation and hypercare.

Kondor+ Database

• Analyse the existing Kondor+ database environment and dependencies.
• Support database-related prerequisites for the Kondor+ target release.
• Support execution and validation of Kondor+ database upgrade/conversion scripts.
• Analyse Kondor+ database schemas, tables and data relationships as required for troubleshooting, integration and reconciliation.
• Develop SQL scripts and queries supporting migration, testing and reconciliation.
• Support database backup, restore and rollback activities in collaboration with the client's DBA team.
• Identify database-related performance issues affecting Kondor+ processing.
• Support performance analysis of critical Kondor+ processes, including batch and EOD processing.
• Coordinate with client DBAs on database configuration, capacity, performance and operational requirements.

Required Experience

• Strong hands-on technical experience with Kondor+ / Fusion Kondor / Finastra Kondor.
• Previous experience working on at least one Kondor+ implementation, upgrade or migration.
• Demonstrable experience with Kondor+ interfaces and integration mechanisms.
• Good understanding of the Kondor+ database/data model and data structures.
• Strong SQL skills and ability to independently interrogate and reconcile Kondor+ data.
• Experience analysing Kondor+ trade, static/reference, position and/or accounting data.
• Experience troubleshooting data and integration issues across Kondor+ and surrounding systems.
• Experience with APIs, messaging/middleware and file-based integration patterns used within Kondor environments.
• Understanding of treasury products and end-to-end trade lifecycle.
• Experience supporting SIT, UAT, migration rehearsals and production cutovers for Kondor+.

Highly Desirable

• Previous Kondor+ version upgrade experience.
• Experience migrating between different Kondor+ releases and/or technical architectures.
• Experience with the specific database technology used by the client's Kondor+ installation.
• SWIFT / ISO 20022 integration experience.
• Experience integrating Kondor+ with market data, payment/settlement, GL/accounting, risk and data warehouse platforms.
• Experience with Kondor+ APIs and modern integration patterns.
• Experience with large-volume trade/data reconciliation.
• Experience troubleshooting Kondor+ EOD/batch-processing performance.

#LI-REMOTE