Remote Jobs RockRemote Jobs Rock

Snowflake Developer - R01568220

📅 Jul 17
📍 🇮🇳 Bengaluru - Hybrid🎺 Lead🛢️ Data Engineer💼 Full-Time
SnowflakeApache AirflowDBTData Pipeline Development
Apply Now

📜 Description

  • Design scalable Snowflake data pipelines and modern data architectures.
  • Lead migrations from legacy databases, including planning, reconciliation, cutover, and stabilization.
  • Build and optimize ELT frameworks with DBT and orchestrate workflows with Apache Airflow.
  • Create data models and ingestion pipelines for structured and semi-structured data.
  • Develop reusable validation, auditing, monitoring, and reconciliation frameworks.
  • Provide L3 production support, troubleshoot incidents, and implement permanent fixes.

🛠️ Requirements

  • Experience with Snowflake, Apache Airflow, and DBT.
  • Flexibility to work shifts is mandatory.
Full job description
Data Specialist

Primary Skills

  • Snowflake, Airflow, DBT

    • Specialization

  • Snowflake Lead Developer

    • Job requirements

    Key Responsibilities

    Project Type: L3 Support

    Flexibility to shift working is Mandatory.

    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.
    • Apply Now

    Similar jobs

    Search more Data Engineer jobs
    ZoomInfo

    Principal Data Engineer

    🕒 7 days ago
    ZoomInfo👥 10,000+ employees🏢 Software Development🤝 B2B
    WebsiteLinkedInAll Job Openings

    Defines enterprise data-platform architecture and engineering standards, leads complex system design and technical decisions, and builds reliable data products while mentoring engineers across teams.

    📍 🇺🇸 United States - Remote💰 $171.5k - $269.5k / year💼 Full-Time🎺 Lead🛢️ Data Engineer
    Data ArchitectureData EngineeringSQLPython
    View jobApply
    View more Data Engineer jobs

    Trusted by Remote Workers