PROFESSIONAL SUMMARY
Overview
Work History
Education
Skills
Certification
Timeline

Mohith Sai Ram Reddy

Educational Initiatives
Hyderabad,TS
1
Certification
2
years of professional experience

Results-driven Data Engineer with over two years of production experience in designing robust Snowflake data warehouses, implementing Kafka-based CDC pipelines, and executing dbt-driven transformations. Strong foundation in dimensional modeling techniques, including Kimball methodologies, SCD Type 2, and star schema designs, leading to a promotion to SDE-2 within one year. SnowPro Core certified and currently expanding expertise in PySpark, Delta Lake, and Databricks. Demonstrated ability to deliver measurable impact through a 50% increase in pipeline performance, approximately $575 in monthly cost savings, and analytics support for over 30,000 users.

Work History

SDE-2, Data Engineering

11 Months
Educational Initiatives | 07.2025 - Current
  • Implemented a Change Data Capture (CDC) pipeline from PostgreSQL into Snowflake using Kafka and Snowflake Streams, enabling real-time incremental loads and eliminating full-refresh overhead on production tables.
  • Hardened pipeline reliability through automated Kafka failure alerting, dbt-based data-drift detection, and automatic schema-change propagation — shifting issue detection from reactive to proactive, alert-driven response.
  • Owned the end-to-end data pipeline lifecycle across 70+ tables in dev/staging/prod environments, reducing data delivery failures and improving SLA adherence for downstream analytics consumed by 30,000+ users.

SDE, Data Engineering

1 Year
Educational Initiatives | 07.2024 - 07.2025
  • Architected an event-driven ingestion platform (Kafka, Airbyte, dbt, AWS Lambda, Snowflake) supporting ~8M daily events with sub-minute latency, replacing hourly batch with near-real-time pipelines — expanding the org from batch to streaming.
  • Designed a Kimball-style Snowflake warehouse with star-schema fact/dimension tables and SCDs across raw, staging, and datamart layers, powering analytical dashboards for 30,000+ users across schools and institutions.
  • Built automated reporting pipelines (Parent & Principal Reports) leveraging the Snowflake star-schema warehouse, delivering school-level performance benchmarking to 30,000+ users and 500+ institutions with daily refresh SLAs.

Data Engineering Intern

6 Months
Educational Initiatives | 01.2024 - 07.2024
  • Re-architected the Parent Report ETL workflow around Amazon S3 as an intermediate layer, removing the Redshift dependency entirely and cutting report generation lag time by 50% — reducing cloud infrastructure costs by ~$575/month with no impact on data quality or delivery SLAs.
  • Developed Python and SQL-based ETL scripts to extract, transform, and load data from MySQL into a ClickHouse data warehouse, consolidating data from multiple source systems.

Education

B.Tech - Computer Science Engineering

Amrita Vishwa Vidyapeetham | Kollam | 01-2024
GPA: CGPA 8.22 / 10

Skills

Data Engineering: Apache Kafka
Apache Airflow
dbt
Airbyte
ETL/ELT
CDC
batch & real-time ingestion
data quality frameworks
Data Modeling: Kimball dimensional modeling
star schema
Slowly Changing Dimensions (SCD Type 2)
medallion architecture
Databases & Warehousing: Snowflake
PostgreSQL
ClickHouse
MySQL
Delta Lake
Big Data & Processing: PySpark
Databricks
Auto Loader
Delta MERGE
Z-Order
performance optimization
Cloud & Infrastructure: AWS (S3
Lambda)
Docker
GitHub Actions (CI/CD)
Programming & Tools: Python
SQL
Bash
Git
Linux
Data engineering

Certification

  • SnowPro Core
  • SnowPro Associate: Platform
  • Google Associate Cloud Engineer
  • Databricks Certified Data Engineer Associate (in progress, Jun 2026)

Timeline

SDE-2, Data Engineering

Educational Initiatives
07.2025 - CurrentRead More

SDE, Data Engineering

Educational Initiatives
07.2024 - 07.2025Read More

Data Engineering Intern

Educational Initiatives
01.2024 - 07.2024Read More

Amrita Vishwa Vidyapeetham

B.Tech from Computer Science Engineering
Read More
Mohith Sai Ram Reddy