End-to-end DW/BI, Data Lake & MDM managed services for a tier-1 European Airline

Goal of the Project

Our client was looking to develop data platforms and provide a single view of customer via data-driven applications. They embarked on a journey to consolidate existing siloed data platforms into an integrated data lake on AWS with the following objectives:

  • Enable cloud-first strategy and leverage modern data architectures 
  • Re-design existing data platforms to cater to current business needs 
  • Reduce technical debt and standardize on fewer tools/technologies 
  • Centralize data governance and enable single source of truth

Our Solution

Coforge developed multiple data platforms in the following domains to enable single version of truth and real-time data-driven customer-centric applications: 

  • Commercial - comprising of customer data marts, marketing analytics and revenue management, revenue accounting, ancillary revenues 
  • Operations - comprising of Crew Management, Flight Operations, Baggage, Cargo, Inventory 
  • Advanced analytics - comprising of Route Econometrics, Booking Algorithms 
  • Customer Master Data Management 

Coforge developed an end to end data platform using the overall architecture of the platform along with the tools as shown below: 

  • Data Warehouse: Exadata, DB2, MySQL 
  • Data Integration/ETL: Oracle Data Integrator, DataStage, PL/SQL 
  • Data Quality: Trillium 
  • MDM: Informatica 
  • Data Visualization: OBIEE, QlikView, Tableau, Hyperion 
  • Data Science: SAS 

The following diagram shows the MDM specific architecture. Here MDM is integrated with Salesforce CRM/Marketing cloud. 

Iberia Case Study


Value Delivered to Client

  • 40% of increment on identified unique customers through the consolidation of all the passenger’s interaction in a single platform. This has enabled more focused and specialized marketing actions with a positive impact of 3% on look to book ratio. 
  • This bigger personalization of the offer has enabled a sustained increment on direct channels selling to reach almost 50% of total revenues. 
  • Reduction of 25% on running cost thanks to the consolidation in a single platform, technology stack and support team. The progressive decommission of old applications allows to foresee an additional 5% on cost reduction YoY. 
  • Time to market: reduced processing times from 4 months to 7 days 
  • Earlier decisions can be taken and anticipate to the customer needs on disruption scenarios, as example, there has been a 3pp increment on NPS during last year.  
  • Enhanced framework for data quality and data governance, which has allowed implementation of a centralized data platform.
Download the Case Study
2 + 0 =
Solve this simple math problem and enter the result. E.g. for 1+3, enter 4.

By clicking the download button, you allow us to connect with you using email, phone or post (as provided) for responding to you and for other marketing activities. This information is protected under our privacy policy.