
Around 12 years of IT experience in Analysis, Design, Modeling, Development, Implementation, testing and support of various Data warehousing applications. Strong expertise in ETL Tools like Informatica powercentre tool 9.x,10.x/Informatica BDM 10.3/Ab initio tool 3.1.5. Worked with front end developers and frame works like Microsoft main frames, Sales force, Seibel and full stack. Extensive knowledge on Data warehouse concepts and schemas like Star and Snowflake. Extensive work experience in the areas of Health care, Insurance, Manufacturing Industries and Sales. Participated in code migration for prod and supported until all the jobs got succeeded. Worked on ACM tool for mapping and pram file migration. Supported UAT and SIT with the testing team members. Involved in providing user support for executing system integration testing. Involved in production implementation of new systems Optimizing Informatica Mappings and Sessions to improve the performance. Possess complete domain and development Life Cycle knowledge of Data Warehousing. Strong experience in Informatica Metadata and Repository Management was directly responsible for the Extraction, Transformation and Loading of data from Multiple Sources to Data Warehouse. Worked on putty scheduler tool to automate the jobs Extensively worked on Informatica Designer Components Source Analyzer, Warehouse Designer, Mapping Designer, Transformation Develop, and Workflow Manager. Used various transformations like Source qualifier, Aggregators, lookups, Filters, Sequence generators, Routers, Update Strategy, Expression, Sorter etc. Performing code migrations as part of weekly/Monthly Change request releases. Involved in performance tuning in source, target, transformation and session level. Involved in code reviews in the level of mapping designer and workflow designer. Involved in daily morning checks for different applications. Worked on putty scheduler tool to automate the jobs Good knowledge in SQL and UNIX. Involved in knowledge sharing and knowledge transfer to the new members of the project & Preparation of knowledge transfer documents. Good work ethics and “can-do” attitude with excellent communication & interpersonal skills.