Professional Summary : • 9+ years Extensive experience in using ETL methodologies for supporting Data Extraction, Data Migration, Data Transformation and developing Master Data using Informatica PowerCenter 9.1/8.x/7.x/ 6.x• Involved in the Analysis, Design, Development, Testing and Implementation of business application systems for Insurance, Financial and Manufacturing Sectors.• Experience in using Informatica Power Center tools Mapping Designer, Workflow Manager, Workflow Monitor and Repository Manager.• Database experience using Oracle 11g/10g/9i, MS SQL Server 2000 and MS Access, Teradata.• Experienced in loading data, troubleshooting, debugging mappings, performance tuning of Informatica Sources, Targets, Mappings and Sessions and fine-tuned transformations to make them more efficient in terms of session performance.• Expertise in design and implementation of Slowly Changing Dimensions SCD type1, type2, type3 and Change Data Capture.• Extensive experience in developing complex mappings from varied transformations like Router, Filter, Sorter, Connected and Unconnected lookups, Normalizer, Expression, Aggregator, Joiner, Union, Update Strategy, Stored Procedure and Sequence Generator etc.• Excellent in designing ETL procedures and strategies to extract data from different heterogeneous source systems like oracle 11g/10g, SQL Server 2008/2005, DB2 10, Flat files, XML etc.• Working knowledge of data warehouse techniques and practices experience including ETL processes, dimensional data modeling star Schema, Snowflake, FACT dimension tables, OLTP and OLAP.• Used Debugger in Informatica Power Center Designer to check the errors in mapping.• Experience in writing PL/SQL queries including the use of stored procedures, functions and triggers to implement business rules and validations.• Hands on experience working in LINUX, UNIX and Windows environments.• Experience in Data Modeling Tool ERWIN and Data Warehousing Concepts.• Experience in support and knowledge transfer to the production team.• 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.• Experience in support and knowledge transfer to the production team.• Effective working relationships with client team to understand support requirements, and effectively manage client expectations.
Listed skills include Asp.Net Mvc, Informatica Powercenter, Microsoft Azure, Load, and 8 others.
