Rohan Kadu

About Rohan Kadu

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 pipelinesOpen to opportunities in Data Engineering, Snowflake, and AWS-based data platforms.

Experience

1. Data Engineer

   HCLTech

   Dec 2023 — Present · Nagpur, IN

   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

• Rashtrasant Tukadoji Maharaj Nagpur University

  Bachelor of Engineering

• Coding Ninjas

  Data Science and Machine Learning Course , Data Science

• GATE Preparation

  Mechanical Engineering