TORCH is  a critical application used by GE Corporate, for reporting and decision making on Insurance Domain. Basically Healthcare Project that deals with Claims ,Contributions, JEs and Invoices details of GE employees under various businesses under  Dental, Vision and Medical. We replicate the data from OLTP to data warehouse through Informatica and support the users to create the reports through BO.

• Responsible for development of ETL code like mappings, sessions and workflows and performing unit testing, code reviews.
• Responsible for Developing UNIX Shell Scripts for file validations, executing jobs using pmcmd command and archival of files.
• Understand Technical specification, mapping document.
• Used Informatica Power Center V9.1, 10.1.0, 10.1.1 for extraction, transformation and load (ETL) of data in the data warehouse.
• Extensively worked on Transformations like Router, Aggregator, Joiner, Lookup, Update strategy, Sequence generator, Filter, Expression etc.
• Worked on Informatica Mappings, sessions and other tasks like Command tasks, Event Wait, Event Raise, Timer and workflows on business requirements.
• Worked on mapplets, worklets and also parameterized the mappings for increasing the re-usability.
• Involved in ETL job automation and scheduling using UNIX scripts/pmcmd.
• Report and resolve critical bugs analytically.
• Worked on Documentation , reporting in confluence

The Project loads data from different source systems and populates data into the B2P data warehouse for B2P metrics calculation. As per the requirement from the user, the ETL logic is developed to load data to B2P DWH for to cater data for different B2P metrics calculation.

• Responsible for development of ETL code like mappings, sessions and workflows and performing unit testing, code reviews.
• Responsible for Developing UNIX Shell Scripts for file validations, executing jobs using pmcmd command and archival of files.
• Understand Technical specification, mapping document.
• Used Informatica Power Center V9.1, 10.1.0, 10.1.1 for extraction, transformation and load (ETL) of data in the data warehouse.
• Extensively worked on Transformations like Router, Aggregator, Joiner, Lookup, Update strategy, Sequence generator, Filter, Expression etc.
• Worked on Informatica Mappings, sessions and other tasks like Command tasks, Event Wait, Event Raise, Timer and workflows on business requirements.
• Worked on mapplets, worklets and also parameterized the mappings for increasing the re-usability
• Involved in ETL job automation and scheduling using UNIX scripts/pmcmd.
• Report and resolve critical bugs analytically.
• Worked on Documentation , reporting in confluence

Business Objects deals with Creating Universes, Reports based on the requirements provided by the user with less complexity, which contains 23 applications.