Snowflake Developer

JOB DESCRIPTION:

Mandatory - Snowflake Developer, SQL, AWS, Python

Bachelor's degree or foreign equivalent required from an accredited institution. At least 4 years of experience with Information Technology

At least 1 year of experience with Snowflake utilities, Snow SQL, Snow Pipe and developing stored Procedures

At least 3 years of experience in AWS and Python languages

At least 2 years experience working with tools to automate CI/CD pipelines (e.g., Experience in Data Analysis, Data Migration, Data Validation, Data Cleansing, Data Verification, identifying data mismatch, Data Import, and Data Export using multiple ETL tools such as Informatica, DataStage, Teradata, Talend

Good in Snowflake advanced concepts like setting up Resource Monitors, Role Based Access Controls, Data Sharing, Cross platform database Replication, Virtual Warehouse Sizing, Query Performance Tuning, Snow Pipe, Tasks, Streams, Zero- copy cloning etc.

Performance tuning of the databases to ensure optimal reporting user experience.

Design and developed end-to-end ETL process from various source systems to Staging area, from staging to Data Marts and data load.