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 strong expertise in data warehousing, ETL/ELT development, SQL optimization, cloud technologies, and data integration.

- 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.
- Solid 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 tools knowledge (Power BI, Tableau, Looker).
- Git, CI/CD, and Agile methodologies.

Qualifications

- Bachelor's or master's degree in computer science, Information Technology, Engineering, or related field.
- 3+ years of experience in Data Engineering/Data Warehousing.
- 2+ years of hands-on Snowflake development experience.
- Snowflake Certification is a plus:
- SnowPro Core Certification
- SnowPro Advanced Certifications

Experience Level

- 6+ years of IT experience
- 4+ years of Snowflake and Data Engineering experience

Nice to Have

- Experience with migration from on-premise data warehouses to Snowflake.
- Exposure to Data Mesh/Data Fabric architecture.
- Knowledge of Data Governance and Master Data Management (MDM).
- Experience working in Banking, Retail, Healthcare, Manufacturing, or Telecom domains.

Key Competencies

- Analytical and problem-solving skills
- Communication and stakeholder management
- Performance optimization mindset
- Attention to detail
- Team collaboration and ownership

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