• Attended all meetings with Business along with development team and analyse the requirements. Load/Extract data from multiple cloud applications (primarily SFDC) and legacy applications (Oracle).
• Define and document complex technical design/requirements for integrations and DWH. Ability to work independently and collaboratively in the development, testing and implementation lifecycles.
• Strong experience in creating tables, writing complex PL/SQL Queries using functions, stored procedures, cursors, Indexes, joins, triggers, views in PL/SQL for optimum performance.
• Responsible for performance tuning and Optimization of PL/SQL queries using Data Profiler, creating indexes and Database tuning advising wizard.
• Develop Informatica packages for integrating data using different data connections from heterogeneous sources by using multiple transformations provided by Informatica cloud such as Data Conversion, Derived Column, Lookup, Conditional Split, Merge and union all.
• Involve in data ware house concepts, Relational Database Management Systems (RDBMS), Normalization, Data Modeling and Documentation. Participates in code reviews and recommend solutions to enhance ETL Programs to project team and management.
• Used VSTS for assigning and integration of tasks, sprint planning, tracking bugs and work items and as a version control.

Minimum Education Requirement: This position requires minimum of bachelor’s degree in computer science, computer information systems, information technology, Engineering Management or a combination of education and experience equating to the U.S. equivalent of a bachelor’s degree in one of the aforementioned subjects.