Gowri Bk

Have 2+ years of experience in working in Snowflake data migration with ETL build and transformation tools using python scripts.

Comprehensive knowledge of Snowflake Data Warehouse, including architecture, data processing.

 Comprehending Snowflake’s Information Schema and the process of executing queries with it.

 Utilizing zero-copy cloning with time travel in Snowflake for:

 Data recovery- Restoring data related objects(tables) that may have been accidently deleted.

 Duplicating and backing up data- during manipulation over specified periods of time.

 Experience with performance tuning of Snowflake data warehouse with Caching and Virtual data warehouse scale out, scale up and scale down in multi-cluster warehouse.

Converted SQL scripts from Teradata to Snowflake.

 Developed the transformation scripts for dimension and fact tables as mentioned in Informatica.

 Converted the KSH files to equivalent SH and Python scripts.

 Developed Control-M jobs to schedule the Snowflake jobs.

 Categorized layers in Snowflake as per the requirement (Stage, Core) wherein stage table contains the actual data that is in source, whereas Core table consists of Dimensions and facts which are built in Data Model.