• Worked at onshore with business and users to get the requirements.• Managed the entire offshore team before coming to Onshore.• Prioritize and distribute work within the team.• Send regular updates and issues encountered to client seeking clarifications.• Train new joiners in Informatica and bring them up to speed.• Unit testing and preparing test case.• Develop new mappings and workflows.• Handling daily calls with offshore and the client.• Working with the Business users and SMEs in analyzing system requirements and specifications and translating those requirements into ETL designs.• Providing technical leadership to other members of the development team and project managers in a positive manner to deliver on-time and above standard applications.• Worked on Performance tuning of Informatica designs and mappings.• Responsible for requirements gathering from the Data Analyst.• Created Unit Test plans and involved in primary unit testing of mappings• Created and ran Pre-existing and debug sessions in the Debugger to monitor and test the sessions prior to their normal run in the Workflow Manager.• Extensively developing Low level Designs (Mapping Documents) by understanding different source systems.• Set up Batches and sessions to schedule the loads at required frequency using Power Center Workflow manager.• Extensively used transformations like router, lookup, source qualifier, joiner, expression, sorter, XML, Update strategy, union, aggregator, normalizer and sequence generator. • Created reusable mapplets and reusable transformations.• Responsible for code migration during deployments and warranty support of the application developed.

• Coordinated with Business Users for requirement gathering, business analysis to understand the business requirement and to prepare Technical Specification documents (TSD) to code ETL Mappings for new requirement changes.• Extensively involved in writing ETL Specs for Development and conversion projects.• Prepared project documentation, Program Specifications, Test Cases• Involved in Performance tuning at various levels including Target, Source, Mapping, Session for large data files.• Write High/Low level design documents and prepare test case scenarios as per requirement.• Designed and developed process to handle high volumes of data and high volumes of data loading in a given load window or load intervals.• Created Workflow, Worklets and Tasks to schedule the loads at required frequency using Workflow Manager.• Created complex mappings using Aggregator, Expression, Joiner transformations including complex lookups, Stored Procedures, Update Strategy and others.• Represent offshore status and progress during call with client.• Point of contact for new resource.