Snowflake Developer - Data warehouse

Glan Management Consultancy; Gurugram District; Hybrid; INR 600,000 - 900,000; Full time

Job summary

A leading management consultancy is looking for a Snowflake Developer to manage their data warehouse. This role requires 3-10 years of experience with Snowflake in an AWS environment, alongside skills in data warehousing concepts. Candidates should be well-versed with Snowflake utilities and data modeling best practices. This is a hybrid position based in Gurgaon, and the salary is negotiable based on experience.

Qualifications

• Proven experience with Snowflake Data Warehouse in the AWS ecosystem.
• Ability to analyze production workloads for optimized Snowflake database performance.
• In-depth understanding of Data Warehouse/ODS, Snowflake data modeling, and ELT.

Responsibilities

• Maintain and optimize the data warehouse on Snowflake.
• Plan capacity and manage AWS resources for Snowflake instances.
• Document system setups and liaise with other functions on projects.
• Document system setup, Change Requests, and IT Audit activities

Skills

Snowflake Data Warehouse

Data warehousing concepts

AWS

Python

Tableau

Data modeling

Stored procedures

SnowSQL

SnowPipe

Data warehousing

Data pipelines

Tools

SnowSQL

SnowPipe

Talend

Job description

Share Job :# Snowflake Developer - Data warehouse **Company:** Glan Management Consultancy **Location:** Gurgaon **Experience:** 3-10 year **Salary:** 0 **Employment Type:****Job Description:**Position: Snowflake Developer Location: Gurgaon (Hybrid work) 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. [e-mail]- 8851018162Website: www.glansolutions.comGoogle search: Glan Management consultancy**Key Skill:** Snowflake Developer, Business Intelligence, Data warehousing, Snowflake Data Warehouse, AWS, Snowflake, Tableau ,**Posted on:**4th Aug, 2022### Apply for Snowflake Developer - Data warehouse