• Created a data warehouse, extracted customer’s data from various sources and loaded it into DW. This included data from RDBMS, Flat Files, and Mainframes
• Developed various mappings to perform ETL on source data and to load it further to OLAP/data warehouse, was also involved in fixing various ETL logics which were causing data issues and were widely impacting the business
• Implemented SCD Type-2 methodology for accessing historical data
• Prepared ETL logic and mapping documents for production support team referencing
• Analyzed and interpreted all complex data. Provided resolutions to all data issues. Coordinated with data analyst and users to validate the results
• Working on performance tuning of targets, sources, mappings and sessions
• Preparing weekly team status reports for the onshore team and having daily status calls with the Scrum Master to discuss daily work progress
• Interacting with the clients on regular basis to understand and give better solutions to the business requirements
• Providing KT sessions to all the new joiners in the team.

Automated the Weekly status report using Python. Used ODBC module to implement the same

• Monitoring more than 20 different applications. Sending out job performance reports to client management
• Creating extensive documentation for process flow
• Analyzing and interpreting the data on target systems. Providing resolutions to all data issues and coordinating with data analyst, users and developers to validate the results
• Investigating and fixing the bugs occurred in the production environment and providing On-Call support
• Refreshing and handling critical Dashboards on Power BI

Providing KT sessions to all the new joiners in the team.