Piyush Ranjan

• Having 3 years of experience in the design and development of Extraction, Transformation and Loading (ETL) using tool Informatica Power Center 9.6.1 & 9.0.1
• Experience in extraction, transformation and loading of data directly from different source systems like Oracle, flat files.
• Experience with Informatica Workflow Manager Window components like Task developer, Workflow Designer and Worklet Designer.
• Working experience with mappings using different transformation logics like Expression, Lookup, Filter, Router, Union, Aggregator, Sorter, Joiner, Update Strategy, Sequence generator etc.
• Working experience with Push Down Optimization, Concurrent Lookup Cache,MD5().
• Experience in Performance Tuning the mappings and involved in source code review.
• Designing the Unit Test cases and validating the data.
• Preparing Detail design document for mappings.
• Experience in Integration of data sources like Oracle, Flat Files.
• Possess complete domain and development Life Cycle knowledge of Data Warehousing.
• Knowledge of data warehousing techniques Star/ Snowflake schema
• Having good knowledge of SQL, and Basic of UNIX