Snowflake Developer – R01568220

Brillio; Bengaluru; On-site; INR 1,200,000 - 1,800,000; Full time

Job summary

Brillio is seeking a data engineering professional to design, migrate, and optimize data pipelines on Snowflake. You will develop scalable data architectures, create migration runbooks, and lead architecture decisions for large-scale data platforms.

The role focuses on Snowflake optimization, ELT frameworks, and end-to-end migration strategies, with emphasis on data validation, monitoring, and production readiness.

Qualifications

• Design and migrate data pipelines to Snowflake with scalable architectures.
• Lead migration from legacy databases to Snowflake and optimize ELT workflows.
• Develop Snowflake objects and performance optimization techniques.

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 and Snowflake schemas.
• Develop ingestion pipelines for structured and semi-structured data.
• Create reusable data validation, reconciliation, auditing, and monitoring frameworks.
• Optimize Snowflake objects such as virtual warehouses, clustering keys, materialized views, streams, tasks, and dynamic tables.
• Develop technical design documents and migration runbooks.
• Perform code reviews and enforce engineering best practices.

Skills

Snowflake

DBT

Apache Airflow

ETL/ELT design

Data architecture

Tools

Oracle

SQL Server

Teradata

Netezza

DB2

SAP HANA

On-Prem Data Warehouses

Job description

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.