Senior Snowflake Developer

Please only apply if it is relevant

Don't apply any C2H Past role

Location-Delhi NCR,Chennai,hyderabad,bengauru,Pune

November Joiners

No negoation or Bench

EXL
Role Overview
We are looking for an experienced Senior Snowflake Developer with strong hands-on expertise in Snowflake, Data Engineering, ELT/ETL development, data modelling, performance optimization, and cloud-based data platforms.
The role will be responsible for designing and developing scalable data solutions, building robust pipelines, optimizing Snowflake workloads, and implementing engineering best practices across enterprise data platforms.
Key Responsibilities
Snowflake Development & Data Engineering

• Having experience of 12 years and above
• Design, develop, and maintain scalable data solutions on Snowflake.
• Build and optimize complex ELT/ETL pipelines for large-scale data processing.
• Develop solutions using Snowpipe, Streams & Tasks, Dynamic Tables, Secure Data Sharing, and other Snowflake capabilities.
• Design efficient data models using Dimensional, Data Vault, Medallion, and Lakehouse approaches.
• Develop reusable SQL components, stored procedures, and data transformation frameworks.
• Integrate Snowflake with upstream and downstream applications, BI platforms, APIs, and analytics solutions.

Performance & Cost Optimization

• Optimize complex SQL queries and Snowflake workloads for performance.
• Monitor and improve warehouse utilization and query performance.
• Implement Snowflake cost optimization and FinOps best practices.
• Troubleshoot performance bottlenecks and complex data-processing issues.

Data Security & Governance

• Implement Snowflake security features including RBAC, masking policies, secure views, and row/column-level security.
• Ensure data solutions follow enterprise security, governance, and compliance standards.
• Support data-quality, lineage, auditing, and monitoring requirements.

DevOps & Engineering Practices

• Implement automated deployment and CI/CD practices for Snowflake development.
• Work with tools such as dbt, ADF, Airflow, Matillion, or Informatica for transformation and orchestration.
• Follow Git-based development, code review, testing, and deployment practices.
• Drive automation and reusable engineering solutions wherever possible.

Technical Collaboration

• Work closely with Data Architects, Data Engineers, Analysts, and business stakeholders to understand requirements and translate them into technical solutions.
• Participate in technical design and code reviews.
• Troubleshoot complex production issues and provide technical solutions.
• Mentor junior developers and support engineering best practices within the team.

Must-Have Skills

• Strong hands-on experience with Snowflake development and implementation.
• Advanced SQL and strong data-engineering fundamentals.
• Strong hands-on knowledge of:
• Snowpipe
• Streams & Tasks
• Dynamic Tables
• Secure Data Sharing
• RBAC and data security
• Performance tuning
• Snowflake cost optimization
• Strong experience with ELT/ETL development and data pipelines.
• Experience with Dimensional Modelling, Data Vault and/or Medallion Architecture.
• Hands-on experience with orchestration/transformation tools such as dbt, ADF, Airflow, Matillion, or Informatica.
• Experience implementing CI/CD and Git-based development.
• Strong troubleshooting and problem-solving capabilities.
• Good communication skills with the ability to work effectively in client-facing environments.

Good to Have

• Experience with Azure, AWS, or GCP.
• Hands-on knowledge of Python and/or Spark.
• Exposure to GenAI/AI/ML integration with modern data platforms.
• Experience with modern data stack technologies, particularly dbt.
• Experience in domains such as Insurance, BFSI, or Healthcare.
• Relevant Snowflake certifications would be an advantage.

Education
Bachelors or Masters degree in Computer Science, Engineering, Information Systems, Data Engineering, or a related field.