WeareseekingaskilledSnowflakeDeveloper to design, develop,optimize,andmaintainenterprisedatawarehousesolutionsontheSnowflakeplatform.Theidealcandidateshouldhavestrongexpertiseindatawarehousing,ETL/ELTdevelopment,SQLoptimization,cloudtechnologies,anddataintegration.
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.
- 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
Job description provided by Zensar.
View the original posting
