Data Migration Specialist

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