Headline

Data Engineer | Snowflake | Apache Airflow | AWS S3 & EC2 | SQL | Python

About

Data Engineer with 2+ years of experience building and maintaining ELT pipelines using Snowflake, Apache Airflow, and AWS. Experienced in developing data ingestion and transformation workflows using Snowpark and SnowSQL, orchestrating batch pipelines, and ensuring data reliability through validation and error-handling mechanisms. Currently working on banking domain data platforms, handling large-scale datasets and delivering analytics-ready data for reporting and business decision-making. Strong foundation in SQL, data warehousing concepts, and workflow optimization in production environments. Skilled in: • Snowflake (Snowpark, SnowSQL) • Apache Airflow orchestration • AWS S3 & EC2 • Python & SQL • Data ingestion and transformation pipelines Open to opportunities in Data Engineering, Snowflake, and AWS-based data platforms.

Location

Nagpur

Work experience

Data Engineer at HCLTech, Dec 2023 - Present · 2 yrs 5 mos, Nagpur, Maharashtra, India, • Developed and maintained 20+ ELT pipelines to ingest and transform data from AWS S3 into Snowflake staging and curated layers. • Built data loading scripts using SnowSQL and transformation logic using Snowpark based on business requirements. • Scheduled and monitored workflows using Apache Airflow DAGs and triggered scripts on EC2 instances. • Optimized DAG scheduling based on vendor file arrival patterns to improve pipeline reliability. • Implemented data validation checks in Airflow DAGs to ensure file readiness, schema consistency, and successful loads. • Enhanced Snowpark and SnowSQL scripts with error-handling logic to improve pipeline stability. • Delivered curated datasets for reporting, analytics, and compliance use cases in the banking domain.

Education

Bachelor of Engineering, Rashtrasant Tukadoji Maharaj Nagpur University

Mechanical Engineering, GATE Preparation