• Sound Knowledge in Data Extraction, Transformation, and Loading with RDBMS, Flat files and XML.
• Strong knowledge in Data Warehousing and ETL using Informatica Power Center 8.6/9.1/9.5
• Having the knowledge of Informatica 9.1 Lifecycle Management.
• Knowledge on all activities related to the development, implementation, administration and support of ETL processes for large scale data warehouses using Informatica Power Center.
• Extensive knowledge on Source Analyzer, Warehouse Designer, Transformation Designer, Mapping Designer and Mapplets Designer.
• Good Knowledge in developing complex mappings in Informatica to load the data from various sources into the Data Warehouse, using standard and re-usable mappings and mapplets by using various transformations present in informatica tool .
• Good Knowledge in testing the mapping to validate it and move it into production environment
• Sound knowledge on schedulers to mapping
• Having sound knowledge in UNIX with shell scripting
• Good Knowledge On Data warehousing Concepts and Data Modeling
• Sound knowledge in tuning mappings, identifying and resolving performance bottlenecks in various levels like sources, targets, mappings and sessions.