Summary
Overview
Work History
Education
Skills
Tools
Achievements
Timeline
Generic

Gunaseelan Dhamotharan

Chennai

Summary

Data Engineer with 4+ years of experience in Snowflake data warehouse development and cloud data integration. Proficient in handling data flows between local files, AWS S3, and Snowflake. Experienced in using key Snowflake features like Time Travel, Fail-safe, and Clone for data recovery. Skilled in writing and optimizing complex SQL queries for analytics. Familiar with ITIL processes and hands-on with Streams for capturing DML changes. Actively involved in Agile teams, delivering high-priority tasks and resolving production issues efficiently. Quick learner focused on improving support quality and adopting new technologies.

Overview

4
4
years of professional experience

Work History

Senior Snowflake Developer

Aspire Systems
05.2022 - Current
  • To ensure that data management functioned properly, I set up a variety of components in Snowflake, including warehouses, schema, databases, tables, views, pipes, stages, and scaling policies.
  • Involved creation of the snow stream object to create the audit table data backup of the data whenever the DML is happening on base tables.
  • Used the Clone technique in the snowflake database to take the backup of the data whenever needed.
  • Have hands on Experience on Loading Unstructured data on minimal load using VARIANT Datatype, Flatten, Parquet, etc.
  • Developed innovative solutions inspired by the concept of time travel to optimize project timelines and enhance efficiency.
  • Developed Snowflake Procedures, Functions and UDTF (User Defined Table Function).
  • Collaborated with support team to assist client stakeholders with emergent technical issues and develop effective solutions.

Snowflake Developer

Aspire Systems
08.2021 - 06.2022
  • Have migrated data from Oracle and SQL server to Snowflake Data base using IICS tool. Have created packages, procedures, functions, triggers, and exception handling for retrieving, manipulating, checking and migrating complex data sets through PL/SQL.
  • Optimize query and performance tuning using indexing, partitioning, tracing query, collections in oracle PLSQL.
  • Converted the business need into technical complex SQL queries and subqueries using analytical functions, joins, operators.
  • Created Snow Pipe to read the data from the AWS S3 and loaded the data to Snowflake DB to ensure the continuous data integration between the oracle and snowflake DB.
  • Created snow tasks as task tree to read the data from the snow stream objects which are created on the base table, to maintain the backup of data while happening DML operation in the target snowflake DB.
  • Used secure views and materialized views to share the data to the partner application as per the data requests.

Education

Bachelor of Engineering Technology - Electronics And Communication Engineering

Knowledge Institute of Technology
Salem, India
07-2021

Skills

  • Snowflake SQL
  • AWS S3
  • ETL Concepts
  • Procedures, Functions, and Triggers
  • Agile Development Methodologies
  • Snowflake Objects – Schemas, Views, Pipes, and Stages
  • Data Management – Time Travel and Fail-Safe Mechanism

Tools

  • DBT (Data Build Tool)
  • IICS (Informatica Intelligent Cloud Services)
  • SQL Developer
  • SnowSQL CLI
  • GitHub
  • Azure DevOps
  • Power BI

Achievements

  • Recognized as an Excellent Performer for 3 consecutive years for consistent contributions to Snowflake development , showcasing adaptability, ownership, and eagerness to learn.
  • Contributed to successful data migration and cloud enablement projects , supporting the transition from traditional systems to Snowflake-based architecture.

Timeline

Senior Snowflake Developer

Aspire Systems
05.2022 - Current

Snowflake Developer

Aspire Systems
08.2021 - 06.2022

Bachelor of Engineering Technology - Electronics And Communication Engineering

Knowledge Institute of Technology

Similar Profiles

CREATE PROFILE
Gunaseelan Dhamotharan