Snowflake Developer

Aalam Info Solutions; Chennai District; On-site; INR 1,200,000 - 1,800,000; Full time

Job summary

Aalam Info Solutions is seeking a Snowflake Developer in Chennai to design, develop, and optimize Snowflake databases and data pipelines for an international client. You will work with Snowpipe, Time Travel, Zero‑Copy Cloning, and Streams & Tasks, integrating Snowflake with AWS services such as S3 and Lambda while handling structured and semi‑structured data.

The role requires 3+ years of hands‑on Snowflake experience, strong SQL, and Python/PySpark skills to transform and move data efficiently.

Qualifications

• 3+ years of hands‑on Snowflake development experience
• Strong SQL skills, including complex queries and transformations
• Experience with Snowflake + AWS integration (S3, Glue, Lambda)
• Hands‑on with JSON/XML/Parquet data and Snowflake VARIANT/FLATTEN
• Strong Snowflake performance tuning and cost optimization
• Experience supporting and troubleshooting production data pipelines
• Proficiency in Python and/or PySpark
• Experience using AI development tools like Claude or GitHub Copilot

Responsibilities

• Design, develop, and maintain Snowflake databases, schemas, tables, views, procedures, and UDFs
• Work with Virtual Warehouses, Time Travel, Zero‑Copy Cloning, Streams & Tasks, Snowpipe
• Integrate Snowflake with AWS services (S3, IAM, Lambda, Glue)
• Configure and troubleshoot external stages and storage integrations; secure data movement between AWS, RDS, On‑Premise DB, and Snowflake
• Develop and optimize complex SQL queries and data transformations
• Work with semi‑structured data using Snowflake VARIANT/FLATTEN
• Perform query and warehouse performance tuning and cost optimization
• Monitor production data pipelines and provide incident resolution
• Develop Python and/or PySpark scripts for data transformation and automation
• Use AI coding assistants for development and documentation
• Collaborate with Data Engineers, Analysts, and stakeholders; document designs

Skills

Snowflake development

SQL

Python

PySpark

AWS integration

Data pipelines

Performance tuning

Data transformation

Tools

Airflow

Step Functions

Snowpark for Python

GitHub Copilot

Job description

Snowflake Developer - Job Description

Job Title: Snowflake Developer

Experience: 3+ Years

Joining Date: Immediate Joiner

Location: Chennai

Website: www.aalamsoft.com

Job Summary:

We are looking for a Snowflake Developer with hands‑on experience in Snowflake, SQL, AWS, and data pipelines. The role involves developing and supporting scalable data pipelines, transforming structured and semi‑structured data, optimizing Snowflake performance and cost, and supporting production data workloads for our US‑based client.

Key Responsibilities:

• Design, develop, and maintain Snowflake databases, schemas, tables, views, stored procedures, and UDFs.
• Work with Virtual Warehouses, Time Travel, Zero‑Copy Cloning, Streams & Tasks, and Snowpipe for batch and near real‑time data processing.
• Integrate Snowflake with AWS services such as S3, IAM, Lambda, Glue, or similar services.
• Configure and troubleshoot external stages, storage integrations, and secure data movement between AWS, RDS, On‑Premise DB, and Snowflake.
• Develop and optimize complex SQL queries, stored procedures, and data transformations.
• Work with JSON, XML, and Parquet data using Snowflake VARIANT, FLATTEN, and other semi‑structured data functions.
• Perform query and warehouse performance tuning, including query profiling, clustering keys, materialized views, and warehouse sizing.
• Monitor and optimize Snowflake credit consumption, warehouse usage, storage, and overall cost.
• Support production data pipelines, including monitoring, troubleshooting, incident resolution, and documentation.
• Develop Python and / or PySpark scripts for data transformation, validation, automation, and integration.
• Use AI coding assistants such as Claude, GitHub Copilot, or similar tools for development, debugging, query writing, and documentation.
• Collaborate with Data Engineers, Analysts, and business stakeholders and document technical designs and processes.

Required Skills & Qualifications:

• 3+ years of hands‑on Snowflake development experience mandatory.
• Strong SQL skills, including complex queries, stored procedures, and transformations.
• Experience with Snowflake + AWS integration, particularly S3, Glue, Lambda, or similar services.
• Hands‑on experience with JSON, XML, and Parquet data and Snowflake VARIANT / FLATTEN.
• Strong understanding of Snowflake performance tuning and cost/credit optimization.
• Experience supporting and troubleshooting production data pipelines.
• Proficiency in Python and/or PySpark.
• Experience using AI development tools such as Claude, GitHub Copilot, or similar.
• Good verbal and written communication skills with the ability to work with technical and non‑technical stakeholders.

Preferred Skills:

• Experience with Snowpark for Python.
• Experience with orchestration tools such as Airflow, Step Functions, or similar.
• Understanding of RBAC, data governance, and security best practices within Snowflake.
• Experience with CI/CD for data pipelines and Git version control.
• Familiarity with data modeling concepts (star schema, dimensional modeling).

Additional Expectations

• Shift time: 2:00 PM to 11:00 PM.
• Experience in International client‑facing roles is a plus.
• Self‑driven with strong attention to detail.