Snowflake Developer

Indihire Consultants; Bengaluru; On-site; INR 4,000,000 - 9,000,000; Full time

Job summary

Indihire Consultants seeks a seasoned data engineer to lead Oracle-to-Snowflake migrations in Bengaluru. You will assess, architect, develop, test, cutover, and stabilize large-scale deployments, translating Oracle objects into Snowflake and building scalable ELT pipelines.

You will design Parquet-based pipelines, optimize Snowflake performance, and implement hybrid tables for transactional workloads, collaborating across teams to ensure smooth migrations.

Qualifications

• 6+ years of database/data engineering experience.
• 3+ years Snowflake experience.
• Proven experience delivering enterprise-scale Oracle-to-Snowflake migrations in production.
• Strong Oracle SQL and PL/SQL expertise, including stored procedures, packages, functions, triggers, views, and complex database logic.
• Strong Snowflake SQL, architecture, data modeling, and ELT experience.
• Hands-on Apache Airflow experience developing and operating production DAGs.
• Strong experience with Parquet and cloud object storage such as AWS S3, Azure Data Lake, or GCP.
• Experience with Snowflake Streams, Tasks, Snowpipe/COPY INTO, stages, and performance optimization.
• Hands-on experience with Snowflake Hybrid Tables is strongly preferred.
• Experience with large-volume data migration, incremental loads, CDC, reconciliation, and migration testing.
• Strong problem-solving, communication, and cross-functional collaboration skills.

Responsibilities

• Lead the end-to-end Oracle-to-Snowflake migration, including assessment, architecture, development, testing, cutover, and stabilization.
• Analyze Oracle schemas, tables, views, stored procedures, packages, functions, triggers, and dependencies and translate them into Snowflake.
• Design and implement scalable Snowflake data models, ELT pipelines, ingestion frameworks, and transformations.
• Convert Oracle SQL/PLSQL and database logic into optimized Snowflake SQL and modern cloud data patterns.
• Develop production-grade Apache Airflow DAGs for data ingestion, transformation, scheduling, dependencies, monitoring, and error handling.
• Design efficient Parquet-based data pipelines, including extraction, staging, loading, partitioning, compression, and schema evolution.
• Evaluate and implement Snowflake Hybrid Tables for appropriate transactional/operational workloads.
• Identify, document, and migrate business rules embedded in Oracle PL/SQL, ETL processes, database objects, and application logic.
• Determine appropriate implementation of business rules using Snowflake SQL, Python, dbt, Airflow, or a Business Rules Engine (BRE).
• Build automated data reconciliation, validation, and business-rule regression testing between Oracle and Snowflake.
• Perform Snowflake query, warehouse, pipeline, and data-load performance optimization.
• Collaborate with architects, DBAs, application teams, business analysts, QA, and data engineering teams.

Skills

Data engineering

Snowflake experience

Oracle SQL

Airflow

DBT

Python

Parquet

Tools

Snowflake

Airflow

DBT

Python

AWS S3

Azure Data Lake

GCP

Job description

Role & responsibilities

• Lead the end-to-end Oracle-to-Snowflake migration, including assessment, architecture, development, testing, cutover, and stabilization.
• Analyze Oracle schemas, tables, views, stored procedures, packages, functions, triggers, and dependencies and translate them into Snowflake.
• Design and implement scalable Snowflake data models, ELT pipelines, ingestion frameworks, and transformations.
• Convert Oracle SQL/PLSQL and database logic into optimized Snowflake SQL and modern cloud data patterns.
• Develop production-grade Apache Airflow DAGs for data ingestion, transformation, scheduling, dependencies, monitoring, and error handling.
• Design efficient Parquet-based data pipelines, including extraction, staging, loading, partitioning, compression, and schema evolution.
• Evaluate and implement Snowflake Hybrid Tables for appropriate transactional/operational workloads.
• Identify, document, and migrate business rules embedded in Oracle PL/SQL, ETL processes, database objects, and application logic.
• Determine appropriate implementation of business rules using
• Snowflake SQL, Python, dbt, Airflow, or a Business Rules Engine (BRE).
• Build automated data reconciliation, validation, and business-rule regression testing between Oracle and Snowflake.
• Perform Snowflake query, warehouse, pipeline, and data-load performance optimization.
• Collaborate with architects, DBAs, application teams, business analysts, QA, and data engineering teams.

Preferred candidate profile

Required Qualifications & Skills

• 6+ years of overall database/data engineering experience.
• 3+ years of hands-on Snowflake experience.
• Proven experience delivering enterprise-scale Oracle-to-Snowflake migrations in production.
• Strong Oracle SQL and PL/SQL expertise, including stored procedures, packages, functions, triggers, views, and complex database logic.
• Strong Snowflake SQL, architecture, data modeling, and ELT experience.
• Hands-on Apache Airflow experience developing and operating production DAGs.
• Strong experience with Parquet and cloud object storage such as AWS S3, Azure Data Lake, or GCP.
• Experience with Snowflake Streams, Tasks, Snowpipe/COPY INTO, stages, and performance optimization.
• Hands-on experience with Snowflake Hybrid Tables is strongly preferred.
• Experience with large-volume data migration, incremental loads, CDC, reconciliation, and migration testing.
• Strong problem-solving, communication, and cross-functional collaboration skills.

Nice-to-Have Skills

• SnowPro Advanced: Data Engineer certification.
• SnowPro Core certification.
• Experience with a Business Rules Engine (BRE) or decision/rules-management platform.
• Experience migrating and modernizing business rules from Oracle/PLSQL.
• Experience integrating BRE with Snowflake and Airflow.
• Python and DBT experience.
• Experience with Oracle GoldenGate, AWS DMS, Fivetran, Qlik Replicate, Informatica, or similar tools.
• Experience with CI/CD, Git, and cloud data platforms.
• Snowflake security and governance experience