•Developed ETL mappings from source systems into Data Warehouse using Star Schema and Snowflake Schema.
•Implemented mapping logic for Full Load Extraction and Incremental Load data Extraction.
•Extensively worked with Slowly Changing Dimension Type 1 and Type 2 mappings.
•Implemented Warehouse Solutions like Soft Delete mappings as per business logic.
•Extensively worked with Mapping Designer, Transformation developer and Mapplet Designer.
•Extensive experience in Designing and Developing mappings from varied transformation logic like Source Qualifier, Expression, Joiner, Sorter, Sequence Generator, Aggregator, Filter, Router, Update Strategy, Connected and Unconnected lookup etc.
•Extensive experience in Designing and Developing ETL mappings to extract data from different source systems and load the data in to Warehouse Dimension tables, Fact tables and Aggregate tables as per the business logic.
•Good Knowledge of ORACLE SQL programming.