Lead Snowflake Engineer - R01542274
Bangalore, Karnataka, India / Hyderabad, Andhra Pradesh, India / Chennai, Tamil Nadu, India / Pune, Maharashtra, India / Gurugram
Data and AI – Data and AI : Data Engineering /
Employee /
Hybrid
Snowflake Lead Engineer
Primary Skills
- Data Modelling Fundamentals, Data Warehousing, DataStream, ETL Fundamentals, Modern Data Platform Fundamentals, PLSQL, Python, Snowpipe, SnowSQL, SQL, SQL (Basic + Advanced), Time Travel and Fail Safe
Secondary Skills
- Matillion
- DBT (Data Build Tool)
Specialization
- Snowflake Engineering: Senior Data Engineer
Job requirements
- 8 +years of industry experience with hands on managing projects in Data Warehousing with a minimum 4 years of experience working on Snowflake
- Bachelor’s degree in computer science, Engineering, or related fields or equivalent practical experience.
- Should have hands on experience with ETL tools (Matillion Preferred) Deep understanding of relational as well as NoSQL data stores, methods and approaches (star and snowflake, dimensional modelling).
- Experience in designing and building manual or auto ingestion data pipeline using Snowpipe.
- SnowSQL Experience in developing stored Procedures writing Queries to analyse and transform data.
- Expertise in Snowflake data modeling, ELT using snowpipe, implementing stored procedures and standard DWH and ETL concepts.
- Should have implement cloud-based Enterprise data warehouse solutions with multiple data platforms along with Snowflake environment to build data movement strategy.
- Should be able to make necessary on-going updates to modeling principles, processes, solutions, and best practices to ensure that the Snowflake is aligned with business needs of the environment.
- Should be able to lead in developing project requirements for end-to-end Data integration process using ETL for Structured, semi-structured and Unstructured Data.
- Expertise in Snowflake concepts like setting up resource monitors, RBAC controls, virtual warehouse, query performance tuning, Zero copy clone, time travel and understand how to use these features.
- #LI-AM3