About Me

Having 3+ years of technical experience in Analysis, Design, Development, Testing and Implementation of Client Server Application and Data warehousing ETL (Extract, Transform and Load) in Informatica Power Center 10.x / 9.x Main areas of expertise ar... ETL (Extract, Transform and Load) in Informatica Power Center 10.x / 9.x Main areas of expertise are Developing and Testing the data warehousing projects with data quality standards. Extensive experience in Extraction, Transformation and Loading of data directly from heterogeneous source systems like flat files, Oracle by using Informatica power center. Tuned several mappings for the better performance and involved in Performance Testing. Experience on all important General transformations like Filter, Router, Expression, sorter, Source Qualifier, Lookup, Seq Generator and update Strategy. Customized SQL override queries where ever possible to minimize the use of Joiner, Filter and Lookup Transformations. Developed all the mappings according to the design document and mapping specs provided and performed unit testing. Experience in Creating SCD Type-1 and Type-2 mapping technique to load the data into various dimension tables. Used Parameterization for Mapping, Workflows and sessions. Error handling & issue analysis during the testing and maintenance. Hands on Exp on using Un-Connected lookup and Dynamic Lookups. Identifying the bottlenecks and implement the Performance tuning & Optimization techniques in power center. Experience in creating mapping parameters and variables to load the stage and Data warehouse incrementally. Worked on Versioning Concepts on Informatica PowerCenter. Created Mapplet and Re-usable Transformations for applying few logics. Exp in using UNIX commands to run the Informatica Workflows & controlling the ETL flow. Experience in Creating, Scheduling and configuring workflows, worklets and sessions using Informatica workflow manager. Good Knowledge on Data Warehousing concepts like Star Schema, Dimensions and Fact tables. Excellent problem-solving skills with strong technical background and good interpersonal skills.