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
Similar Profiles
PRAKASH NARAYANA VIGNESH BPRAKASH NARAYANA VIGNESH B
Business Analyst- Technical Lead at Cognizant technology SolutionsBusiness Analyst- Technical Lead at Cognizant technology Solutions