DEandA - Core - Cloud Data Engineering - Snowflake Developer

Zensar Technologies; Pune District; On-site; INR 1,200,000 - 2,400,000; Full time

Job summary

Zensar Technologies in Pune, India, seeks a skilled Snowflake Developer to design, develop, optimize, and maintain enterprise data warehouse solutions on the Snowflake platform. You will leverage strong SQL, ETL/ELT, and cloud skills to build scalable data pipelines and data models.

You will collaborate with data engineers, BI teams, and stakeholders to ensure data quality, governance, and security, while supporting CI/CD practices and DevOps for data projects.

Qualifications

• Bachelor's or master's in CS/IT/Engineering
• 3+ years in Data Engineering/Data Warehousing
• 2+ years 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 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

Advanced SQL

ETL/ELT

AWS

Azure

GCP

Python

dbt

Education

Bachelor's or Master's in CS/IT/Engineering

Tools

Informatica

Matillion

Talend

ADF

Airflow

dbt

Job description

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.

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

Qualifications

• Bachelors or masters 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 Zensarand 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.