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.
- Solid 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

📌 Snowflake Developer (Bengaluru)
🏢 IndiHire Consultants
📍 Bengaluru