Snowflake Developer

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