Data Engineer

Snowflake Data Engineer

Location: Gurgaon (5 days working in office) | Experience: 3-6 years

Responsibilities:

• Build ETL/ELT pipelines using Snowflake Tasks, Streams, and Stored Procedures
• Design data models with clustering keys and optimize micro-partitioning
• Implement Snowpipe for real-time ingestion and external tables for data lake integration
• Develop JavaScript/SQL stored procedures and UDFs for complex transformations
• Write complex SQL queries with window functions, CTEs, and pivots
• Manage multi-cluster warehouses and implement resource monitors for cost control ( Good to have)

Requirements:

• Hands-on Snowflake development experience
• Strong Snowflake SQL and basic JavaScript stored procedures
• Working knowledge of Tasks, Streams, Stages, File Formats, Time Travel
• Experience with dbt core concepts (models, sources, tests, snapshots)
• Understanding of warehouse sizing, auto-suspend/resume, and query optimization
• Familiarity with RBAC, data types, and semi-structured data (JSON/XML)
• Basic knowledge of SnowSQL CLI and Snowflake web interface