NISHANT VERMA

Building data models in snowflake using SQL. Replicating HANA views into snowflake using complex SQL queries. Migrating on-prem ETLs from MS SQL server to Azure Cloud using Azure Data factory and Databricks. Building data pipeline using Azure Data factory. Building Data Models using logical data modeling. Analyzed the SQL script and designed it by using PySpark for query optimization. Working on an e-commerce project as a back-end developer to create a materialized view in Snowflake. Delivered insightful operational reports through successful dataset manipulation, aiding business improvement actions. Developed and refined reporting tools and interfaces for different KPIs to increase transparency and boost staff performance. Closely monitored data warehouse functionality and performance, proactively responding to issues. Managed lifecycle elements of ETL development, from robust testing to final deployment. Gathered analytics data using different sources.

Worked on Replicating BW data flow using Azure Data Factory. Had worked on creating views in Databricks using PySpark and SQL. Have in-depth experience of using filters and creating different views – Attribute views, Analytic views & Calculation View. Developing CDS Views,ADSO, Info Objects. Creating Master Data Infoobject as Infoprovider. Using Time dependent attributes to load data sets which are Time dependent. Functional Unit Testing, Unit Testing and its documentation. Data Loading and creation of Info Package, Transformation and DTP.