Responsible for all activities related to the development, implementation, administration and support of ETL processes for large-scale data warehouses using Power Center and Power Exchange.
Read More »
Created Complex informatica mapping involved extensive use of transformations aggregator, filter, router, expression, joiner, stored procedure, normalizer, connected and unconnected lookups to improve performance, update strategy transformation to handle updates, scheduled sessions and defined target load order plan with constraint bases/RI for loading...
Design and Develop ETL Adapter between Servicing Interface and Standard Data API. Servicing system which includes Fiserv, ALS, FDR, Nation Star, Jack Henry. Generic mappings are developed so that any client that used these legacy systems can easily Load the data using informatica.
Project: Asia Capital PLC (Srilanka) – Financial Institutional (Brokerage House) Solution
Client : Asia Capital PLC (Srilanka)
Worked as ETL Lead in Asia Capital PLC (Brokerage House) Srilanka and implemented DWH solution on their current Back Office System, it was a custom solution and has a flavor of OBIEE 11g and add-ons, built custom mappings and built Meta data repository from scratch to meet the user requirements
Project – Repository Redesign with Aggregate Fact
Worked as a Senior Consultant, created the new mappings and workflows for Repository Redesign in which aggregate fact holds the major information of sales and lots. Also that fact also contains the Bidders and registrants information. Also created the Tasks for this particular project. Performed migration from one environment to the other.
Read More »