Nishant Jain

The project involves migration of Oracle DWH to Azure Synapse Analytics which consists of changing the Legacy informatica workflows that is used to perform ETL to Oracle DWH and performing the similar ETL process with Synapse Pipelines using Notebook and Stored Procs.

Designing and Implementing the Data Management System (DMS) for Toyota Material Handling North America (TMHNA). The project involves creating the DMS for the business users and managing the data and making it available for reporting and business intelligence. The project entails the implementation of multi-hop architecture which gathers the data from multiple source systems like Stibo, SAP CRM, IBM DB2 and Oracle and finally delivers it to the refined layer in Azure DataWarehouse and Azure Cosmos DB.

Project: Oracle EDW to ADW Migration for client UBS. The project involves development for Azure data pipelines as part of migration from oracle EDW to ADW while working in Agile Methodology. This further involves the integration of Azure data pipelines with Azure Databricks notebooks while converting the flat files to parquet format which are getting ingested from Mainframe DB2 to Azure Data Lake via Tumbleweed.

Technical and Functional Support of Hadoop and SAP HANA Data Pipelines for Adobe. The project involves deploying, maintaining and decommissioning the various data pipeline through Tidal Enterprise Scheduler which further involves completion of data workflows within SLA. Responsibilities included processing billions of events, monitoring ETL pipelines, and managing data transfers into HDFS and Hive.

Technical and Functional Support to Endur Application for Client Uniper. The project involved ensuring the Endur Application was prepared for daily trading operations, managing the flow of trades from fuse middleware, and performing P&L calculations and report generation.