Akansha S.

7+years of experience in Information Technology with a strong background in Data Warehousing and ETL process using Informatica Power Center 9.1 / 8.6 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 Normalizes.
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