Ø   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.

Ø   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.

Ø  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.

Ø   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.