TWB company is acquired by worthington industries for which we are doing the data integration into the existing EBS source system and then pulling that data into the datawarehouse and make the data available for reporting

Generation of informatica cloud mappings to load from various sources based on the source table id’s in order to ingest the data using a framework which is developed using informatica cloud mapping templates and java into various targets like Amazon Redshift, S3

Re-implemented the project & SCOM Analytics and enhancements from 7964 version to 11g OBIA with little modification to the code to enhance the performance of the loads etc.

The project is all about financial analytics (FA, AP, AR, GL) which involved building some custom facts and dimensions related to Fixed Assets and micro ETL related to GL accounting.

The project is all about financial analytics (FA, AP, AR, GL) which involved building some custom facts and dimensions related to Fixed Assets and micro ETL related to GL accounting.

Currently the Agent Compensation System (ACS) is maintained by legacy Mainframe systems for the past 30+ years which is resulting in compensation leakages to the insurance agents of Bankers Life and Casualty (BLC) and other third party insurance companies. AiM program is introduced to convert this system to load the agent and policy data from Mainframe and other sources into RDBMS using informatica power center and calculate the agent compensation using Varicent ICM in order to avoid the compensation leakages in the system.

Arizona lottery introduced new online lottery game called weekly winnings. We need to track this game related sale data by extracting gaming transactions from OLTP system, transform and load to Data warehouse. Brief description of the game is as follows. The Weekly Winnings game consists of choosing one set of four (4) numbers that range from one (1) to fifty (50). Each Weekly Winnings wager will also automatically receive five (5) additional sets of 4 (four) randomly-selected Quick Pick numbers printed on the same ticket. The player wins by matching the set of player-selected numbers or the five (5) sets of terminal-selected numbers against four (4) numbers drawn by the Lottery.

Worthington Industries have acquired the TWB company recently for which we have been integrating the TWB data from MES source with our existing BI data (which is from EBS source) so that it is available for BI reporting

The data ingestion framework pulls the data from different sources like sql server, Amazon Aurora, oracle and flat files by creating a mapping templates for different kinds of data (PII/Non PII/UMT etc) and then convert the mapping template into informatica cloud mapping and then executing these mappings using java code and then load into the targets like Amazon Redshift and S3 file system. The framework automates the process of generating informatica mappings and automates the RFC creation as well to migrate the objects which will reduce lot of developers time

Customer is using OBIA 7.9.6 in which we will use informatica as ETL and DAC as scheduling part and wanted to upgrade to OBIA 11g (ODI as ELT tool). So we have installed OBIA 11.1.1.10.1 and configured Project, SCOM, P&S and Financial Analytics Out of the box