Snowflake Senior Developer

Experience- 7+ years

Location- Hyderabad (preferred), Pune, Mumbai

JD-

We are seeking a skilled Snowflake Developer with 7+ years of experience in designing, developing, and optimizing Snowflake data solutions. The ideal candidate will have strong expertise in Snowflake SQL, ETL/ELT pipelines, and cloud data integration. This role involves building scalable data warehouses, implementing efficient data models, and ensuring high-performance data processing in Snowflake.

Key Responsibilities

1. Snowflake Development & Optimization

• Design and develop Snowflake databases, schemas, tables, and views following best practices.
• Write complex SQL queries, stored procedures, and UDFs for data transformation.
• Optimize query performance using clustering, partitioning, and materialized views.
• Implement Snowflake features (Time Travel, Zero-Copy Cloning, Streams & Tasks).

2. Data Pipeline Development

• Build and maintain ETL/ELT pipelines using Snowflake, Snowpark, Python, or Spark.
• Integrate Snowflake with cloud storage (S3, Blob) and data ingestion tools (Snowpipe).
• Develop CDC (Change Data Capture) and real-time data processing solutions.

3. Data Modeling & Warehousing

• Design star schema, snowflake schema, and data vault models in Snowflake.
• Implement data sharing, secure views, and dynamic data masking.
• Ensure data quality, consistency, and governance across Snowflake environments.

4. Performance Tuning & Troubleshooting

• Monitor and optimize Snowflake warehouse performance (scaling, caching, resource usage).
• Troubleshoot data pipeline failures, latency issues, and query bottlenecks.
• Work with DevOps teams to automate deployments and CI/CD pipelines.

5. Collaboration & Documentation

• Work closely with data analysts, BI teams, and business stakeholders to deliver data solutions.
• Document data flows, architecture, and technical specifications.
• Mentor junior developers on Snowflake best practices.

Required Skills & Qualifications

· 8+ years in database development, data warehousing, or ETL.

· 4+ years of hands-on Snowflake development experience.

· Strong SQL or Python skills for data processing.

· Experience with Snowflake utilities (SnowSQL, Snowsight, Snowpark).

· Knowledge of cloud platforms (AWS/Azure) and data integration tools (Coalesce, Airflow, DBT).

· Certifications: SnowPro Core Certification (preferred).

Preferred Skills

· Familiarity with data governance and metadata management.

· Familiarity with DBT, Airflow, SSIS & IICS

· Knowledge of CI/CD pipelines (Azure DevOps).

Job Type: Full-time

Pay: From ₹1,200,000.00 per year

Schedule:

• Monday to Friday

Application Question(s):

• How many years of total experience do you currently have?
• How many years of experience do you have in Snowflake development?
• How many years of experience do you have with DBT?
• What is your current CTC?
• What is your expected CTC?
• What is your notice period/ LWD?
• What is your current location?
• Are you comfortable attending 1st round face to face on 2nd Aug (Saturday) in Hyderabad, Mumbai or Pune office?