Having 4 + Years of Experience comprises Years as Informatica IICS Developer and Informatica Power Center Developer. Worked with different data sources, non-relational Data sources such as Flat files, Excel sheets, Application Sources, and other relational sources such as Oracle, SQL Server. Developed Complex mappings from varied transformation logics like Unconnected/Connected lookups, Router, Filter, Expression, Aggregator, Joiner, Union, Update Strategy and more direct interaction with the client Managers/Business users for understanding of requirements. Hands-on experience in Oracle 11g and Informatica Analyst Hands-on experience in writing and executing SQL queries Strong Exposure in Data Warehouse concepts like star schema & Snow-flake schema Strong experience in Operational Data management reporting to Business and Technical teams for Risk Management. Strong exposure in ETL process and Data warehouse lifecycle Experience in Performance Tuning and Debugging of mappings and sessions. Strong in optimizing the Mappings by creating/using Re-usable transformations Mapplets and PL/SQL stored procedures. Involved in designing the mapping with multiple files loading using file repository. Extensive experience in Extraction, Transformation, and Loading of data using Informatica from heterogeneous sources. Experience in the full-cycle software development including requirements gathering, prototyping, and proof of concept, design, documentation, implementation, testing, and maintenance. Good Understanding of Dimensional Modeling, Star and Snowflake Schemas. Experienced in doing the process of extraction, transformation and loading data from multiple sources like flat files and OLTP systems into data marts using Informatica Power Centre. Involved in creation of using different kinds of Sources and Destinations. Implemented and Tested Slowly Changing Dimension -