About Me
Ø 7 Years of experience in IT.
Ø An Informatica Certified Developer.
Ø Experience in ETL Development using Informatica and SQL end-to-end Data warehouse Development experience. Have decent exposure to ETL performance tunin...
Ø Have working experience on Full Lifecycle Darwarehousing projects and production support for the same.
Ø Have good analytical skills and also has the knowledge on performance enhancement of informatica mappings and involved in various phases of a project like Requirements Gathering/Analysis, High level Design, Detail level design, Development, Testing, and Documentation etc.
Ø Good experience in ETL Designing and Implementation.
Ø Have experience of loading data from variety of source systems like DB2, ORACLE, Flat Files etc.
Ø Experience in client meetings, Off-shore Co-Ordination, Handling small teams, meeting project goals, deliverables and objectives.
Ø Strong analytical and problem solving skills coupled with excellent communication and inter-personal skills.
Show MoreSkills
Development Tools
Database
Portfolio Projects
Company
Amex
Description
Ø 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.
Show More Show LessSkills
InformaticaCompany
Massachusetts Mutual
Description
Ø 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.
Show More Show LessSkills
InformaticaCompany
lululemon Athletica
Description
Ø 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.
Show More Show LessSkills
InformaticaCompany
The University Grants Commission of India
Description
Ø 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.
Show More Show LessSkills
Informatica