Snowflake Developer
Roles & Responsibilities
- Created various stages like internal/external stages to load data from various sources like S3 and on-premise systems.
- Design, develop, and maintain DBT models, transformations, and SQL code to build efficient data pipelines for analytics and reporting.
- Responsible for all activities related to development, implementation, and support of ETL processes for large-scale Snowflake cloud data warehouse.
- Loading data into Snowflake tables from internal stage and on the local machine.
- Used import and export from the internal stage (Snowflake) vs external stage.
- Writing complex Snow SQL scripts in Snowflake cloud data warehouse for Business Analysis and reporting.
- Responsible for all activities related to development, implementation, administration, and support of ETL processes for large-scale data warehouses using Snowflake cloud Data warehouse.
- Create task flows to automate the data loading/unloading to/from Snowflake data warehouse and AWS S3
- Writing complex SQL scripts in the Snowflake data warehouse to support Business reporting
- Creating automated scripts to load data from Snowflake to though the spot server.
- Perform troubleshooting analysis and resolution of critical issues