• Extensively involved in Data Extraction, Transformation and Loading (ETL) from Source to Target Systems using Informatica Power Center. • Developed mappings by using Informatica Transformations like Expression, Filter, Aggregator, Source Qualifier, Lookup, Joiner, Router, Update Strategy etc. • Implemented Slowly Changing Dimensions. Used Type 2 Dimension to keep the history changes. • Worked with various developer modules like profiling, standardization and matching. • Designed various mappings and Mapplets using different transformations such as key generator, match, labeler, case converter, standardize, Address Validator, parser and lookup. • Incorporated the DQ mapplets into PC Mappings. • Implemented PC DQ mappings to test the standardized and cleansed new data. • Populated the data into target tables in an efficient manner. • Involved in Unit testing and identifying the bottlenecks and tuning to improve the performance. • Used workflow manager to create workflows and sessions.

• Extensively involved in Data Extraction, Transformation and Loading (ETL) from Source to Target Systems using Informatica Power Center. • Extensively used Power Center to design multiple mappings based on business logic. • Developed mappings by using Informatica Transformations like Expression, Filter, Aggregator, Source Qualifier, Lookup, Joiner, Router, Update Strategy etc. • Used workflow manager to create workflows and sessions. • Involved in identifying the bottlenecks and tuning to improve the performance. • Involved in Unit testing

• Analyzing the requirements. • Extensively involved in Data Extraction, Transformation and Loading (ETL) from Source to Target Systems using Informatica Power Center. • Implementing business logic in Informatica mappings. • Developed mappings by using Informatica Transformations like Expression, Filter, Aggregator, Source Qualifier, Lookup, Joiner, Router, Update Strategy etc. • Implemented Slowly Changing Dimensions. Used Type 2 Dimension to keep the history changes. • Used workflow manager to create workflows and sessions. • Involved in Unit testing and Performance tuning.