Case Study: Oi achieves a single customer view and faster data warehouse updates with Informatica

Warehouse loading process time was cut time in half and the 20% increase in volume of historical data available to users helped Oi to identify market trends and new revenue opportunities

Oi, Brazil’s largest telecommunications company — formed through mergers and serving more than 31 million customers with $14.5 billion in annual revenue — faced fragmented data across 17 customer databases and a growing 20‑TB data warehouse. Marketing, product, customer service and compliance teams all needed a single, up‑to‑date view of the customer and faster warehouse updates to support campaigns, speed product launches, prevent fraud and meet government six‑hour number‑portability requirements; legacy systems could only meet some of these needs and took 13 hours to update regulatory data.

Informatica’s platform (PowerCenter, Metadata Manager and PowerExchange) delivered a single, real‑time data integration layer that consolidated customer records and automated loading into the enterprise warehouse. The solution halved warehouse load time (10→5 hours), cut regulatory number‑portability/fraud data delivery from 13 to 3 hours, increased available historical data by 20%, reduced credit recharge processing time by 60% and boosted response capacity by 400%, enabling faster marketing campaigns and greater operational agility.

OI

Vera Duarte

Enterprise IT Manager