Ganesh Khedkar Email and Phone Number

The McCain Foods is Canadian multinational frozen food company established in 1957 Florence Ville , New Brunswick , Canada . it is the world’s largest manufacturer of potato products its major competitors.Roles & Responsibilities: Analyzing functional requirements and specifications. Extensively worked on Stored procedure to update data dynamically instead of using lookup transformation. Worked on performance tuning in IICS and SQL part. Developed Informatica mappings and Mapplets by using various transformations like Lookup, Joiner, Expression, Aggregator, Sequence Generator etc. Extensively used of procedure and complex views to extract and load the data from oracle database to Oracle database. Interacted with client, testing teams to identify applications defects. Reporting the daily status to team lead and manager.

The Kroger Company, or simply Kroger, is an American retail company that operates (either directly or through its subsidiaries) supermarkets and multi-department stores throughout the United States.Kroger operates a total of 2,726 grocery retail stores under its various banners and divisions in 35 states and the District of Columbia.Roles & Responsibilities: Participating ETL design phase and creating ETL Design Specs for mappings. Understanding existing business model and customer requirements. Modifying Source qualifier query as per business requirements. Extracting data from multiple source systems - Oracle RDBMS and Flat Files. Designing ETL Data flows from Source systems to Target systems. Using Transformations like Aggregator, Router, Joiner, Expression, Update Strategy, Filter etc Developed scheduling job using TWS. Using Informatica Power Center 9.x, loading Historical and Incremental Data into master tables. Used Timer, Event Raise, Event Wait, Decisions, and Email tasks in Informatica Workflow Manager. Extensively used of procedure and complex views to extract and load the data from oracle database to Oracle database. Developed schedules to automate the update processes and Informatica Sessions/Batches. Implementing Change Data Capture (CDC) Techniques like Slowly Changing Dimension (Type I, Type II) and Simple pass-through mapping. Developed UNIX shell scripts to automate applications, Schedule jobs, develop interfaces. Extensively involved in Data Extraction, Transformation and Loading (ETL process) from source to target systems using Informatica.Environment: Informatica 9.6.1, Oracle 11g, SQL Developer, DB Visualizer, putty, Unix, WinSCP.

Genentech IQVIA is an American multinational company serving the industries of health information technology and clinical research. The project deals with company policy and claim here the HealthCare DB is the Third-Party Payers Database from which we are fetching the customer’s data using flat file as well as relational database and sending this data to the landing. In landing data is sent to the Staging layer in which we use to merge all the data coming from the source system and Healthcare DB. Then the cleaned data is sent to ODS layer in which OLTP operations are performed by using SCD1 and SCD type2 as per business flow.Roles & Responsibilities: Participating ETL design phase and creating ETL Design Specs for mappings. Understanding existing business model and customer requirements. Using Informatica Power Center 9.6.1, loading Historical and Incremental Data into master tables. Extracting data from multiple source systems - Oracle RDBMS and Flat Files. Designing ETL Data flows from Source systems to Target systems. Used Timer, Event Raise, Event Wait, Decisions, and Email tasks in InformaticaWorkflow Manager. Preparation of the unit test plan and test results along with the test data. Using Transformations like Aggregator, Router, Joiner, Expression, Update Strategy, Filter etc Developed schedules to automate the update processes and Informatica Sessions/Batches. Implementing Change Data Capture (CDC) Techniques like Slowly Changing Dimension (Type I, Type II) and Simple pass-through mapping. Extensively involved in Data Extraction, Transformation and Loading (ETL process)from source to target systems using Informatica.Environment: Informatica 9.6.1, Oracle 11g, SQL Developer, Unix