About the client:
The client is an advanced technology, services and finance company providing innovative solutions in energy, health, transportation and infrastructure, operating in more than 100 countries.
The Challenge:
There was a critical need to consolidate independent HR data marts into the enterprise data warehouse while increasing savings on the storage and server environment and reducing unwanted data movements.
The Value-add:
- Savings in hard disk space by eliminating redundant tables
- An integrated database server with Enriched Audit information
- Easier maintenance as all coding was moved to Informatica
- Manual processes involved ETL was automated
- Common semantic layer definition with Integrated security