Modernizing Enterprise HR Analytics Through Informatica to Databricks Migration

Customer Context   

A global biopharmaceutical solutions organization undertook an enterprise HR transformation during its migration from PeopleSoft to Workday. Its HR analytics ecosystem relied on 658 Informatica PowerCenter mappings tightly coupled to the legacy ERP schema, creating complexity, scalability limitations, and significant maintenance overhead. As the ERP transition progressed, the organization required a cloud native HR analytics platform to modernize data models, reduce dependency on legacy ETL, and maintain uninterrupted workforce reporting. HR leadership depended on timely headcount, attrition, and workforce planning dashboards, making reporting disruption unacceptable.  

The Challenge

Legacy ETL Dependency 

The solution enabled the organization to establish a modern Lakehouse architecture on Microsoft Fabric, unlocking scalable analytics while maintaining full data integrity and governance. 

ERP Data Model Shift 

Workday introduced structural changes requiring downstream pipeline re engineering. 

Business Continuity Risk

HR dashboards needed to remain stable throughout the ERP transition. 

High Licensing and Maintenance Overhead 

The Informatica environment required ongoing infrastructure and operational support. 

Performance Constraints

Long batch processing windows limited scalability during peak HR cycles. 

Governance Requirements

Sensitive HR data required strict access controls and compliance adherence.