Job Summary We are seeking an experienced Data Migration Specialist to support the successful migration of data from legacy banking systems to a modern Core Banking System (CBS) such as Temenos T24, Finacle, or Oracle FLEXCUBE. The role is responsible for end-to-end data migration activities including data extraction, cleansing, transformation, validation, reconciliation, and migration execution, ensuring full data integrity, regulatory compliance, and minimal business disruption during go-live. Key Responsibilities CBS Data Migration Strategy & Planning Define and implement the data migration strategy aligned with CBS implementation timelines Identify all banking data domains, including: Customer Information (CIF) Accounts (CASA, Loans, Fixed Deposits) Transactions Collateral & Securities General Ledger (GL) Develop migration plans, cutover strategies, and rollback procedures Participate in cutover planning and dress rehearsals Data Mapping & Functional Alignment Develop detailed source-to-target data mapping documents for CBS Translate banking product configurations into migration logic Align legacy system structures with CBS data models (e.g., CIF, account hierarchies) Work closely with Business Analysts and product teams to validate mapping rules Data Extraction, Cleansing & Transformation (ETL) Extract data from legacy banking systems and databases Perform data cleansing, including: Duplicate removal (e.g., duplicate CIFs) Data standardization (names, IDs, formats) Handling missing or inconsistent records Develop ETL processes using tools such as Informatica PowerCenter, Talend, or Microsoft SQL Server Integration Services (SSIS) Ensure correct transformation of: Interest calculations Account balances Transaction histories Data Validation, Reconciliation & Control Perform pre- and post-migration data validation Reconcile: Customer records (CIF counts and accuracy) Account balances (trial balance vs GL) Transaction totals and histories Ensure financial integrity (no data loss or duplication) Produce reconciliation reports for audit and sign-off Migration Testing & Mock Runs Execute multiple mock migrations / trial runs Support: System Integration Testing (SIT) User Acceptance Testing (UAT) Identify and resolve data defects and inconsistencies Optimize migration scripts for performance and accuracy Cutover Execution & Go-Live Support Execute final production data migration during cutover window Monitor migration progress and resolve real-time issues Support business teams during go-live and stabilization phase Ensure minimal downtime and seamless transition Data Governance, Compliance & Risk Management Ensure compliance with banking regulations and internal policies Maintain data audit trails and migration logs Support audit and regulatory reporting requirements Ensure secure handling of sensitive customer and financial data Stakeholder Collaboration Work closely with: Core Banking Implementation Partners Business Users (Operations, Finance, Risk) QA and Testing Teams Facilitate data validation workshops and sign-offs Provide regular updates on migration progress, risks, and issues Key Requirements Education Bachelor’s degree in Computer Science, Information Systems, Finance, or related field Experience 4–8+ years of experience in data migration within banking or financial services Hands-on experience in at least one CBS implementation (T24, Finacle, Flexcube, etc.) Proven experience handling large-scale financial data migrations Technical Skills Advanced SQL and database skills (e.g., Oracle Database, Microsoft SQL Server) Strong ETL and data transformation experience Understanding of banking data structures and products (CIF, loans, deposits, GL) Experience with data reconciliation and financial balancing Familiarity with scripting (Python, Shell) is an added advantage Functional / Domain Knowledge Strong understanding of: Core banking operations Retail and corporate banking products Financial accounting and GL structures Knowledge of regulatory requirements in banking environments Soft Skills Strong analytical and problem-solving ability High level of accuracy and attention to detail Ability to work under pressure, especially during cutover Strong communication and stakeholder engagement skills Preferred Qualifications Experience in African banking environments (e.g., Kenya, East Africa) Prior experience in CBS vendors like Temenos, Finacle, or Oracle Certification in data management, ETL tools, or banking systems Exposure to cloud-based CBS migrations Key Deliverables CBS Data Migration Strategy & Plan Source-to-target data mapping documents Cleansed and validated datasets ETL scripts and migration workflows Reconciliation and audit reports Cutover and go-live migration execution report Success Metrics 100% accuracy in migrated financial data Successful reconciliation of GL and account balances Zero critical data defects at go-live On-time migration within cutover window Regulatory and audit compliance achieved