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

• 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
• 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
• 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
• 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
• 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
• 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
• 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
• 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

• 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
• 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

• Bachelor’s degree in Computer Science, Information Systems, Finance, or related field
• 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
• Strong understanding of: Core banking operations, Retail and corporate banking products, Financial accounting and GL structures
• Knowledge of regulatory requirements in banking environments
• 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