Snowflake Developer

This role is for one of our clients
Industry: IT Services and IT Consulting
Seniority level: Mid-Senior level
Min Experience: 5+ years
Location: Pune, Maharashtra, India, Bengaluru, Karnataka, India
JobType: full-time
Key Responsibilities
Shift- Flexibility to shift working
Project Type- L3 Support
We may use artificial intelligence (AI) tools to support parts of the hiring process, such as reviewing applications, analyzing resumes, or assessing responses and identifying potential inconsistencies or verification signals in application materials based on available information. These tools assist our recruitment team but do not replace human judgment. Final hiring decisions are ultimately made by humans. If you would like more information about how your data is processed, please contact us.
Development Responsibilities
Design and develop scalable data pipelines and modern data architectures using Snowflake
Lead migration initiatives from legacy databases to Snowflake
Build and optimize ELT frameworks using DBT
Develop and orchestrate workflows using Apache Airflow
Design and implement data models, including Star Schema and Snowflake Schema
Develop ingestion pipelines for structured and semi-structured data
Create reusable frameworks for data validation, reconciliation, auditing, and monitoring
Optimize Snowflake objects, including:
Virtual Warehouses
Clustering Keys
Materialized Views
Streams & Tasks
Dynamic Tables
Develop technical design documents and migration runbooks
Perform code reviews and enforce engineering best practices
Migration Responsibilities
Assess and migrate data from legacy platforms, including:
Oracle
SQL Server
Teradata
Netezza
DB2
SAP HANA
On-Prem Data Warehouses
Perform source system analysis and database rationalization
Design migration strategies, including:
Full Data Loads
Incremental Loads
CDC (Change Data Capture)
Historical Data Migration
Conduct data reconciliation and validation during migration
Optimize transformed workloads for Snowflake architecture
Execute cutover planning and post-migration stabilization
Good to have:
AMS / Production Support Responsibilities
Provide L3 support for Snowflake data platforms and pipelines
Monitor and manage production data workloads
Troubleshoot data failures, performance issues, and pipeline disruptions
Perform root cause analysis (RCA) and implement permanent fixes
Support incident, problem, change, and release management activities
Work closely with business users and stakeholders to resolve production issues
Ensure adherence to SLA and operational support commitments
Participate in production releases and deployment activities
Must-have skills
Snowflake, DBT, Airflow
Good-to-have skills
Informatica, SQL, Datastage

Work arrangement
No