Zensar Technologies
DE&A - Core - Cloud Data Engineering - Snowflake Developer
Skills
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