DE&A - Core - Cloud Data Engineering - Snowflake Developer

Zensar; Pune District; On-site; INR 2,800,000 - 4,200,000; Full time

Job summary

Zensar is seeking a skilled Snowflake Developer to design, develop, optimize, and maintain enterprise data warehouse solutions on the Snowflake platform. You will work across data warehousing, ETL/ELT, SQL optimization, and cloud technologies, collaborating with data engineers and stakeholders to deliver compliant data solutions.

The role requires 4+ years of Snowflake/Data Warehousing experience, strong SQL, and hands-on experience with Snowflake features like Snowpipe, Streams & Tasks, and

Qualifications

• Bachelor's or master's degree in computer science, IT, 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/Advanced).

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.

Skills

Snowflake Data Cloud

SQL optimization

ETL/ELT development

Cloud platforms

Snowpipe

Streams & Tasks

Dynamic Tables

Materialized Views

Cloning & Time Travel

Stored Procedures

UDFs

Python

Shell scripting

Java

dbt

Airflow

Informatica

Matillion

Power BI

Tableau

Looker

Git

CI/CD

Agile methodologies

Education

Bachelor's or Master's degree in Computer Science/Information Technology/Engineering

Tools

AWS

Azure

GCP

Job 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 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.

• 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 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

At Zensar, we’re
“experience-led everything”. We are committed to conceptualizing, designing, engineering, marketing, and managing digital solutions and experiences for over 130 leading enterprises. We are a company driven by a bold purpose:
Together, we shape experiences for better futures. Whether for our clients, our people, or the world around us, this belief powers everything we do. At the heart of our culture is
ONE with Client - a set of four core values that reflect who we are and how we work:
One Zensar, Nurturing, Empowering, and Client Focus.
Part of the $4.8 billion RPG Group, we’re a community of 10,000+ innovators across 30+ global locations, including Milpitas, Seattle, Princeton, Cape Town, London, Zurich, Singapore, and Mexico City. Explore Life at Zensar and join us to Grow. Own. Achieve. Learn. to be the best version of yourself.
We believe the best work happens when individuality is celebrated, growth is encouraged, and well-being is prioritized. We are an equal employment opportunity (EEO) and affirmative action employer, committed to creating an inclusive workplace. All qualified applicants will be considered without regard to race, creed, color, ancestry, religion, sex, national origin, citizenship, age, sexual orientation, gender identity, disability, marital status, family medical leave status, or protected veteran status.