Dinesh Deshpande

Having more than 15+ years of determining industry experience with Data warehousing and ETL Projects. Handled Projects for Data Integration , Data Warehousing ,Data Quality Management, Data Governance .

Played various roles in course of different project assignments such as technical/team leading, managing, Data warehousing design & development, testing, migration, deployment & release anchoring.

Extensively involved in functional and technical analysis of business process, proposing new approaches to have seamless interfaces between applications, System design and development required for business process captured business requirements, worked on gap analysis, and prepared gap analysis document.

Worked as Data architect for Data Migration project which involves end to end architecture design for Data Migration project and Technical implementations for various source systems.

Extensively involved in Architectural Processes involved in Data warehousing, Data Migration, Data Quality Management ,Data Integration projects. 

Vast Experience in Designing and developing complex data flows to apply Business logic on various types of data (structured, semi structured, un-structured) by applying Transformations. 

Experience in Designing and developing data pipelines by using ADF and ADB notebooks on various types of data.

Experience in creating Reusable Tasks (Sessions, Command, Email) and Non-Reusable Tasks (Decision, Event Wait, Event Raise, Timer, Assignment, Worklet, Control).

Well Experienced in doing Error Handling and Troubleshooting using various log files.

Extensively worked on developing and debugging Informatica mappings, mapplets, sessions and workflows. 

Worked on Performance Tuning, identifying and resolving performance bottlenecks in various levels like sources, targets, mappings and sessions.

Work with PL/SQL, performance tuning of Oracle using  SQL hints, Oracle partitioning, various indexes and join types Understanding & working knowledge of Informatica CDC (Change Data Capture) Implementation experience of CDC using stored procedures, triggers and using informatica power exchange.

Masters In Computer Applications from University of Pune ( India)