Kumaresh Arunagiri

More than 3.6 years of professional experience in Information Technology with progressive development and implementation of various Data Warehousing projects. Exhibited proficiency in configuring Snowpipe to enable smooth data integration between AWS Cloud and Snowflake database. Hands-on experience with SQL, Snowpipe, ELT processes, micro-partitions, cache, time travel, various Snowflake table and stage types, streams (CDC), tasks, zero-copy cloning, secure and materialized views, data masking, data sharing, external tables, sequences, stored procedures, and UDFs.

Skilled in utilizing Snowflake's native capabilities to handle semi-structured data formats, such as JSON. Well-versed in dimensional modeling, incremental data loads, dbt macros, materializations, testing, model management, and CI/CD workflows. Worked within Agile delivery processes, contributing to iterative and incremental development cycles.

SNOWFLAKE DEVELOPER - OMEGA HEALTHCARE SOLUTIONS - TRICHY

(2022-10 - 2026-04)

Project: New York based Healthcare Data Project Using Snowflake, AWS. Domain: Healthcare. Environment: Snowflake DB, AWS S3.

• Designed and implemented scalable Snowflake data warehousing solutions, improving data processing efficiency and performance.
• Developed and managed Snowflake objects including databases, schemas, tables, views, stages, pipes, and warehouses, ensuring robust data governance and architecture.
• Executed large-scale data migration and ingestion pipelines using Snowflake stages and COPY operations with effective error handling and optimization techniques.
• Built and optimized incremental data loading strategies, significantly enhancing performance for high-volume data processing.
• Processed and transformed semi-structured data (JSON) using VARIANT data type and flattening techniques for efficient querying and analytics.
• Developed stored procedures, UDFs, and UDTFs in Snowflake to automate workflows and enable advanced data transformations.
• Designed and maintained dbt models (staging, dimension, and fact tables) with testing, snapshots, and CI/CD practices to ensure data quality and reliability

BSc - Computer Science - Bishop Heber College (2016 - 2019)