Sourabh K.

Sourabh K.

ETL Developer/Production Support

Pune , India

Experience: 5 Years

Sourabh

Pune , India

ETL Developer/Production Support

41142.9 USD / Year

  • Immediate: Available

5 Years

Now you can Instantly Chat with Sourabh!

About Me

4 years of IT experience in Analysis, Design, Development, Implementation, Testing and Support of larger and complex Data Warehousing and Data Integration Solutions using Informatica Powercenter and OBIEE. Worked on two end to end implementation proj...

Show More

Portfolio Projects

Description

C3PI (Customer Channel Contract Performance Inside): C3PI provides scalable solution which helps to deliver critical insights to managed customer care operations to support business decisions. C3PI is designed to maintain information about customer, channels and their contract with end users with Genentech. Spear is created to validate the data that is provided to Genentech by different senders. This system also gives insights about different measures related to senders and patients.

Show More Show Less

Description

The Operational Data Store (ODS) is built to collate heterogeneous data from various sources like CRM, OBRM, DMS, Portal, USSD, Interconnect, and Mediation. Data obtained from CRM, OBRM, DMS and Portal sources are relational databases (oracle) and for USSD and Mediation, the sources are Flat files or Comma Separated Values (CSVs). The data is extracted, transformed and loaded into Operational Data Store with data integration tool Informatica Power center. The required business rules are applied at data integration and Reporting layers. The data from ODS caters to the reporting requirements with OBIEE reports and dashboards. These reports can be customized as per user requirements.

Show More Show Less

Description

ETL Developer and Data Engineer

Show More Show Less

Description

ETL developer and Data Engineer

Show More Show Less

Description

ETL developer and Data Engineer

Show More Show Less