Lead Snowflake Data Engineer

2 days ago

Greater Chennai Area, India Firstwave Technologies Full time ₹ 12,00,000 - ₹ 24,00,000 per year

We're Hiring: Lead Snowflake Data Engineer


Location:
Chennai / Hyderabad


Employment Type:
Full-Time


Experience:
7+ Years (Minimum 5 Years in Snowflake)


Notice Period:
Immediate – 15 Days

About the Role

We are seeking a highly skilled
Lead Snowflake Data Engineer
with strong hands-on experience in
Snowflake, Medallion Architecture, ADF-based ELT pipelines, and enterprise data warehousing
.

The ideal candidate will have deep technical expertise in
performance optimization, ingestion frameworks, SnowSQL, SnowSight, and star schema design
, along with SnowPro certifications.

Key Responsibilities

  • Lead the design and development of
    Snowflake-based data warehouses
    and scalable data platforms
  • Build end-to-end
    ELT pipelines using Azure Data Factory (ADF)
    as the primary tool
  • Implement
    data ingestion
    , handling duplicates, metadata strategies, and medallion framework
  • Develop optimized
    SnowSQL scripts, materialized views, tasks, stored procedures
  • Architect star schemas
    and dimensional data models for analytics
  • Perform
    query tuning and performance optimization
    on Snowflake workloads
  • Collaborate with data architects, analysts, and engineering teams to deliver enterprise-grade solutions
  • Define data standards, documentation, and reusable frameworks
  • Use
    SnowSight
    for monitoring, debugging, and auditing Snowflake environments
  • Leverage DBT (bonus) for transformation workflows when applicable

Required Skills

  • 7+ years
    in data engineering
  • Minimum 5 years of hands-on Snowflake experience
    (mandatory)
  • Proven expertise in:
  • Medallion Architecture
  • Star Schema Design
  • Query & Performance Optimization
  • Duplicate Data Handling
  • SnowSQL, SnowSight
  • Strong experience in
    ADF
    as the primary ELT tool
  • Ability to demonstrate real-time data ingestion patterns (files, APIs, CDC, etc.)
  • Experience building
    scalable, enterprise-level data warehouses
  • Understanding of Snowflake materialized views, tasks, streams, and warehouses
  • Excellent problem-solving, communication, and leadership skills

Certifications

  • SnowPro Core Certification – Mandatory
  • SnowPro Advanced Certifications
    preferred (any of the below):
  • Data Engineering
  • Data Analysis
  • Architecture

Good to Have

  • Hands-on experience with
    DBT
  • Exposure to cloud platforms (Azure/GCP/AWS)
  • Knowledge of CI/CD pipelines for data deployment

  • Lead Snowflake Data Engineer

    2 weeks ago

    Chennai, Tamil Nadu, India Ventra Health Full time ₹ 12,00,000 - ₹ 36,00,000 per year

    Ventra is a leading business solutions provider for facility-based physicians practicing anesthesia, emergency medicine, hospital medicine, pathology, and radiology. Focused on Revenue Cycle Management, Ventra partners with private practices, hospitals, health systems, and ambulatory surgery centers to deliver transparent and data-driven solutions that solve...

  • Lead Snowflake Data Engineer

    2 weeks ago

    Perungudi, Chennai, India Jobted IN C2 Full time

    About Us: Ventra is a leading business solutions provider for facility-based physicians practicing anesthesia, emergency medicine, hospital medicine, pathology, and radiology. Focused on Revenue Cycle Management, Ventra partners with private practices, hospitals, health systems, and ambulatory surgery centers to deliver transparent and data-driven solutions...

  • Snowflake Data Engineer

    4 weeks ago

    Chennai, India Tata Consultancy Services Full time

    TCS presents an excellent Opportunity For "Snowflake Data Engineer" Role Job Description 1 Role - Snowflake Data Engineer 2 Location of Requirement - Chennai 3 Experience Range - 6 to 9 Years Desired Competencies Snowflake, dbt, FiveTran, Snowpipe, AWS services: Managed Airflow (MWAA), S3, Lambda. GitHub – CI/CD Experience of analyzing, integrating,...

  • Snowflake Data Engineer

    3 weeks ago

    Chennai, India Tata Consultancy Services Full time

    TCS presents an excellent Opportunity For "Snowflake Data Engineer" Role Job Description 1 Role - Snowflake Data Engineer 2 Location of Requirement - Chennai 3 Experience Range - 6 to 9 Years Desired Competencies Snowflake, dbt, FiveTran, Snowpipe, AWS services: Managed Airflow (MWAA), S3, Lambda. GitHub – CI/CD Experience of analyzing, integrating,...

  • Snowflake Data Engineer

    3 weeks ago

    Chennai, India Tata Consultancy Services Full time

    TCS presents an excellent Opportunity For "Snowflake Data Engineer" Role Job Description 1 Role - Snowflake Data Engineer 2 Location of Requirement - Chennai 3 Experience Range - 6 to 9 Years Desired Competencies Snowflake, dbt, FiveTran, Snowpipe, AWS services: Managed Airflow (MWAA), S3, Lambda. GitHub – CI/CD Experience of analyzing, integrating,...

  • Ventra Health-Lead Data Engineer

    5 days ago

    Chennai, India Nexthire Full time

    Role-Lead Data Engineer - Snowflake Exp-7+ years Lead Data Engineer - Snowflake Reports to: Sr Directory D&A FLSA Status : Exempt or Non-Exempt Job Summary:  We are seeking an experienced Lead Snowflake Data Engineer to join our Data & Analytics team. This role involves designing, implementing, and optimizing Snowflake-based data solutions while providing...

  • Snowflake Data Engineer

    3 weeks ago

    Chennai, India Tata Consultancy Services Full time

    TCS presents an excellent Opportunity For "Snowflake Data Engineer" RoleJob Description1 Role - Snowflake Data Engineer2 Location of Requirement - Chennai3 Experience Range - 6 to 9 YearsDesired Competencies- Snowflake, dbt, FiveTran, Snowpipe, AWS services: Managed Airflow (MWAA), S3, Lambda. GitHub – CI/CD- Experience of analyzing, integrating,...

  • Snowflake data engineer

    3 weeks ago

    Chennai, India Tata Consultancy Services Full time

    TCS presents an excellent Opportunity For "Snowflake Data Engineer" RoleJob Description1 Role - Snowflake Data Engineer2 Location of Requirement - Chennai3 Experience Range - 6 to 9 YearsDesired Competencies- Snowflake, dbt, Five Tran, Snowpipe, AWS services: Managed Airflow (MWAA), S3, Lambda. Git Hub – CI/CD- Experience of analyzing, integrating,...

  • Snowflake Data Engineer

    4 weeks ago

    Chennai, India Tata Consultancy Services Full time

    TCS presents an excellent Opportunity For "Snowflake Data Engineer" RoleJob Description1 Role - Snowflake Data Engineer2 Location of Requirement - Chennai3 Experience Range - 6 to 9 YearsDesired CompetenciesSnowflake, dbt, FiveTran, Snowpipe, AWS services: Managed Airflow (MWAA), S3, Lambda. GitHub – CI/CDExperience of analyzing, integrating, modelling,...

  • Snowflake Data Engineer

    4 weeks ago

    Chennai, India Tata Consultancy Services Full time

    TCS presents an excellent Opportunity For "Snowflake Data Engineer" RoleJob Description1 Role - Snowflake Data Engineer2 Location of Requirement - Chennai3 Experience Range - 6 to 9 YearsDesired CompetenciesSnowflake, dbt, FiveTran, Snowpipe, AWS services: Managed Airflow (MWAA), S3, Lambda. GitHub – CI/CDExperience of analyzing, integrating, modelling,...