• Worked closely with business analysts and gathered functional requirements.• Developed mappings for loading the staging tables from text files using different transformations.• Involved in building the ETL architecture for Source to Target mapping to generate the target files.• Developed Mappings, Mapplets, Transformations and Reusable transformations by using Power Center Designer.• Developed several mappings in Informatica by using the transformations like Unconnected and Connected lookups, Source Qualifier, Expression, Router, Filter, Aggregator, Joiner, Update Strategy, Union, Sequence Generator, Rank, Sorter, Normalizer, Transaction Control etc.• Developed Workflows, Worklets and Tasks by using Power Center Workflow Designer.• Optimized Sources, Targets, Mappings, Transformations and Sessions to increase session performance.• Extensively used mapping parameters, variables, parameter files, and user defined functions in Informatica.• Used stored procedures to create a standard Time dimension, drop and create indexes before and after loading data into the targets.• Responsible for error handling using Session Logs, Reject Files, and Session Logs in the Workflow Monitor.• Created indexes on database tables (SQL) and tuned the queries to improve the performance Performed Unit Testing and documented the results• Worked on Data Conversion and Data Analysis and Data Warehousing to meet EDW requirements.• Worked on creating data model with the Erwin.• Created Unix Shell scripts to do the file level validations on the flat files provided by the sources.• Scheduled and monitored automated weekly jobs under UNIX environment.• Used parameters and variables to facilitate smooth transition between the development and production environments.• Unit testing of individual modules and their integration testing.• Debugged and sorted out the errors and problems encountered in the production environment.

• Involved in writing mapping specification document (STTM).• Developed Informatica mappings, sessions & workflows, using active and passive transformations, Mapping parameters, session parameters, reusable and non-reusable objects.• Involved myself in identifying the bottlenecks of the Informatica mappings and tuned the Mappings and increased the performance of the mappings.• Involved in Performance Tuning both in informatica and database level.• Validated the data and ensures that data is being populated as expected.• Worked on enhancements of existing mapping for handling Type-I &Type-II.• Used debugger to identify the issues and to fix the bugs.• Creating tables, views, indexes, stored procedure, triggers and functions.• Preparing Unit Test Case document and performing Unit testing.• Preparing SIT test cases and Performing the SIT and capturing the results for PROD approval.Environment: Informatica PowerCenter9.x, Teradata, oracle, Flat, XML Files as sources.