• Training Area: BIPM AO (Business Intelligence and Performance Management Application Operations)• Technologies and Tools: SQL, PLSQL, UNIX Shell Scripting, Data Warehouse Concepts, PLSQL Developer• ETL tool: Informatica PowerCenter 9.6.1, Workflow Manager and Workflow Monitor• Reporting tool: SAP Business Objects (SAP BO)• Working knowledge of Oracle 11g SQL, PL/SQL, and learnt about DDL, DML, DCL, TCL AND DQL commands, different types of joins, grouping of data, different types of functions, procedures, stored procedures, cursors, triggers and many features. • Extensive experience of dimensional modeling of data to create star schema and snow flake schemas and knowledge of different types of facts and dimensions.• Experience in extraction, transformation and loading of data directly from different heterogeneous source systems like flat files, Excel, Oracle, SQL Server and DB2• Extensive experience in identifying source, target system definitions, creating mappings, jobs, sessions and run workflows in addition to performing data cleansing and transformation operations• Worked extensively with complex mapping using transformations such as Source Qualifier, Unconnected/Connected Lookup, Filter, Expression, Router, Joiners, Update Strategy, Aggregator, Sorter, Sequence Generator and Union• Strong experience in designing SCD 1, SCD 2 mappings • Creating reports and charts using SAP BO