• Developed the Informatica ETLs, DB objects to load the data from various sources including flat files, XML files, relational database, Real Time Messages (JMS). Implemented the near real time data processing mechanism using Informatica power center.• Developed the Informatica pipelines to load the slowly changing dimension tables. Worked on creating database objects and automating the data load processes. Involved in end-to-end implementation of data warehouse project.• Created a data model, built the Business Glossary, Business Terms using Informatica Analyst and Informatica meta data management tool, helped users to access the meta data information.• Ensured production environment is stable and streamlined the production processes. Worked with production team to automate the repetitive tasks.

• Designed and developed the Informatica ETL pipelines to extract and transform the data from XML source to load it into relational database.• Experienced in writing Unix shell scripts and worked on Autosys to schedule and automate the ETL pipelines. Helped in saving 50 Hours annually.• Presented analysis and findings to the business users, worked with the leads to understand the requirements and translated the requirements into technical specifications.• Automated the process of data quality rules using Oracle procedures and packages, loaded 10 years of historical data and achieved 20% reduction in processing time.• Developed dashboards using QlikView visualization - created a model, scripts to transform the data, generated QVDs, created charts and dashboards for the business users.