Developed Informatica BDM data feeds to pull the data from Hbase,Sqoop,Hive objects coming from MIIM application and Other applications and store them into Hive table and hdfs Files through Informatica BDE. Analyzed the existing Spark/Scala framework and build the Informatica BDM mapping according to the given requirements in the existing code. Developed mappings in Informatica BDE 10.2 version with Hive/Hbase/HDFS/Sqoop sources Worked on Update strategy,Router,Expression,Filter,Union and so on transformations as part of my requirements. Developed complex mappings in InformaticaBDE to load the data from various sources. Parameterized the mappings and increased the re-usability. Written documentation to describe program development, logic, coding, testing, changes and corrections. Created Test cases for the mappings developed Created reusable transformations and Mapplets and used them in complex mappings. Analyzed Session log files to resolve errors in mapping and managed session configuration. Involved in migrating the ETL mappings from development environment to testing environment.

ICUE is a collection of tools and capabilities, used by our internal clinical staff, which provides a consistent, intuitive, and flexible Integrated Clinical User Experience in the delivery of services for our members. We have many complex mappings here out of which few are Inbound jobs and few are Outbound jobs. Inbound job means it will take the file from many sources like ( Evisor,CDB,GOvtref,Cosmos etc.) and load them into MQ for further processing. ICUE Application is a java application and Java rules will read the data from MQ and load them into HSR tables. Few jobs will act as Outbound jobs and they will extract the data from ICUE Application and transfer the files to the Downstreams. Developed Informatica data feeds to pull the data from Flat files and Oracle tables coming from ICUE Application and store them into MQ,ICUE DB and into Files. Through Electronic customer Gateway, the files will be transferred to Downstreams.

It is like opeeationald data store

it is OLTP project

ICUE is a collection of tools and capabilities, used by our internal clinical staff, which provides a consistent, intuitive, and flexible Integrated Clinical User Experience in the delivery of services for our members. Source is ICUE web portal and we load data from web portal to STG_HSR and reporting team will pull data from there. Data for Government use will be loaded into TRE and data for commercial use will be loaded into ECODS. We get some flat files as well where we create referral for them and send them back to ICUE and also load the data into temp tables. Developed Informatica data feeds to pull the data from FLAT files and Oracle tables coming from ICUE Application and store them in ICUE DB and ECODS ICUE Application will pull the data from icue db.

It is like data warehouse system

Developed Informatica data feeds to pull the data from FLAT files and DB2 tables coming from many products such as TLE, DIVIDENDS, CAGE, PNS and Money manage Systems to DB2 server data store.