Data Engineer
- Posted a month ago
- Be among the first 20 applicants
Job Description
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 Info
Key Skills
SnowSQL
Tasks
Data Lake Integration
About Company
Skills:
containerization , Github, Graphql, Database Development, Data Modeling, Docker, Restful Apis, Python, Index maintenance, Advanced SQL queries, Stored procedures, Query performance tuning, Data warehousing principles, WebSockets
Skills:
Ms Excel, Power Bi, SAS, Tableau, Sql
Skills:
Hive, Hadoop, Gcp, Pyspark, Spark, Sql
Skills:
S3, Github, Pyspark, Lambda, Ec2, Kinesis, Docker, Shell scripting, Python, AWS, Scala, Redshift, Sql, Git, Kubernetes, GenAI, Airflow, AI coding assistants, LLM tools, RAG pipelines, LangChain, prompt engineering, dbt, Glue, LlamaIndex
Skills:
Scala, Python, Sql, AWS, Airflow