Ø Contributed in preparing Technical design documents, Business requirement document.

Ø Analysis the existing procedures for which pull the data and load in data warehouse.

Ø Working on the balancing mechanism including financial controls which would be applied to ensure the data integrity throughout the event flow.

Ø Involved in preparing test cases, test suit for all the modules.

Ø Prepared LLD, Technical Design Documentation, and Review Checklist for project purpose.

Ø Contributed in preparing Technical design documents, Business requirement document.

Ø Analyzed Sources, Targets and designed the ETL strategy.

Ø Extensively used Power Center/Mart to design multiple mappings with embedded business logic.

Ø Created complex mappings using Unconnected Lookup, Sorter, Aggregator, newly changed dynamic Lookup and Router transformations for populating target table in efficient manner.

Ø Performance tuning of the Informatica mappings using various components like Parameter files, Variables and Dynamic Cache

Ø Involved in unit testing.

Ø Analysis and developing new mappings for which push and pull the data and load in data warehouse.

Ø Working on the balancing mechanism including financial controls which would be applied to ensure the data integrity throughout the event flow.

Ø Involved in preparing test cases, test suit for all the modules.

Ø Involved in Coordinating UAT, migration and support on-boarding activities.

Ø Performed code review by using internal tool (platinum code reviewer).

Ø Implemented CDC mappings through Informatica Powerexchange

Ø Prepared LLD, Technical Design Documentation, and Review Checklist for project purpose.

Ø Mentoring the new joiners in the project.

Ø Batch monitoring.

Ø Reviewed the technical design documents prepared based on requirements.

Ø Analyzed Sources, Targets and designed the ETL strategy.

Ø Extensively used Power Center/Mart to design multiple mappings with embedded business logic.

Ø Created complex mappings using Unconnected Lookup, Sorter, Aggregator, newly changed dynamic Lookup and Router transformations for populating target table in efficient manner.

Ø Performance tuning of the Informatica mappings using various components like Parameter files, Variables and Dynamic Cache

Ø Involved in unit testing.

Ø Implemented End-to-End Auditing and Reconciliation of records

Ø Tuned Informatica Mappings and Sessions for optimum performance.

Ø Performed data gap analysis from source systems to target elements and also from target elements to reporting elements.

Ø Setting up defect triage calls, consolidating day’s work, reviewing newly developed mappings.

Ø Participated in analysis of the specifications provided by the clients.

Ø Analysis and developing new mappings to pull and load the data.

Ø Contributed in preparing Technical design documents, Business requirement document.

Ø Analysis and developing new mappings for which push and pull the data and load in data warehouse.

Ø Working on the balancing mechanism including financial controls which would be applied to ensure the data integrity throughout the event flow.

Ø Designing and implementing the ETL Mappings and Sessions in Informatica

Ø Involved in preparing test cases, test suit for all the modules.

Ø Involved in Coordinating UAT, migration and support on-boarding activities.

Ø Involved in preparing test cases, test suit for all the modules.

Ø Mentoring the new joiners in the project.