◆FAB Misr · Egypt · Financial Services
Migration of DWH ETL Jobs from ODI to Informatica
Six-Pillar Delivery Across ETL Assessment, Redesign & Continuity
IllustrativeRaw pieces → migration & upgrade
01Context
Client background as described in the 2025 deck.
FAB Misr is a prominent banking institution in Egypt focused on data accuracy, compliance and efficient handling of its data assets. The bank sought to modernize its data management by migrating from unsupported Oracle Data Integrator to Informatica PowerCenter.
02The challenge
Before
- 01Replacing unsupported ODI
- 02preserving critical workflows with minimal disruption
- 03redesigning ETL jobs for PowerCenter
- 04transferring knowledge to the internal team
After, as stated
- ODI Retired
- Reliable DWH Ops
- Scalable ETL
- Empowered Team
As stated in the case study Replacing unsupported ODI, preserving critical workflows with minimal disruption, redesigning ETL jobs for PowerCenter, and transferring knowledge to the internal team.
03Delivery
What BBI delivered
Six pillars of work. As you scroll, each pillar adds a layer to the structure; the layer you are reading glows.
- 01 / 06
ETL Assessment
Assessed existing ETL workflows and identified key migration requirements
- 02 / 06
Process Redesign
Redesigned ETL processes for compatibility with Informatica PowerCenter
- 03 / 06
Performance Tuning
Optimized jobs for improved performance and reliability on the new platform
- 04 / 06
Controlled Migration
Executed the migration with a focus on minimal disruption
- 05 / 06
Business Continuity
Kept critical data processes running throughout the transition
- 06 / 06
Training & Support
Delivered training and ongoing support for efficient PowerCenter use
04Outcomes
Outcomes, as stated
The four outcomes listed in the source case study. Scope describes what was implemented, not measured business impact; no figures have been added.
- DeliveryODI Retired
- Stated outcomeReliable DWH Ops
- Stated outcomeScalable ETL
- Stated outcomeEmpowered Team
05Technology
Technology & capabilities
Technology is listed only where this case study names it.
Named in the source
Capabilities
Source reference
BBI Company Profile 2025 — case studies, slide 31. Classified by the deck under “Financial Services”, location “Egypt”. Review status: extracted unreviewed. The 3D scenes on this page are illustrative. Counts show how many of the deck's stories share each technology or capability.
→Start a conversation
Explore what this could mean for your organization.
Or write to info@bbi.ai