A leading consultancy firm is seeking a Snowflake Developer to manage its data warehouse and optimize AWS resources. This role entails responsibility for data pipeline management and requires strong experience in Snowflake Data Warehouse within the AWS ecosystem. The ideal candidate will understand data modeling, work with Snowflake utilities, and have familiarity with Python and ETL tools. This position offers a dynamic work environment aimed at enhancing business intelligence.
Qualifications
Must have good experience in Snowflake Data Warehouse within the AWS ecosystem.
Ability to analyze production workloads for efficiency in Snowflake.
In-depth understanding of data modeling and ELT principles.
Responsibilities
Maintain data warehouse on Snowflake.
Optimize AWS resources for Snowflake instances.
Document system setups, Change Requests, and conduct IT audits.
Collaborate with other functions on new projects and enhancements.
Skills
Snowflake Data Warehouse
Data modeling
Python
AWS
Shell scripting
Tableau
ETL
Tools
Snowflake
SnowSQL
SnowPipe
Tasks
Streams
Time Travel
Optimizer
Metadata Manager
Data Sharing
Stored Procedures
Talend
Shell Scripting
Job description
Share Job :# Snowflake Developer **Company:** Glan Management Consultancy **Location:** Gurgaon **Experience:** 3-10 year **Salary:** 0 **Employment Type:****Job Description:**Position: Snowflake Developer Location: Gurgaon Experience: 3-10 year salary: negotiable Industry: ITRoles and Responsibilities:Data warehouse plays an important role for the business intelligence and data exchange with other systems. This person will be responsible for managing the data warehouse for the company and managing data pipelines in and out of the data warehouse. This person will be expected to work both independently and in conjunction with a team. Key Responsibilities: · Maintenance of data warehouse on snowflake. · Capacity planning and optimization of AWS resources for snowflake instances. · Documentation related to system setup, Change Requests and IT Audit. · Liasioning with other function on new projects and enhancementsDesired Candidate Profile · Fully well-versed with data warehousing concepts. · Must have good experience in Snowflake Data Warehouse in AWS ecosystem. · Ability to analyse production workloads and develop strategies to run Snowflake database with scale and efficiency. · Must have working experience with Snowflake utilities such as SnowSQL, SnowPipe, Python, Tasks, Streams, Time travel, Optimizer, Metadata Manager, data sharing, and stored procedures. · Must have In-depth understanding of Data Warehouse/ODS, Snowflake, data modeling and ELT using Snowflake SQL and modeling structure principles and best practices with data warehouse. · Good experience in Data warehousing - OLTP, OLAP, Dimensions, Facts, and Data modeling, implementing complex stored procedures and have worked on different file format (JSON, XML, AVRO, Parquet, ORC etc.) · Good to have working knowledge of shell-scripting/python, any ETL tool Talend. · Familiarity with data visualization tool Tableau will be added advantage mail me updated resume with current salary. satish.glanmc@gmail.comsatish- 8851018162Website: www.glansolutions.comGoogle search: Glan Management consultancy### Apply for Snowflake Developer