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

Posted 24 Days Ago
Be an Early Applicant
Pune, Mahārāshtra, IND
In-Office
Senior level
Information Technology
The Role
Designs, develops, optimizes, and maintains Snowflake data warehouse solutions and data pipelines. Builds ETL/ELT workflows, dimensional data models, SQL transformations, integrations, and Snowflake database objects. Responsibilities include performance tuning, data security, governance, quality assurance, troubleshooting, and CI/CD support. Collaborates with engineers, analysts, architects, and stakeholders to deliver enterprise data solutions.
Summary Generated by Built In
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
  • 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 UsAt 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.

Skills Required

  • Strong experience with Snowflake Data Cloud
  • Advanced SQL programming and query optimization
  • Experience with ETL/ELT development
  • Knowledge of data warehousing and dimensional modeling
  • Experience with AWS, Azure, or Google Cloud Platform
  • Hands-on experience with Snowpipe, Streams and Tasks, Dynamic Tables, Materialized Views, Cloning and Time Travel, Stored Procedures, and User Defined Functions
  • Experience with Python, Shell Scripting, or Java
  • Familiarity with dbt, Airflow, Azure Data Factory, Informatica, or Matillion
  • Performance tuning and cost optimization in Snowflake
  • Data Lake integration experience
  • Knowledge of Power BI, Tableau, or Looker
  • Git, CI/CD, and Agile methodologies
  • Bachelor's or master's degree in computer science, information technology, engineering, or a related field
  • At least 3 years of data engineering or data warehousing experience
  • At least 2 years of hands-on Snowflake development experience
  • Snowflake certification, such as SnowPro Core or SnowPro Advanced
  • At least 6 years of IT experience
  • At least 4 years of Snowflake and data engineering experience
  • Experience migrating on-premise data warehouses to Snowflake
  • Exposure to Data Mesh or Data Fabric architecture
  • Knowledge of data governance and Master Data Management
  • Experience in banking, retail, healthcare, manufacturing, or telecom domains

Zensar Technologies Compensation & Benefits Highlights

The following summarizes recurring compensation and benefits themes identified from responses generated by popular LLMs to common candidate questions about Zensar Technologies and has not been reviewed or approved by Zensar Technologies.

  • Retirement Support — A 401(k) with company match and immediate vesting is highlighted, with broad fund options available.
  • Wellbeing & Lifestyle Benefits — Work-life balance, remote/hybrid flexibility, and supportive teams are emphasized as strengths that enhance the overall experience.
  • Parental & Family Support — Inclusive policies such as parental leave and access to EAP and dependent medical coverage are promoted across regions.

Zensar Technologies Insights

Am I A Good Fit?
beta
Get Personalized Job Insights.
Our AI-powered fit analysis compares your resume with a job listing so you know if your skills & experience align.

The Company
HQ: Pune, Maharashtra
10,000 Employees
Year Founded: 2001

What We Do

Zensar is a leading experience, engineering, and technology solutions company. We conceptualize, build, and manage digital products for Forbes Global 2000 clients across the hi-tech engineering, banking and financial services, insurance, manufacturing and consumer services verticals. With proven excellence across five core areas, including experience services, advanced engineering services, data engineering and analytics, foundation services, and application services, our solutions leverage industry-leading platforms to help our clients be competitive, agile, and disruptive while moving with velocity through change and opportunity. Zensar’s expansive ecosystem of 60+ technology partners, including Oracle, Salesforce, SAP, Guidewire, Automation Anywhere, Adobe, and UiPath, enables us to deliver comprehensive solutions to clients, facilitating seamless integration and allowing them to leverage cutting-edge technologies and tools for enhanced business outcomes. Zensar is part of the USD 4.4 billion RPG Group. With headquarters in Pune, India, our 10,500+ employees, representing over 50 nationalities, work from 30+ locations across North America, UK/Europe, and South Africa. Visit us at www.zensar.com

Similar Jobs

Remote or Hybrid
2 Locations
289097 Employees

Pfizer Logo Pfizer

GSC Quality Management System Lead

Artificial Intelligence • Healthtech • Machine Learning • Natural Language Processing • Biotech • Pharmaceutical
In-Office or Remote
9 Locations
121990 Employees
215K-358K Annually

CSC Logo CSC

Accountant

Fintech • Legal Tech • Software • Financial Services • Cybersecurity • Data Privacy
Remote or Hybrid
2 Locations
8500 Employees

The Aerospace Corporation Logo The Aerospace Corporation

Sr Software Eng Manager

Aerospace • Artificial Intelligence • Cloud • Machine Learning • Software • Cybersecurity • Defense
Remote or Hybrid
2 Locations
4600 Employees

Similar Companies Hiring

NODA AI Thumbnail
Artificial Intelligence • Information Technology • Software • Cybersecurity • Defense • Defense Technology
Austin, TX
54 Employees
Golden Pet Brands Thumbnail
Digital Media • eCommerce • Information Technology • Marketing Tech • Pet • Retail • Social Media
El Segundo, California
567 Employees
RapidScale Thumbnail
Cloud • Information Technology • Consulting
Raleigh, NC
600 Employees

Sign up now Access later

Create Free Account

Please log in or sign up to report this job.

Create Free Account