SHANKAR MORE

Having 4+ yrs. of experience in Informatica power center, Analysis, Design, Development, Unit testing, Production Support, and Implementation of application. Extensively worked on Informatica Designer Components - Source analyzer, Target Designer, Transformations Developer, Parameter files, Mapplet and Mapping Designer Experience in creating Mappings and Mapplets using various Connected and Unconnected transformations like Source Qualifier, Aggregator, Expression, Lookup, Filter, Joiner, Union, Router, Rank, Sequence Generator and Update Strategy transformations, Java transformation Worked exclusively on implementing the types of Slowly changing dimensions (SCDs)- Type I and II indifferent mappings as per the requirements Experienced in Performance tuning of Informatica (sources, mappings, targets and sessions) and tuning the SQL queries Hands-on experience across all stages of Software Development Life Cycle (SDLC) including business requirement analysis, data mapping, build, unit testing, systems integration and user acceptance testing Experienced on UNIX Commands. Experienced to work in Development team, Production support teams and Migration Project Team in handling critical situations to meet the deadlines for successful completion of the tasks/projects Experienced in Detailed Technical Design, Unit test plan, Unit test cases and Deployment documents Used different debugging techniques like the Informatica debugger, creating temporary tables and session logs to resolve complex issues Organized and dependable candidate successful at managing multiple priorities with a positive attitude. Willingness to take on added responsibilities to meet team goals.

#Projects DATA SYSTEM 1559 Days project#

Role : ETL Developer Technology : Informatica 10.4, Oracle, Unix Client : HDFC LIFE/Insurance :- The project aim is building State Data Mart for enterprise solutions :- I am part of a team which is responsible for ETL Design & development along with testing :- And this project is about integrating the data from different Oracle Applications using ETL tool Informatica power center and loading the data to DWH systems which is implemented in Oracle and accessed by users in respective Use Environment: Informatica Power Center 10.4, 10g, SQL, SQL, Responsibilities: Understanding the Business requirements based on Functional specification to design the ETL methodology in technical specifications Analyze the Informatica code, preparing design documents, mapping specification then develop the Informatica code Test Informatica loaded data, both results get same then move higher environments Prepared review checklist for coding standard