Open to opportunities

Hemant Gautam

@hemantgautam

Message

Data Engineer / ETL developer specializing in Azure, PySpark and Snowflake.

India

Message

What I'm looking for

I am looking for a hands-on data engineering role building scalable ETL and data platform solutions on Azure and Snowflake, with opportunities for technical ownership and growth.

I am a Data Engineer and ETL developer with over 7 years in IT and 2.6 years focused on data engineering, ETL and cloud data platforms. I design and implement end-to-end data solutions using Azure Data Factory, Azure Databricks, Azure Synapse and Informatica PowerCenter to ingest, transform and load data into data warehouses and data lakes.

I have hands-on experience building data lakes with Azure Data Lake Storage and Blob Storage, developing scalable PySpark applications, and implementing Snowflake features such as SnowSQL, time travel, cloning and tasks. I integrate diverse sources including Oracle, MySQL, Cosmos DB, HDInsight and Snowflake, and monitor pipelines with Azure Monitor and Log Analytics.

I am experienced in data modelling and data warehouse concepts (star/snowflake schemas), CI/CD-enabled data pipelines and GitHub workflows, and have worked across ETL, data migration, data cleansing and real-time streaming solutions. I seek to apply my technical expertise and practical experience to deliver reliable, high-performance data platforms for analytics and reporting.

Experience

Work history, roles, and key accomplishments

Data Engineer/ETL Developer

Aisling Technology

Aug 2022 - Dec 2023 (1 year 4 months)

Implemented end-to-end ETL pipelines on Azure (ADF, Databricks, Synapse) and Informatica PowerCenter to ingest, transform, and load data into Snowflake and Azure Blob Storage, improving data availability and pipeline reliability for insurance analytics.

Azure Data Factory Pyspark Databricks Azure Synapse Snowflake Informatica Azure Storage SQL azure monitor

ETL Developer

Wild Fox Business Advocacy

May 2021 - Jun 2022 (1 year 1 month)

Developed Informatica PowerCenter mappings, sessions, and workflows to support retail chain data warehouse loads, performed data validation and transformations for dimensional models, and supported ETL testing and deployment.

Informatica Oracle MySQL SQL ETL Data Modelling Data Cleaning Unix Git

Manual Tester

W3 Solutions

Jan 2017 - Jul 2018 (1 year 6 months)

Executed functional, regression, and UAT testing for web applications (Optical CRM, MLMProX), prepared test plans and test data, and reported defects to ensure release quality.

Manual Testing SDLC Test Planning Regression Testing UAT Bug Reporting Test Execution

SEO Analyst - Digital Marketing

W3 Solutions

Jan 2017 - Jul 2018 (1 year 6 months)

Managed on-page and off-page SEO activities including link building, content posting, meta tag optimization, and social media promotion to improve site visibility and traffic.

SEO SMO Link Building Meta Tag Optimization Blog Management Image Banner Creation Analytics

Technical Support Associate

Intarvo Technologies Pvt Ltd

Dec 2012 - May 2014 (1 year 5 months)

Managed hotel booking confirmations, coordinated with business development managers on escalations, updated payments and prepared daily/weekly/monthly operational reports to maintain booking accuracy.

Customer Support Reporting Data Entry MS Excel