Home
Staff AugmentationAI-Enabled DevelopersHire Dedicated DevelopersHire ML EngineersHire Full Stack DevelopersHire DevOps EngineersOffshore Development Center
All AI ProductsAalam Doc AITally ConnectAI ERP & HRMSPeopleStack
AI/ML Development Services
Application DevelopmentMobile Application DevelopmentData AnalyticsCloudOps Services
About UsCase StudiesCareersBlogsContact
Tell us the role you need →
All openings

Development Team - AISL

JOB-0004

Snowflake Developer

Department
Development Team - AISL
Location
Chennai
Openings
1
Apply now

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.