Amit Sehgal

Amit Sehgal

Senior Data Engineer
UAE

About Me

Senior Data Engineer with close to 10 years building, migrating and operating production Spark batch and near-real-time streaming pipelines in highly governed enterprise environments. Hands-on with PySpark, Spark SQL, Ka…

Experience

Senior Data Engineer (Consultant)

ValueLabs · Dubai
Jan 2025 - Present · 1 year 10 months

<p>Led the SAP HANA decommissioning, migrating BDM workflows to PySpark for 5 banking entities, eliminating SAP licence costs and automating ~180 daily jobs with SQL loads into Oracle.<br>
Built a near-real-time Kafka streaming pipeline on the bank’s centralised streaming platform: consumed events, flattened nested payloads, republished to a new topic and loaded into Oracle via Kafka Connect, deployed through CI/CD with Git.<br>
Engineered an end-to-end ETL pipeline for Wholesale Banking customer deals using PySpark, Kafka and an ODS, standardising approvals and tracking deal expiries for business cost savings.<br>
Designed a parameterised PySpark framework configured through simple YAML files, letting the team replicate ETL jobs quickly and with zero defects.<br>
Manage daily and monthly Cloudera ETL loads across finance sources and pricing structures via Airflow and Oozie, with row-count and reconciliation checks; uses Claude Code for faster delivery with no critical issues.<br>
Parsed nested MongoDB JSON (read-only) with PySpark.</p>

Senior Data Engineer

EPAM Systems
Dec 2021 - Jan 2025 · 3 years 1 month

<p>Built ADLS Gen2 medallion layers (raw, curated) in Parquet over a 100 GB to 1 TB estate, ingesting via ADF, Synapse Pipelines and PySpark, cutting cost and improving reliability and data quality.<br>
Built feature-based ADF pipelines for a new dealer analytics web app, processing 100 GB daily.<br>
Used Azure Synapse Analytics for ~3 years, building major parts of the warehouse: dedicated and serverless SQL pools, Synapse Pipelines, Spark notebooks, dimensional models (fact/dimension), T-SQL stored procedures and warehouse loads, tuned via distribution, indexing and partitioning.<br>
Designed and delivered the migration of enterprise data from legacy Hadoop tables to an Azure Cosmos DB application database, reducing query retrieval times by 40%.<br>
Worked with Business Analysts and Backend Developers to define requirements and design optimised JSON schemas for Cosmos DB.<br>
Also worked with Unity Catalog and Snowflake.</p>

Research and Development Engineer

ABB Global Limited
Feb 2020 - Dec 2021 · 1 year 10 months

<p>Built batch and streaming IoT pipelines with PySpark and Spark Streaming across Azure cloud and on-premises deployments, processing semi-structured telemetry from ActiveMQ and Event Hubs.<br>
Designed a framework to deploy machine learning models on unstructured data (text, images, video), routing predictions to Cosmos DB and MongoDB for downstream analytics.<br>
Developed automated PySpark and SQL ETL jobs to clean and transform data from ADLS Gen2 raw to curated layers (Parquet), scheduled via Rundeck, Azure Pipelines and Azure Data Factory.<br>
Ran Azure Databricks PySpark notebooks orchestrated from Azure Data Factory, and worked with HDInsight, Unity Catalog, Kubernetes with Helm and Docker Compose.<br>
Built Python Flask REST API endpoints for CRUD operations across target data systems, saving an estimated 15 hours of manual effort per week.</p>

Data Engineer

Infosys
Mar 2017 - Feb 2020 · 2 years 11 months

<p>Built a Master Data Management (MDM) solution for PwC with the team, translating complex functional requirements into matching and survivorship rules to identify the golden record.<br>
Developed PySpark ETL workflows to migrate CSV, JSON and MySQL data into an on-premises Cloudera HDFS environment in Parquet format.<br>
Created HDFS-based tables and SQL transformations for the curated layer, scheduled with Cron.<br>
Automated data API testing with Python and Selenium to validate Oracle DB to MongoDB data loads.<br>
Contributed to data warehouse schema design and resolved defects through VSTS (Azure DevOps).</p>

Skills

Apache Spark PySpark Spark SQL Spark Streaming Cloudera Hadoop HDFS Parquet Kafka Kafka Connect Event Hubs ActiveMQ Python SQL T-SQL Shell scripting Flask REST Delta Lake Azure Databricks Delta Live Tables Auto Loader Unity Catalog ADLS Gen2 Data Factory Synapse Analytics HDInsight Medallion architecture Data quality checks Reconciliation checks Data lineage Governance ETL migration Dimensional modelling Master Data Management Airflow Oozie Rundeck Cron CI/CD Azure DevOps Git Docker Kubernetes Helm Oracle SQL Server MySQL Cosmos DB MongoDB Snowflake
Report this Profile?