Snowflake data engineer

Title- Snowflake data engineer

Experience - 6 years

Location -Bangalore, Chennai, Gurgaon, Pune, Kolkata,

Job Overview:

Snowflake Data Engineer

Key Responsibilities:

• Design and implement scalable data warehouse solutions using Snowflake.
• Develop complex SQL queries for analytics, reporting, and data transformation.
• Build and maintain robust ELT/ETL pipelines using Snowflake-native capabilities and external tools like ADF or Airflow.
• Apply dimensional modeling techniques (Star/Snowflake schemas) to support BI and analytics.
• Optimize performance and manage compute costs through profiling and tuning.
• Manage Snowflake objects including tables, views, materialized views, streams, tasks, UDFs, and stored procedures.
• Ensure data quality, governance, and lineage across the data lifecycle.
• Collaborate with cross-functional teams to gather requirements and build scalable data solutions.
• Troubleshoot issues related to data ingestion, transformation, and query performance.
• Stay up-to-date with Snowflake features like Time Travel, Zero Copy Cloning, Search Optimization, and CDC via Streams/Tasks.

Required Skills:

• Advanced SQL:

  Joins, CTEs, window functions, recursive queries, analytical functions.

• Snowflake Architecture:

  Virtual warehouses, micro-partitions, clustering, scaling, caching.

• Data Modeling:

  Star/Snowflake schemas, normalization/denormalization strategies.

• Performance Tuning:

  Query optimization, result caching, warehouse sizing.

• ETL/ELT Development:

  Using Snowflake-native features and orchestration tools like ADF or Airflow.

• Stored Procedures & Scripting:

  Experience in SQL and JavaScript-based procedures and functions within Snowflake.

Preferred Experience & Tools:

• Azure Data Factory (ADF):

  Pipelines, triggers, linked services, and integration with ADLS Gen2.

• Programming Skills:

  Python or PySpark for data transformation and automation.

• Snowpipe & Streams/Tasks:

  Real-time ingestion and Change Data Capture (CDC).

• Data Security:

  Implementation of row-level security, masking, and encryption.

• DevOps Practices:

  Familiarity with Git, CI/CD pipelines, and Terraform (basic level).

Bonus/Value-Add Skills:

• Strong analytical and problem-solving abilities.
• Excellent communication and documentation skills.
• Agile/Scrum methodology experience.
• Leadership or mentoring experience.
• Ability to manage priorities in fast-paced, multi-project environments.