redesigned-business-data-model-for-effective-ETL

Redesigned Business Data Model for Effective ETL

The client is a leading health and life insurer and benefits administrator in the US. The customer had business information available across different legacy platforms due to the acquisition of various businesses. Hence reporting had to be carried out for each individual database separately and business decisions could not be taken effortlessly.

 

How we have helped our customer:

  • We worked on designing, developing and testing ETL programs/jobs to extract data from four claims systems (CORE, NGS, eCAMS, and PowerSTEPP) into one Physical data warehouse.
  • Performed data transformation to convert data into the EDM.
  • Loaded data into the newly created Enterprise Data Model designed by IBM with standardized Data Model

Download file

About Nous Infosystems

Nous Infosystems is a CMMi Level 5 SVC + SSD v1.3, ISO 9001:2008, and ISO/IEC 27001:2013 certified global Information Technology firm providing software solutions across a broad spectrum of industries. Major offerings include Digital Transformation, Application Development & Maintenance, Enterprise Application Integration, Product Engineering, Business Intelligence, Independent Testing and Infrastructure Management Services.

Connect with us