•Designing and developing data integration solutions using Informatica PowerCenter 10.x.
•Designed ETL process to support Watsco GL (General Ledger) application which is being used for managing company's expenses & financial transactions and preparing financial statements.
•Used various performance enhancement techniques to improve the performance of Watsco ETL process and saved 3 hours of ETL run time.
•Successfully completed Informatica upgrade from version 9.6 to 10.1.2.
•Set up Change Data Capture process by creating data maps, registration groups and running database row test by using power exchange 10.1.2.
•Deploy Informatica objects from lower to higher environment (QA/production) using deployment groups through repository manager.
•Developed data profiling solutions, Scorecards and build custom and complex business data quality rules by using Informatica Developer/IDQ Analyst Interface.
•Implemented required ETL on time for Watsco Supply Chain system which has been very useful for report generations and business decision makings.
•Analyze variously formatted public records and vendor data for value and integration into the product platform.
•Facilitate weekly stakeholder meeting. Provide updates on operational issues including missing data, ETL loading, web crawlers, automated data retrieval.
•Implemented Slowly Changing Dimensions - Type I & II in Dimension tables as per the requirements.
•Participate during System/Integration/UAT testing and provide timely and accurate defect resolution.
•Coordinated and worked with cross functional business teams and testing teams to plan and execute the releases as per the timelines.
•Leveraged workflow manager for session management, database connection management and scheduling of jobs.
•Worked closely with administrators for identifying root cause of ETL slowdown and then performing the fix accordingly.