Summary
Overview
Work History
Education
Skills
Personal Detail
Declaration
Timeline
Generic

Kathiresh P V M

Chennai

Summary

  • Around 4.6 years of professional experience in Information Technology with progressive development and implementation of various Data Warehousing projects.
  • Snowflake: Hands-on experience in Snow sight, Snow SQL, File Ingestion, Different Stages and Tables, Loading the data from AWS, Multi-Cluster warehouse, Copy Into command, Snow Pipe, Resource Monitor, Micro-Partition, Cache, Time Travel, Stream (CDC), Task, Zero Copy Cloning, Secured View, Materialized View, Data Masking, Data Sharing, External Table, Sequences, Stored Procedure, UDFs.
  • SQL: Strong Proficient in SQL and creation / modification of database objects like different clauses, Operators, Scalar Functions, Group Functions, Windows Functions, Context Functions, Table Functions – Validation, Validation Mode, Validation Pipe Load, Common Table Expression, Joins and Sub queries.
  • AWS: Good Knowledge on Amazon Web Services (AWS), Integration between the AWS and Snowflake, Hands-on experience in storing the data to S3 location, providing the access to other roles using IAM.
  • Expert in Performing DDL, DML Operations as per the business requirement.
  • Having Good experience on external tables, altered tables to add columns, properties, Constrains, Sequences as per requirement.
  • Worked in multiple environments like DEV, QA, PROD.
  • Extensive experience in Querying using Joins, Sub queries and correlated sub queries, Analytical functions to retrieve data from database.

Overview

5
5
years of professional experience

Work History

Snowflake Developer

Cognizant Technology Solutions
02.2022 - 02.2024
  • Data Migration from Oracle Database to Snowflakes using Flat files for application Migration from Oracle DB to Snowflake.
  • Experience in Snowflakes Object Development such as warehouses, Schemas, Database, Tables, Views, Pipes, Stages, Scaling Policies.
  • Utilization, Roles. Data migration for Structured Data: By creating Stage & Copy, Transforming.
  • Data, Copy on Error, File Format & all Copy Options.
  • Have hands on Experience on Loading Unstructured data on minimal load using VARIANT Datatype, Flatten, Parquet, etc.
  • Developed Snowflake Procedures, Functions and UDTF (User Defined Table Function).
  • Created External table to access the data from the files, when the file access is denied in AWS S3.

Snowflake Developer

Yoho Technologies
08.2019 - 02.2022
  • Created PL/SQL packages, procedures, functions, triggers, and exception handling for retrieving, manipulating, checking and migrating complex data sets.
  • Optimize query and performance tuning using indexing, partitioning, tracing query, collections in oracle PLSQL.
  • Converted the business need into technical complex SQL queries and sub queries 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

ME -

Anna University
Chennai
06.2015

Skills

  • Database: Snowflake,Data Warehouse, SQL
  • Cloud: AWS, Snowflake
  • Microsoft: Word, Excel, PowerPoint
  • Tools: Oracle,IICS,Auto Sys,Jira,Git,Jenkins
  • OS: Windows

Personal Detail

Date of Birth : 26.07.1992

Married Status : Married

Nationality : Indian

Languages Known : English, Tamil

Declaration


I do hereby declare that the above information is true to the best of my knowledge and belief.


Date:

Place:                                                                                                                                                                                                           Kathiresh P V M

Timeline

Snowflake Developer

Cognizant Technology Solutions
02.2022 - 02.2024

Snowflake Developer

Yoho Technologies
08.2019 - 02.2022

ME -

Anna University
Kathiresh P V M