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

Zensar Technologies; Pune District; On-site; INR 1,500,000 - 2,800,000; Full time

Job summary

Zensar Technologies is seeking a skilled Snowflake Developer to design, develop, optimize, and maintain enterprise data warehouse solutions on the Snowflake platform. The ideal candidate will have strong expertise in data warehousing, ETL/ELT development, SQL optimization, cloud technologies, and data integration.

Responsibilities include building and optimizing Snowflake databases, pipelines, and models; developing ELT/ETL workflows using Informatica, Matillion, Talend, ADF, or dbt; and

Qualifications

• Bachelor's or master's degree in CS/IT/Engineering.
• 3+ years of data engineering/data warehousing experience.
• 2+ years Snowflake development experience.
• Snowflake Certification is a plus.

Responsibilities

• Design, develop, and maintain Snowflake data pipelines.
• Build and optimize Snowflake databases, schemas, tables, views, and stored procedures.
• Develop ELT/ETL workflows with Informatica, Matillion, Talend, or dbt.
• Implement data modeling with Star and Snowflake schemas.
• Develop and optimize complex SQL queries for data transformation and reporting.
• Integrate data from ERP, relational DBs, APIs, and cloud storage.
• Monitor performance and troubleshoot Snowflake issues.
• Enforce data security, governance, and RBAC.
• Collaborate with data engineers, analysts, architects, and stakeholders.
• Support CI/CD and DevOps practices for data projects.

Skills

Snowflake Data Cloud

Advanced SQL

ETL/ELT

Data Warehousing

Python

Shell Scripting

Java

dbt

Airflow

Informatica

Matillion

Talend

AWS/Azure/GCP

Snowpipe/Streams & Tasks

Stored Procedures/UDFs

Education

Bachelor's or master's degree in Computer Science / IT / Engineering

Snowflake Certification (preferred)

Tools

AWS

Azure

GCP

Snowpipe

Streams & Tasks

Dynamic Tables

Materialized Views

Cloning & Time Travel

Stored Procedures

UDFs

Informatica

Matillion

Talend

dbt

Airflow

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

• Azure Data Factory (ADF),dbt – primary skill
• Snowflake
• Oracle ERP or other ERP experience
• PL/SQL,ETL
• 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

• 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

About Us

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.