• Having 9 Years of relevant experience in ETL Technology with a strong background in design, Development, Implementation and Support of ETL processes using INFORMATICA Power Center 10.x• Have hands on experience on ETL tool – ODI (Oracle Data Integration)• Extensively worked on developing Informatica Mappings, Mapplets, Sessions, Workflows and Worklets for data loads from various sources such as Oracle RDBMS, Flat Files.• Extensively worked on Developing Data warehouse solutions for Oracle EBS and PEOPLESOFT.• Good experience on mappings using different transformation logics such as Expression, Router, Union, Sequence generator, Normalizer, Lookup, Aggregator, Joiner, XML Parser, XML Generator and Update Strategy• Worked on Web Services Provider/ Consumer• Knowledge on gathering of Business requirements and worked closely with various Application and Business teams to develop Data Model, ETL procedures to design Data Warehouse.• Understanding of Data Warehouse Architecture and Designing principles like Star Schema, Snowflake Schema.• Experience on Designing ETL Mappings for Facts, Dimensions, Aggregates, Seed, Snapshot, Soft Deletes as per the business requirement.• Participated in Full life cycle development of Data Warehouse systems such as Analysis, Design, Development, and Maintenance & Technical Documentation.• Expertise in different types of loading like Normal and Bulk loading challenges. Involved in Initial Loads, Incremental Loads, Daily loads and Monthly loads.• Worked on Slowly Changing Dimensions (Type1 and Type2) and its implementation to keep track of historical data.• Able to learn new technologies and Business Terminology quickly. Worked with the Tasks like Event Raise, Event wait, Decision and assignment to achieve the looping.• Hands on knowledge on DAC (Oracle Data Warehouse Administration Console) to Creating Custom Tasks, Subject Area, Execution Plan, Synchronizing Task, Monitor the Execution Plan.• Involved in knowledge sharing and knowledge transfer to the new members of the project & Preparation of knowledge transfer documents.• Responsible for monitoring the load plan and fixing the issues.• Testing and validation of the developed Informatica mappings debugging session logs & fixing the issues.• Strong experience in using Oracle 11g,Sybase,SQL, and Windows.