Snowflake Expert Developer

Experience: 10+ years of Snowflake development experience

Practice: Data Engineering

About the Role

We are seeking a highly experienced Snowflake Expert Developer to lead the design, development, optimization, and management of end-to-end data pipelines on the Snowflake platform. The ideal candidate will have deep expertise in modern data engineering practices and a robust track record of delivering scalable, secure, and high-performance data solutions.

In this role, you will be responsible for building and maintaining data pipelines from ingestion through transformation to consumption, working across batch, micro-batch, and real-time processing patterns . You will leverage the full Snowflake ecosystem to enable efficient, reliable, and governed data operations that support enterprise analytics and business initiatives.

The successful candidate will bring hands-on experience across the Snowflake data engineering stack, a strong understanding of cloud-based data architectures, and the ability to drive solutions from design through production support and optimization.

YOUR PROFILE

What You'll Do

- Design and build end-to-end ELT pipelines following the Stage → Raw → Stream → Task → Target pattern.
- Set up and manage automated, near real-time data ingestion using Snowpipe and low-latency, event-based streaming ingestion using Snowpipe Streaming .
- Configure Internal and External Stages to ingest data from Amazon S3, Azure Blob Storage, and Google Cloud Storage (GCS) ,



including appropriate file formats and External Tables for semi-structured and unstructured data.
- Implement Streams for Change Data Capture (CDC) covering inserts, updates, and deletes, and orchestrate pipelines using Tasks and DAG-based Task Graphs .
- Build SQL-based ELT transformations and Dynamic Tables for continuous transformation pipelines, and extend transformations using Snowpark (Python, Java, or Scala) where required.
- Manage Virtual Warehouses and the broader storage layer, including tables, schemas, and centralized data structures.
- Integrate native connectors such as Kafka and Kinesis , and work with external ETL/ELT tools including Azure Data Factory (ADF), Airbyte, and AWS Glue .
- Leverage Snowflake Openflow for enterprise-scale data integration and CDC use cases.
- Build data validation, monitoring, and pipeline observability capabilities from the outset.
- Apply strong governance, security, and access control best practices across all pipelines, and integrate with Collibra where applicable.

What We're Looking For

- 10+ years of hands-on experience in Snowflake development .
- Working knowledge of Snowflake Openflow, Snowflake CoCo, and Cortex Cost Management .
- Strong expertise in CDC (Change Data Capture) and incremental data processing techniques.
- Experience working with batch, micro-batch, and real-time ingestion patterns.
- A builder's mindset with the ability to own data pipelines end-to-end, from architecture and development through production deployment and monitoring.

📌 Snowflake Expert Developer (Bengaluru)
🏢 adesso India
📍 Bengaluru