Description
Location: Bangalore
Experience: 6 - 9 Years

Job Summary:

We are seeking a highly skilled Cloud Data Warehouse Developer with deep expertise in the Snowflake ecosystem. In this role, you will be responsible for designing, building, and optimizing our enterprise data warehouse infrastructure. You will architect robust ELT (Extract, Load, Transform) pipelines, manage semi-structured data at scale, and ensure our data models are structured for high-performance business intelligence.

The ideal candidate understands how to leverage Snowflake’s decoupled storage and compute architecture to deliver fast, scalable, and cost-effective data solutions.
Key Responsibilities 1. Data Architecture & Modeling
- Design and implement scalable, high-performance data models (Star Schema, Snowflake Schema, or Data Vault 2.0).
- Define and manage Snowflake objects including databases, schemas, tables, views, materialized views, and user-defined functions (UDFs).
- Architect end-to-end data pipelines from raw ingestion zones to analytics-ready data marts.

2. Pipeline Engineering & ELT




- Develop and maintain automated, continuous data ingestion pipelines using Snowpipe, Streams, and Tasks.
- Write complex, optimized SQL and utilize Snowpark (Python/Java) to drive data transformations.
- Ingest and parse diverse data formats, including structured relational data and semi-structured payloads (JSON, Parquet, XML) using Snowflake’s VARIANT type.

3. Performance Tuning & Cost Management
- Monitor and optimize query performance using the Query Profile tool, implementing clustering keys and search optimization where necessary.
- Manage and configure Virtual Warehouses (sizing, multi-cluster settings, and auto-suspend limits) to optimize performance while strictly controlling credit consumption.
- Implement Zero-Copy Cloning for productive development and testing environments without duplicating storage costs.

4. Governance & Security
- Implement robust security frameworks utilizing

📌 Data warehouse Dev with AWS- BLR (India)
🏢 Photon Group
📍 India