Source description
About the role
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
More at True Tech Professionals