Description
We are seeking a skilled Snowflake Developer to design, develop, optimize, and maintain enterprise data warehouse solutions on the Snowflake platform. The ideal candidate should have solid expertise in data warehousing, ETL/ELT development, SQL optimization, cloud technologies, and data integration.

Responsibilities
- Design, develop, and maintain data pipelines using Snowflake.
- Build and optimize Snowflake databases, schemas, tables, views, and stored procedures.
- Develop ELT/ETL workflows using tools such as Informatica, Matillion, Talend, ADF, Airflow, or dbt.
- Implement data modeling techniques including Star Schema and Snowflake Schema.
- Develop and optimize complex SQL queries for data transformation and reporting.
- Integrate data from various sources including relational databases, APIs, cloud storage, and third-party applications.
- Monitor and troubleshoot Snowflake performance issues.
- Implement data security, governance, and access controls using Snowflake RBAC.
- Collaborate with Data Engineers, Business Analysts, Architects,



and Stakeholders to understand business requirements.
- Ensure data quality, integrity, and compliance with organizational standards.
- Support CI/CD implementation and DevOps practices for data engineering projects.

Qualifications
- Strong experience with Snowflake Data Cloud.
- Advanced SQL programming and query optimization.
- Experience with ETL/ELT development.
- Knowledge of Data Warehousing concepts and dimensional modeling.
- Experience with cloud platforms:
- AWS
- Azure
- Google Cloud Platform (GCP)
- Hands-on experience with:
- Snowpipe
- Streams & Tasks
- Dynamic Tables
- Materialized Views
- Cloning & Time Travel
- Stored Procedures
- User Defined Functions (UDFs)
- Experience with Python, Shell Scripting, or Java.
- Familiarity with dbt, Airflow, Azure Data Factory, Informatica, or Matillion.

Preferred Skills
- Performance tuning and cost optimization in Snowflake.
- Data Lake integration.
- BI t

📌 DE&A - Core - Cloud Data Engineering - Snowflake Developer (Pune)
🏢 Zensar Technologies
📍 Pune