Snowflake Lead- R01551460

About Brillio:

Brillio is one of the fastest growing digital technology service providers and a partner of choice for many Fortune 1000 companies seeking to turn disruption into a competitive advantage through innovative digital adoption. Brillio, renowned for its world-class professionals, referred to as "Brillians", distinguishes itself through their capacity to seamlessly integrate cutting-edge digital and design thinking skills with an unwavering dedication to client satisfaction.

Brillio takes pride in its status as an employer of choice, consistently attracting the most exceptional and talented individuals due to its unwavering emphasis on contemporary, groundbreaking technologies, and exclusive digital projects. Brillio's relentless commitment to providing an exceptional experience to its Brillians and nurturing their full potential consistently garners them the Great Place to Work® certification year after year.

Lead Data Engineer

Primary Skills

ETL Fundamentals, Zero Copy Cloning, SQL, SQL (Basic + Advanced), Python, Data Warehousing, Snowflake Data Exchange, Time Travel and Fail Safe, Snowpipe, SnowSQL, Modern Data Platform Fundamentals, Data Modelling Fundamentals, PLSQL, T-SQL, Stored Procedures

Job requirements

" Role is open for Full time hiring only. Role is not open for sponsorship"

Lead Data Engineer/ Snowflake Lead

10 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.

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 Snow pipe.

Snow SQL Experience in developing stored Procedures writing Queries to analyze 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 modelling 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.

Know what it’s like to work and grow at Brillio: Click here

Salary: 135,000-150,000 USD per year salary