10 
Identity14+years of experience in Information Technology with a strong background in Data Warehousing and ETL process using Informatica Power Center 10.x / 9.x / 8.x and Oracle.
Good knowledge of Data warehouse concepts and principles - Star Schema, Snowflake, SCD Types, Normalization/De normalization.
Experience in integration of various data sources with Multiple Relational Databases
Like Oracle, SQL Server and Worked on integrating data from flat files like fixed width and delimited.
Have extensively worked in developing ETL for supporting Data Extraction, transformations and loading using Informatica Power Center.
Well acquainted with Informatica Designer Components - Source Analyzer, Transformation Developer, Mapplet and Mapping Designer.
Worked extensively with complex mappings using different transformations like Source Qualifiers, Expressions, Filters, Joiners, Routers, Union, Unconnected / Connected Lookups and Aggregators, Stored Procedures and Normalizers.
Strong Experience in developing Sessions/tasks, Workflows using Workflow Manager Tools - Task Developer, Workflow & Worklet Designer
Experience in using the Informatica command line utilities like PMCMD to execute workflows in non-windows environments.
Extensively used Informatica Repository Manager and Workflow Monitor.
Experience in debugging mappings. Identified bugs in existing mappings by analyzing the data flow and evaluating transformations.
Good understanding of Session logs and handling Reject loader to work with reject files.
Possess good experience in creating technical documents like Design documents, Operations guide, Software Installation document, Mapping documents, and Unit test documents.
Involved in solving Client issues.
Excellent analytical and communication abilities.
Strong with Relational Database Design concepts.
Team Player, Motivated, able grasp things quickly with analytical and problem solving skills.
Comprehensive Technical, Oral, Written and communication skills.
