Job Title: Data Migration Specialist – Core Banking System (CBS)
Location: Onsite Nairobi,Kenya
Reports To: CBS Project Manager / Data Migration Lead / Head of Technology 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
1. 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

2. 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

3. 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

4. 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

5. 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

6. 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

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

8. 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

Top of Form