Snowflake Developer

Job Title: Snowflake Developer

Experience: 5+ 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:

Shricharumuki.vijeyakumar@aalamsoft.com / hr@aalamsoft.com

Job Types: Full-time, Permanent

Pay: ₹500,000.00 - ₹700,000.00 per year

Benefits:

• Food provided
• Health insurance
• Internet reimbursement
• Provident Fund

Application Question(s):

• Your Native is Chennai? or Are you Residing with your Family in Chennai?
• What is your Notice Period?
• Years of hand on experience you have in SSIS?

Work Location: In person