Hemant Gautam
@hemantgautam
Data Engineer/ETL Developer
Bangalore, India
Hemant is an experienced Data Engineer/ETL Developer with over 7 years in the IT industry, specializing in optimizing data infrastructure using Azure cloud services and Informatica PowerCenter. He is proficient in designing and implementing end-to-end data solutions using Azure Data Factory, Azure Synapse Analytics, and Azure Data Bricks. His expertise includes building data lakes, developing PySpark applications, and writing complex SQL queries across platforms like Oracle, MySQL, and Snowflake.
Experience
Data Engineer/ETL DEVELOPER
Aisling Technology
Worked on Project #1: MAX LIFE INSURANCE. Used Azure Data Factory, Azure Synapse, Azure Data bricks, PySpark, and SQL. Responsible for ETL development for Max Life Insurance Company.
ETL DEVELOPER
WILD FOX BUSINESS ADVOCACY
Ingested data from various sources (databases, files, APIs, streaming platforms) into Azure. Orchestrated ETL of data from on-premises SQL Server to Azure Blob Storage and Snowflake. Performed data transformation (aggregate, join, filter, lookup, pivot) using Azure Databricks or Azure Synapse Analytics. Monitored and troubleshot data pipelines using Azure Monitor.
Manual Tester
DNB management application
Involved in functional study of the application. Performed testing for Optical CRM (inventory, billing, stock, etc.) and MLMProX (multi-level and network marketing business). Responsibilities included test planning, test design, test execution, and regression testing.
SEO ANALYST - DIGITAL MARKETING
W3 SOLUTIONS
Managed Off Page and On Page SEO tasks, including link building, directory submission, and handling SEO/SMO activities like blog and article posting.
TECHNICAL SUPPORT ASSOCIATE
INTARVO TECHNOLOGIES PVT LTD
Handled customer booking confirmations and updates. Managed payments and interacted with area BD managers regarding stuck bookings.
Education
Bachelor of Computer Application (B.C.A)
Master of Computer Application (M.C.A.)
Licenses & Certifications
Master Microsoft Fabric: A Complete End-to-End Project
Unknown
Azure Databricks & Spark For Data Engineers
Unknown
Azure Synapse Analytics For Data Engineers
Unknown
Azure Data Factory For Data Engineers
Unknown