My roles in the project is,

• Design, development and implementation of Pentaho PDI Jobs and Transformations
• Developed ETL to populate the raw data, populate staging tables and store the refined data in partitioned tables in the EDW

My roles in this project is,

• Development and implementation of Pentaho PDI Jobs and Transformations

• Extracting data having different extension txt,csv ,xls and EDI files and load data into single destination system
• Developed ETL to populate the raw data, populate staging tables and store the refined data in partitioned tables in the EDW
• Populate EDW data into reporting tables

• Developed and modified Oracle and SQL Server Stored Procedures to load the data.

• where the data for each client is stored in separate databases with the Client name used as the tenant-id are clubbed into one single database with newly generated ID for each tenant names

My role in the project is,

• Design, development and implementation of Pentaho PDI Jobs and Transformations
• Developed ETL to populate the raw data, populate staging tables and store the refined data in partitioned tables in the EDW
• Populate EDW data into reporting tables
• Multi Tenancy Module Development.
• LDAP integration with Pentaho.
• MongoDB data Integration to DWH data.
• Developed Infobright StoredProcedures to load the data and other stored procedures are used in dashboards and ETL.
• where the data for each client is stored in separate databases with the Client name used as the tenant-id are clubbed into one single database with newly generated ID for each tenant names

My roles in the project is,

• Design, development and implementation of Pentaho PDI Jobs and Transformations
• Developed ETL to populate the raw data, populate staging tables and store the refined data in partitioned tables in the EDW