Transactional Process Data Mart Informatica Project

  •  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

2 Replies to “Transactional Process Data Mart Informatica Project”

  1. Hi I would like to know is it open for Informatica Freshers also, if yes kindly let me know further details and contact number to discuss further

Leave a Reply

Your email address will not be published. Required fields are marked *