Job Description

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,500,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? * Have you applied in Birlasoft? Please ignore if your profile have already been processed?