- Project Title: Transactional Process Data Mart Informatica Project
- Database: Oracle 9i/10g
Description of Transactional Process Data Mart Informatica Project:
WNFS has set up the centers in India to perform back office work.Thouseds of customer’s applications scanned and sending to India process daily.WNFS has also call center and capturing information like number of calls, contacts, idle time, time taken to call etc.WNFS is supporting many processes like WNFS life and annuity, WNFS Medical Systems,WNFS Finance. Transactional Processing Data Mart has been developed to integrate data from multiple Processes for generating analytical report.
- Extraction, Transformation and Loading (ETL) of data by using Informatica Power Center.
- Extracted source data from flat files, Oracle and loaded to an Oracle.
- Created mappings using the transformations such as the Source qualifier, Aggregator, Expression, Router, Filter, Sequence Generator, and Update Strategy.
- Involved in Creating Sessions, Workflows Using Workflow Manager