About Me
ETL Informatica Developer with 3 Years of focused experience in the Product and Utilities domain, with a strong background in Data warehousing and ETL experience using Informatica Power Center 9.x/10.x on RDBMS databases . Strong background in res...
Show MoreSkills
Database
Development Tools
Data & Analytics
Software Engineering
Programming Language
Operating System
Web Development
Others
Positions
Portfolio Projects
Company
Business Integration for an Electric Power Holding company
Description
- 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
Show More Show LessTools
Informatica Toad SQLSMSCompany
Business Integration for Medical Technology company
Description
- 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.
Show More Show Less