Responsible for gathering suit of business requirements, Prepare Source to Target Mapping specifications and transformation rules.Development of mappings, sessions and workflows according to business requirements.Designed, Developed and Supported Extraction, Transformation and Load Process (ETL) for data process using Informatica.Deal with Informatica failures and troubleshoot the failures.Created complex mappings which involved slowly changing dimensions, implementation of… Show more Responsible for gathering suit of business requirements, Prepare Source to Target Mapping specifications and transformation rules.Development of mappings, sessions and workflows according to business requirements.Designed, Developed and Supported Extraction, Transformation and Load Process (ETL) for data process using Informatica.Deal with Informatica failures and troubleshoot the failures.Created complex mappings which involved slowly changing dimensions, implementation of business logic.Developed mappings using Informatica Transformations such as Filter, Router, Expression, Aggregator, Sorter, Lookup, Joiner, and Update Strategy etc.Worked with mapping variables, mapping parameters, parameter files, designed the ETL mappings which updates the parameter files.Involved in migrating the Mappings, Workflows across environments.Involved in designing the Maplets and reusable transformation as per the business needs. Show less