Ashok K

Having around 7.10 years of Total IT Experience, 4+ years of snowflake cloud data warehouse Experience with Snowflake Datawarehouse, deep understanding of Snowflake architecture and processing. Experience with performance tuning of Snowflake data warehouse with Query Profiler, Caching and Virtual data warehouse scale out, scale up, scale down in multi cluster warehouse. Created Clone objects to maintain zero copies in Snowflake. Handling large and complex data sets like JSON, PARQUET, CSV files from various sources like AWS S3. Hands-on experience in bulk loading and unloading data into Snowflake tables. Proficient in understanding business processes/requirements and translating into technical requirements. Extensively worked in ETL process consisting of data transformation, data sourcing, mapping, conversion along with data modelling. Expertise in Snowflake Zero-copy cloning, Swap and Time Travel. Experience in Dynamic data masking and Data Sharing in snowflake. Experience in building views, secure views, materialized views, and stored procedures Advanced SQL skills including complex Joins, clone, views, Materialized views etc. Have done source system Analysis, mapping analyses, and end to end Data lineage analyses. Ability to work independently and as a team with a sense of responsibility, dedication, commitment and with an urge of learning new technologies. Experience in Dynamic data masking and Data Sharing in snowflake. Experience in building views, secure views, materialized views and stored procedures. Extensively worked on Altering Parameters at ACCOUNT level. Extensively worked Snowflake platform setup like Databases, Schemas etc. writing and maintaining dbt models, tests, and documentation by using DBT in Snowflake. Defining, managing, and monitoring data pipelines, including tasks like designing Directed Acyclic Graphs (DAGs), troubleshooting issues, and ensuring workflows run smoothly by using Airflow. Managing code repositories, collaborating with others through pull requests and issues, and potentially automating tasks with GitHub Actions.