Extensively used ETL methodology for supporting Data Extraction, Transformation and Loading processing, in a corporate-wide-ETL Solution using Informatica.
Extensively worked on Informatica Designer Components Source Analyzer, Warehouse Designer, Mapping Designer, Transformation Develop, Workflow Manager.
Used various transformations like Source qualifier, Aggregators, lookups, Filters, Sequence generators, Routers, Update Strategy, Expression, Sorter etc.
Experience in Performance Tuning the mappings.
Good knowledge in Oracle/Teradata.
Worked on various projects involving Data warehousing, Migration projects using Informatica Power Center (Workflow Manager, Workflow Monitor, Source Analyzer, Warehouse Designer, Mapping Designer, and Mapplet Designer & Transformation Developer).
Good work experience in designing Data Warehousing applications, implementations and enhancements of the business applications using Informatica Power Center 8x/9x/10x.
Proficient in the development of ETL (Extract, Transform, Load) processes with a good understanding of source to target data mapping, ability to define, capture Meta data and Business rules.
Experience in Performance Tuning and Debugging of existing ETL processes.
Experience in developing Test Plans, Test Strategies and Test Cases for Data
Warehousing projects ensuring the data meets the business requirements.
Involved in knowledge sharing and knowledge transfer to the new members of the project & Preparation of knowledge transfer documents.
Excellent problem-solving skills with a strong technical background and result oriented team player with excellent communication and interpersonal skills.
