Responsible for designing and developing of ETL pipeline from heterogeneous source to data warehouselayer.Developed Mappings using various Transformations like Lookup, Update Strategy, Aggregator, Router,Sequence generator, ExpressionDesigned, Developed, and unit-tested the ETL process for loading the Medicaid/Medicare records acrossSTAGE, LOAD, and ACCESS schemas Extended the functionalities of the existing ETL process of Medicaid for Medicare.Worked on defects and Co-ordinating with the Testing team and creating the mapping documentsInvolved in the analysis of the Project and conducted peer reviewsUsed session logs, workflow logs, and debugger to debug the session and analyse the problem associatedwith the mappings and generic scripts.Maintained documents for Design reviews, Engineering Reviews, ETL Technical specifications, Unit test plans,Migration checklists and Schedule plans.

Developed ETL programs using Informatica to implement the business requirements.Communicated with business customers to discuss the issues and requirements.Created shell scripts to fine tune the ETL flow of the Informatica workflows.Used Informatica file watch events to pole the FTP sites for the external mainframe files.Performance tuning was done at the functional level and map level. Used relational SQL wherever possibleto minimize the data transfer over the network.Effectively used Informatica parameter files for defining mapping variables, workflow variables, FTPconnections and relational connections.Involved in enhancements and maintenance activities of the data warehouse including tuning, modifying ofstored procedures for code enhancements.Effectively worked in Informatica version-based environment and used deployment groups to migrate theobjects.Used debugger in identifying bugs in existing mappings by analyzing data flow, evaluating transformations.Effectively worked on Onsite and Offshore work model. Production Support has been done to resolve the ongoing issues and troubleshoot the problems.