• Having Around 4 years of professional experience as an ETL developer in the implementation of a data warehouse using the Informatica PowerCenter tool.
• Main areas of expertise are analyzing, developing, and testing data warehousing projects.
• Experience in Data Warehousing using Data Extraction, Data Transformation, and Data Loading.
• Used ETL process to Extract, Transform, and Load the data into the stage area and data warehouse.
• Extensively used Informatica client tools – Source Analyzer, Warehouse Designer, Mapping Designer, Mapplet Designer, Informatica Repository Manager, and Informatica Workflow Manager.
• Excellent experience in the Design and implementation of ETL processes, Transformation, mappings, and loading using Informatica Power Center 9.x/10.x
• Extensive experience in the creation of ETL mappings and Transformation to reflect business rules using Informatica Power Center to move data from multiple sources into the target area.
• Most of the transformations were used like the Source qualifier, Update strategy, joiner, lookup, Filter, Router, Seq Generator, Union, Rank, Aggregator, and Sequence generator.
• Experienced in integration of various relational and non-relational sources such as Oracle Tables, and Flat Files.
• Experienced in Performance Tuning of Mappings and sessions.
• Having Good Knowledge of Dimensional Modeling like Star /Snow Flake Schemas.
• Experienced in using parameter files, and mapping parameters in mappings.
• Experienced in implementing Incremental load by using Mapping variables to load from Source to stage on a daily basis.
• Experienced in implementing SCD type-1 and Type-2 to load the Dimension tables.
• Experienced in implementing Fact load after Dimensional tables load.
• Experienced in implementing Un-Connected and Dynamic Lookup.
• Experienced in working on Versioning Concepts in Informatica like Check-in and Check-out.
• Experienced in working on Reusable objects like Reusable transformations, mapplets, and worklets.
• Experienced in implementing Different Informatica tasks like Session, Email, Command, and Event wait tasks.
• Good Knowledge on Data warehousing techniques using different Data Warehouse Schemas, SCD Dimensions, Fact tables, etc.
• Good Knowledge of Data Warehousing concepts like Star Schema, Dimensions, and Fact tables.
• Possess complete domain and development Life Cycle knowledge of Data Warehousing.
• Worked on UNIX Commands.
• Have Knowledge on Informatica Cloud(IICS).
• Excellent problem-solving skills with a strong technical background and good interpersonal skills. Quick learner and excellent team player, ability to meet deadlines and work under pressure.