Data Engineer - Snowflake DB

<p><p><b>Senior Data Engineer, Snowflake</b><br/><br/><b>About the Role :</b><br/><br/>We're looking for a passionate and skilled Senior Data Engineer to join our growing data team in Gurgaon.

This is an on-site position requiring you to work from our office five days a week.

You will be instrumental in building and optimizing our data platform, leveraging the full power of Snowflake to deliver high-quality, reliable data solutions.

If you have a solid background in ETL/ELT development and a knack for creating efficient data pipelines, we want to hear from you.<br/><br/><b>Responsibilities :</b><br/><br/>- Develop and Maintain Data Pipelines : Design, build, and maintain robust ETL/ELT pipelines using native Snowflake features like Tasks, Streams, and Stored Procedures.<br/><br/>- Data Modeling and Optimization : Design and implement scalable data models, applying best practices such as clustering keys and optimizing micro-partitioning for improved query performance.<br/><br/>- Real-time and Data Lake Integration : Implement Snowpipe for efficient, real-time data ingestion and integrate with our data lake using external tables.<br/><br/>- Complex Transformations : Develop intricate JavaScript/SQL stored procedures and user-defined functions (UDFs) to perform complex data transformations and business logic.<br/><br/>- Advanced SQL Development : Write and optimize complex SQL queries, utilizing advanced concepts like window functions, Common Table Expressions (CTEs), and pivots.<br/><br/>- Cost Management (Good to Have) : Manage multi-cluster warehouses and implement resource monitors to ensure cost-effective resource utilization and control.<br/><br/><b>Requirements :</b><br/><br/>- Experience : 3-6 years of professional experience in data engineering, with a strong focus on Snowflake development.<br/><br/><b>Technical Skills : </b><br/><br/>- Proven hands-on experience with Snowflake development.<br/><br/>- Strong proficiency in Snowflake SQL and a working knowledge of basic JavaScript stored procedures.<br/><br/>- Hands-on experience with core Snowflake features, including Tasks, Streams, Stages, File Formats, and Time Travel.<br/><br/>- Familiarity with dbt core concepts (models, sources, tests, snapshots).<br/><br/>- Understanding of warehouse sizing, auto-suspend/resume, and general query optimization techniques.<br/><br/>- Familiarity with Snowflake's Role-Based Access Control (RBAC), various data types, and handling semi-structured data (JSON/XML).<br/><br/>- Basic knowledge of the SnowSQL CLI and the Snowflake web interface.</p><br/></p> (ref:hirist.tech)