Involved in data migration from Sybase to Oracle extensively using Informatica 5.0. I have created PL
& SQL scripts for effective control over source and target data movement. I have done Data Mappings,
effective strategy to keep the referential integrity.
Responsibilities:
Followed Star Schema and snowflake Schema for methodology to organize the data into database by using
ERWIN tool.
Performed data manipulation using basic functions and Informatica Transformation.
Defined reference lookups and aggregations.
Imported Relational metadata extract and load relational data.
Created global repository, Groups, Users assigned privileges using repository manager.
Developed mappings/Transformation/mapplets by using mapping designer, transformation developer and mapplet
designer in Informatica PowerCenter6.x.
Setting up batches and sessions to schedule the loads at required frequency using PowerCenter server
manager.
Developed UNIX scripts to automate the Data Load processes to target Datawarehouse.
Developed Universes and reports using Businessobjects Designer.
Created, modified, maintained the business complex reports using Businessobjects reporting module.

Environment:
Informatica PowerCenter5.0, PowerMart5.0, BusinessObjects5.1, Sybase, Oracle 8i, UNIX, PL/SQL, IBM DB2,
Shell Scripts.