Yahoo Finance to Snowflake with Airflow
Automated ELT pipeline that downloads AAPL price history from Yahoo Finance, saves CSV to S3, loads Snowflake, and triggers Metabase to rescan dashboards. Orchestrated with Apache Airflow.

Certified Data professional with experience in building scalable data solutions and automated workflows.
Data Engineer with experience across AWS, Azure, Snowflake, and Databricks. Built ELT and streaming pipelines, implemented data governance with row level security and IAM roles, and enabled analytics with dbt and BI tools. Interested in ML applications in production data systems.
Automated ELT pipeline that downloads AAPL price history from Yahoo Finance, saves CSV to S3, loads Snowflake, and triggers Metabase to rescan dashboards. Orchestrated with Apache Airflow.
Integrated S3 bronze and silver layers with Redshift Serverless for gold analytics. Automated near real time pipelines with Glue, Lambda, SQS, and SNS. Centralized metadata with Glue and enabled predictive modeling with SageMaker.
Deployed real time streaming pipelines with Confluent Kafka and Databricks. Implemented Snowpipe ingestion and built dbt models with SCD Type 2 snapshots and materialized views to support ad hoc analysis.
Engineered lakehouse architecture with ACID guarantees and tuned Spark to reduce runtime. Applied partitioning and bucketing strategies to improve processing efficiency.
Remote, Sep 2024 to Present
Remote, Apr 2024 to Dec 2024
Ahmedabad, Sep 2022 to Nov 2022
Ahmedabad, Jan 2021 to Aug 2022
Email: connect2.divy@gmail.com
Location: Ontario, Canada