Zensar Technologies is hiring a Snowflake Developer in Pune to design, build, and optimize enterprise data warehouse solutions on Snowflake — developing data pipelines, ELT/ETL workflows, and SQL tuning, with RBAC governance, using tools like dbt, Airflow, ADF, Informatica, and Matillion on AWS/Azure/GCP.
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