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