BBI Success Stories

FAB MisrEgypt · Financial Services

Migration of DWH ETL Jobs from ODI to Informatica

ETL Assessment, Redesign & Continuity

Business problem
Replacing unsupported ODI
What BBI changed
Assessed existing ETL workflows and identified key migration requirements
Strongest supported result
ODI RetiredDelivery performance
  • ODI RetiredDelivery performance
  • Reliable DWH OpsStated outcome
  • Scalable ETLStated outcome
  • Empowered TeamStated outcome

01Context

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.

02Challenge

Before

  1. 01Replacing unsupported ODI
  2. 02preserving critical workflows with minimal disruption
  3. 03redesigning ETL jobs for PowerCenter
  4. 04transferring knowledge to the internal team

After, as stated

  • ODI Retired
  • Reliable DWH Ops
  • Scalable ETL
  • Empowered Team

03What BBI delivered

ETL Assessment, Redesign & Continuity

  1. ETL Assessment

    Assessed existing ETL workflows and identified key migration requirements

  2. Process Redesign

    Redesigned ETL processes for compatibility with Informatica PowerCenter

  3. Performance Tuning

    Optimized jobs for improved performance and reliability on the new platform

  4. Controlled Migration

    Executed the migration with a focus on minimal disruption

  5. Business Continuity

    Kept critical data processes running throughout the transition

  6. Training & Support

    Delivered training and ongoing support for efficient PowerCenter use

04Outcomes

Delivery performance

How the work was executed: timing, continuity and control.

  • ODI Retired

Stated outcome

Listed as an outcome in the case study, without a figure.

  • Reliable DWH Ops
  • Scalable ETL
  • Empowered Team

05Technology & capabilities

Technology named in the case study

Capabilities

Numbers show how many of the 50 stories share each item.

06Related stories

Source notes
  • BBI Company Profile 2025 — case studies, slide 31. The deck classifies this story under “Financial Services” and lists its location as “Egypt”.
  • Outcome labels are quoted from the case study. Their grouping (impact, scope, delivery, stated) is editorial.
  • The animation at the top of the page is an illustration, not a diagram of the client's systems.

→Contact BBI

Talk to BBI about your data and AI goals.

Contact form on bbi.ai
Head office
Office no 8 C6, I-Rise Tower, Barsha Heights, P.O. Box 119160, Dubai, UAE