K. Mahanth
Bengaluru
Summary
Snowflake Developer with 5+ years of experience in building and managing scalable data pipelines using Snowflake, AWS S3, and dbt. Skilled in developing efficient ETL/ELT workflows, handling full and incremental data loads, and optimizing data models for analytics. Strong background in cloud data warehousing, SQL performance tuning, and delivering reliable, production-ready data solutions.
Overview
7
7
years of professional experience
Work History
Associate Data Analyst
Novo Nordisk
Bangalore
03.2023 - 12.2025
- Designed and maintained enterprise-scale Snowflake data warehouse handling of structured and semi-structured data.
- Built optimized dbt models with incremental loading, tests, and documentation, reducing query runtime by 40%.
- Implemented Snowpipe and auto-ingest pipelines to load real-time data from AWS S3.
- Designed star and snowflake schemas for analytics use cases across finance, sales, and operations.
- Tuned warehouse performance using clustering, caching, and workload optimization.
- Worked closely with data analysts to build analytics-ready datasets used in Tableau and Power BI.
- Automated data quality checks and monitoring using dbt tests and custom SQL frameworks.
- Reduced Snowflake compute cost by 25% through warehouse right-sizing and query optimization.
Data Analyst
Tata Consultancy Services
Bangalore
12.2021 - 09.2022
- Built a centralized data warehouse consolidating data from CRM, ERP, and marketing platforms.
- Designed dbt models with incremental loading and snapshots.
- Implemented Snowpipe with S3 event notifications.
- Processed streaming data with near real-time availability.
- Reduced data latency from hours to minutes.
- Analyzed warehouse usage patterns.
- Introduced auto-suspend and workload-based warehouses.
- Achieved 30% monthly Snowflake cost savings.
Analyst
Stratogent Technology Services
Bangalore
02.2019 - 07.2021
- Developed complex SQL transformations and stored procedures for data ingestion pipelines.
- Built end-to-end ETL workflows using AWS Glue and Python.
- Migrated on-premises databases to Snowflake, improving performance and scalability.
- Worked on semi-structured data (JSON, XML) using Snowflake VARIANT columns.
- Collaborated with business teams to translate reporting requirements into scalable data models.
- Ensured data accuracy, lineage, and documentation across datasets.
Education
Bachelor of Technology - Electronics And Communication
SRM University
Chennai09-2018
Skills
- Snowflake
- SQL
- DBT
- AWS
- Azure
- Airflow
- Tableau
- Power BI
Accomplishments
- The Ingenious Quarterly Award
- Customer favorite quarterly award
- Monthly High Flier Awards
Timeline
Associate Data Analyst
Novo Nordisk
03.2023 - 12.2025
Data Analyst
Tata Consultancy Services
12.2021 - 09.2022
Analyst
Stratogent Technology Services
02.2019 - 07.2021
Bachelor of Technology - Electronics And Communication
SRM University