• Implemented various ETL solutions as per the business requirement using Informatica 10.x/9.x versions• Preparing source to target mapping, technical design document, unit test cases and test data• Involved in the development of Informatica mappings, mapplets,sessions, worklet,workflows, command tasks etc.• Development of shell scripts to ftp the files for Informatica processing• Involved in Requirement Analysis• Involved in preparing the project estimates• Involved in the performance tuning of the ETL code• Involved in the code reviews.• UAT/PROD migration of ETL code and the support activities• Monitoring the Informatica jobs and fixing the failures by coordinating with DBA• Creating new Informatica folders, creating the user and providing the necessary grants using Informatica admin console.• Creating the help desk tickets with the detailed analysis for the failures caused due to the code issues • Extensive knowledge in creating SCD Type I, Type II and Type III mappings. Successfully managed operations on Informatica Enterprise Data warehouse (EDW) including creation, design, development, implementation, and Quality process.• Extensively worked in creating Mappings using Informatica Designer and processing tasks using Workflow Manager to configure data flows from multiple data sources (Oracle, SQL server, flat files, .XML files) to target persistent data stores.

Working as Senior ETL Informatica PowerCenter and Informatica Cloud(IICS) Developer