Senior Snowflake Developer

Aalam Info Solutions

Chennai

On-site

INR 1,500,000 - 2,100,000

Full time

9 days ago

A complete application in a minute

Tailored resume and cover letter, ready to send.

Get past ATS filters

Job summary

Aalam Info Solutions seeks a Senior Snowflake Developer in Chennai to design, build, and optimize Snowflake architectures for our US-based client. You will handle batch and near real-time data pipelines, cost-aware warehouse tuning, and transformations using SQL, VARIANT, and FLATTEN.

Experience with Snowflake, AWS services, Python or PySpark, and AI tooling will support efficient development and production operations. Immediate joining and collaboration with cross-functional teams are expected.

Qualifications

  • Strong SQL skills with complex queries, stored procedures and data transformations.
  • Hands-on Snowflake + AWS integration (S3, Glue, Lambda).
  • Python and/or PySpark experience for data engineering tasks.
  • Familiarity with AI development tools such as Claude or Copilot.
  • Knowledge of RBAC, data governance, and security best practices.

Responsibilities

  • Design, develop, and maintain Snowflake databases, schemas, tables, views, procedures, and UDFs.
  • Work with Virtual Warehouses, Time Travel, Zero-Copy Cloning, Streams & Tasks, and Snowpipe for batch/near real-time processing.
  • Integrate Snowflake with AWS services and configure external stages and storage integrations.
  • Develop and optimize SQL queries and data transformations; handle semi-structured data using VARIANT/FLATTEN.
  • Monitor warehouse performance, costs, and credit consumption; tune queries and clustering keys.
  • Support production data pipelines with monitoring, troubleshooting, and documentation.
  • Develop Python/PySpark scripts for data transformation and automation.
  • Collaborate with data engineers, analysts, and stakeholders; document designs and processes.

Tools

Snowflake+
AWS integration
SQL
Python
PySpark
Airflow
GitHub Copilot
RBAC
JSON/Parquet

Job description

Senior Snowflake Developer - Job Description
Job Title: Senior Snowflake Developer
Experience: 5+ Years
Joining Date: Immediate Joiner
Location: Chennai
Website: www.aalamsoft.com
Job Summary

We are looking for a Senior Snowflake Developer with hands-on experience in Snowflake, SQL, AWS, and data pipelines, including designing and building Snowflake architecture. 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
  • Strong SQL skills, including complex queries, stored procedures, and transformations.
  • Experience with Snowflake + AWS integration, particularly S3, Glue, Lambda, or similar services.
  • Understanding of RBAC, data governance, and security best practices within Snowflake.
  • Hands-on experience with JSON, XML, and Parquet data and Snowflake VARIANT / FLATTEN.
  • Independently gather requirements, propose solutions, and make design decisions with minimal supervision.
  • 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.
  • 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.
Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Lead Snowflake Data Engineer
Lead Snowflake Data Engineer

VMC Soft Technologies • Bengaluru Urban

On-site
INR 1,500,000 - 2,700,000
Senior Snowflake Data Engineer
Senior Snowflake Data Engineer

Algoleap Technologies • Hyderabad

On-site
INR 2,800,000 - 4,600,000
Snowflake Developer
Snowflake Developer

Synechron • Pune District, Chennai

On-site
INR 1,400,000 - 2,100,000
Senior Snowflake Data Developer
Senior Snowflake Data Developer

Technopals Pte. • Bangalore Rural

On-site
INR 1,800,000 - 3,200,000
Senior Data Engineer- Snowflake
Senior Data Engineer- Snowflake

Squareshift • Chennai District

On-site
INR 1,200,000 - 1,800,000
Senior Software Engineer
Senior Software Engineer

Sonata Software • Hyderabad

On-site
INR 1,500,000 - 2,500,000
Senior Snowflake Data Engineer
Senior Snowflake Data Engineer

EPAM Systems Inc • Chennai District, Coimbatore District

On-site
INR 1,800,000 - 3,200,000
Snowflake Data Engineer
Snowflake Data Engineer

PALNI • Hyderabad

On-site
INR 900,000 - 1,500,000
Senior Snowflake Data Engineer
Senior Snowflake Data Engineer

EPAM Systems Inc • Bengaluru

On-site
INR 2,400,000 - 4,000,000
Senior Snowflake Developer | Snowflake DW, Advanced SQL, Python
Senior Snowflake Developer | Snowflake DW, Advanced SQL, Python

Tata Consultancy Services Limited • Khordha, Hyderabad, Bengaluru

On-site
INR 1,200,000 - 2,600,000