Kondor+ Integration, Data & Database Consultant
Over deze vacature
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