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, and 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), and 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, and transaction histories.
Data Validation, Reconciliation & Control
- Perform pre- and post-migration data validation.
- Reconcile customer records, account balances (trial balance vs GL), and transaction totals/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) and 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 the cutover window.
- Monitor migration progress and resolve real-time issues.
- Support business teams during the 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), and QA/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 a related field.
- Experience: 4–8+ years of experience in data migration within banking or financial services.
- CBS Expertise: Hands-on experience in at least one CBS implementation (e.g., T24, Finacle, Flexcube).
- Large-scale Projects: 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.
- Domain Knowledge: Deep understanding of banking data structures and products (CIF, loans, deposits, GL) and financial accounting.
- Soft Skills: Strong analytical and problem-solving ability, high level of accuracy, and ability to work under pressure during cutover.
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.
How to Apply
Interested and qualified candidates should apply online via the Tezza Solutions recruitment portal at tezzasolutions.catsone.com.