Experience

• 

  Part time & freelancing

  Sept 2021 - now

  Informatica developer

  ● Developed Informatica mappings to load data from files/Oracle to target Oracledatabase.● Created mappings using various transformations like Filter, Router, Joiner,Aggregator, Expression Update Strategy, Lookup, and Union.● Implemented Slowly Changing Dimension (SCD) Type 1 and Type 2 for ChangeData Capture in Dimension Tables.● Created Mapplet and Re-usable Transformations for applying few logics.● Debugged and troubleshot Informatica mappings.● Created Connected, Un-Connected, and Dynamic Lookups (Cache).● Worked on Versioning Concepts in Informatica PowerCenter.● Tested existing Informatica workflows/mappings and fixed the bugs.● Identified performance issues in existing sources, targets, and mappings byanalyzing the data flow, evaluating transformations, and tuning accordingly forbetter performance.● Configured database connections in Informatica.● Used Informatica Power Center Workflow Manager to create sessions, tasks, andworkflows.● Worked with Session Logs and Informatica Debugger to handle errors inworkflows and session failures.● Prepared and executed SQL queries to verify Dimensional and Fact tables. Show less