Divansh Gandhi

Set up data pipelines (ETL) to process data ingestion from application databases and large Data Warehouses to analytical databases. Ingest data from disparate data sources like Teradata, GCP Bigquery, Oracle, Influx DB and used Python to create scripts in Jupyter notebooks and configured the automation DLs using Airflow. Work on establishing data pipelines using Big Data Tools (Hadoop) like Apache Hive, HBase. Manage Production Server and Development server. Work on to improve the efficiency of Production database by implementing various advance SQL techniques. Set up an automation system to monitor the Production Jobs which helps to identity the job failures. Performance Tuning, T-SQL Query Optimization and Solving Blocking issues. Work with business analyst groups to identify the Key Metrics and various Key Risk Indicators (KRIs) and prepare efficient views which could used for building Reports and Dashboards. Work with clients to understand business needs and translate those business needs into actionable reports in Power BI. Develop and Automated ETL processes using Dell Boomi - Integration tool and deployed them using Jenkins (CICD). Develop various Custom Visual Templates in Power BI using Web Development Techniques, saving a lot of efforts while building reports.