Contribution: Development /enhancements Highlights : -
• Involved in project life cycle for 4 enhancements which included the process like low level design, implementation, testing, UAT and deployment.
• Tools and technology used: Informatica 8.6.1, 9.5, Oracle 11g, Unix scripting.
• Source and target systems: Flat files, Oracle.
• Understanding of the requirement i.e. what business rule need to be followed to transform the data.
• Preparation low level design document so that developer do not have problem in developing the interface.
• Designing the mappings of facts and dimensions according to the business logic requirements.
• Unit Testing
• Bug fixes which comes out of Unit Testing/Peer Reviews.
• Peer review of Coding / Design Doc Developed by Colleagues.
• Support the testing team during system testing.
• Provide training to support team for new architecture of the system.
• Helping in deploying the code from Development environment to Production.
• Participated in giving estimates for the project.
• Advanced ETL development such as designing/developing of Informatica mapping, mapplets, and workflows using Power Center.
• Error Handling, Scheduling, Identifying ETL Job Dependency and Recovery mechanisms.
• Configuration, migration and deployment of ETL mappings.
Experience in performance tuning of Informatica Mappings/Sessions.
Environment: Development and Production.
Tools/Technologies Informatica 8.6.1, 9.5.1 , Oracle , SQL ,PL/SQL , Unix Scripting.