Involved in multiple projects handling the entire Pharmacy Data Warehouse. The key projects handled are pulling the Accounts, Clients data to Pharmacy Read Only Data Store and Claim processing with External Vendor Argus.As a Developer, I have involved in preparing Technical Design document, UTC’s and UTR’s and lead the Informatica team in the project. Closely worked with business analysts to identify the appropriate source systems for dataset required and prepare Scoping & Assessment document.Prepared Estimation based on the complexity and object details.Prepared release documents and coordinated code packaging, migration and release process with DevOps team.Created Warranty docs for support team and schedule meeting to explain the approach and troubleshooting techniques.Responsible for handling the critical Claim Processing to and fro between External Vendor Argus.Part of two agile teams and handling multiple complex projects at the same time.Responsible for bringing the various flat files using NAS (Mounted shared path) and sending the files to external servers using the same.

• Maintaining the on-time availability of reporting data to users.• Handling Change requests/Enhancements for Continuous process improvement.• Optimization of the Informatica mappings for performance improvement.• Created a number of mappings with transformations like Source Qualifier, Filter, Router, Expression, Joiner, Sequence generator, Lookup etc.• Hands on experience in tuning mappings, identifying and resolving performance bottlenecks in various levels like sources, targets, mappings, and sessions.• Hands on experience in optimizing and writing SQL queries.• Created indexes, sequences and views.• Written SQL overrides in source Qualifier according to business requirements.• Performed peer reviews and Unit testing.• Responsible for monitoring all the sessions that are scheduled, running completed and failed. • Involved in debugging the Mappings that failed and fixing.• Preparation of Technical Specification document (DFS, LLD).• Documentation of tasks and handover Documentation and handover of migration checklist, including codes to be migrated and the order of migration and KT to the production support team.