Overview

We are looking for an experienced Snowflake / SQL Developer with 6–10 years of experience in Data Engineering, Data Warehousing, ETL/ELT development, and cloud-based data platforms.

Responsibilities

• Design, develop, and maintain scalable Snowflake data warehouse solutions.
• Develop complex and optimized SQL queries, stored procedures, functions, and data transformations.
• Work extensively with Snowflake databases, schemas, tables, views, stages, warehouses, and file formats.
• Develop and maintain ETL/ELT data pipelines for batch and incremental data processing.
• Implement and manage Snowflake Streams, Tasks, and Snowpipe.
• Perform SQL and Snowflake query optimization and performance tuning.
• Implement data loading, transformation, validation, and reconciliation processes.
• Design and maintain data models including Star Schema, Snowflake Schema, fact and dimension tables.
• Implement appropriate Snowflake security, RBAC, and access controls.
• Troubleshoot data pipeline failures and performance issues.
• Collaborate with Data Engineers, Architects, Analysts, and business stakeholders.
• Follow Git, CI/CD, Agile, and DevOps practices.
• Develop Python scripts for automation and data processing where required.
• Work with AWS services such as S3, Glue, IAM, and Lambda where applicable.
• Prepare technical documentation and participate in knowledge-sharing activities.

Qualifications

• 6+ years of experience in Data Engineering, ETL, or Data Warehousing.
• Strong hands-on experience with Snowflake.
• Excellent proficiency in Advanced SQL.
• Strong knowledge of:
• Complex joins
• CTEs
• Subqueries
• Window functions
• Stored procedures
• Query optimization
• Performance tuning
• Hands-on experience with Snowflake Streams, Tasks, Snowpipe, stages, and file formats.
• Strong understanding of ETL/ELT concepts and data pipeline development.
• Knowledge of batch, incremental, and CDC-based data ingestion.
• Understanding of Snowflake security and RBAC.
• Strong analytical and problem-solving skills.
• Python scripting and automation experience.
• AWS experience, particularly:
• AWS Glue
• IAM
• Lambda
• SnowPro Core or SnowPro Advanced certification.

Education

• Strong communication and interpersonal skills.
• Good analytical and problem-solving capabilities.
• Ability to work independently and within a team.
• Strong stakeholder collaboration skills.
• Good documentation and knowledge-sharing abilities.
• Bachelor's/Master’s degree in Computer Science, Information Technology, Engineering, or equivalent experience.