Snowflake Developer

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.

Interested Candidates Share your profile to:

[email protected] / [email protected]