• Having around 5+ years of experience in Design, Development, Analysis and Implementation of Data warehousing Technology by using ETL tool Informatica Power Centre .• Has extensively worked on technologies like Informatica PC, Oracle and Unix Shell script.• Strong Knowledge on Power Center Designer, Workflow Manager & Work flow Monitor.• Profound knowledge on Data warehouse concepts like Data warehouse, Star schema, Data Marts, Dimension and Fact tables. Good Knowledge in developing SQL with relational databases like Oracle.• Extensive implementation of various transformations like Filter, Lookup, Expression, Source Qualifier, Aggregator, Sorter, Router, Update Strategy etc.• Handled different types of SCD’s to meet the requirements.• Experience in resolving on-going maintenance issues and bug fixes; monitoring Informatica sessions as well as performance tuning of mappings and sessions.• Experience in all phases of Data warehouse development from requirements gathering for the data warehouse to develop the code, Unit Testing and Documenting.• Excellent interpersonal and communication skills, and is experienced in working with senior level managers, business people and developers across multiple disciplines.• Extensively used mapping Parameters, Mapping Variables• Ensured loading multiple targets in the same mapping by Target Load Order• Identified and Tracked Slowly Changing Dimensions• Ability to rapidly learn new concepts together with excellent interpersonal skills.• Having good experience worked with different Transformation, Mappings and Mapplets in Informatica• Good Interpersonal Skills, Strong technical skills, and communication skills that helps to lead a good deliverable.