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