Oracle PL/SQL Developer – Snowflake

Job Title: Oracle PL/SQL Developer Snowflake

Experience: 3.5+ Years

Location: Pune Viman Nagar

Job Summary

We are looking for an experienced Oracle PL/SQL Developer with strong expertise in Snowflake and data warehousing technologies. The ideal candidate should have 3.5+ years of experience in Oracle database development, ETL implementation, performance tuning, and hands-on experience in Snowflake data migration, data modeling, and optimization. Experience with ODI and DBT is highly preferred.

Key Responsibilities

Design, develop, and maintain Oracle database objects including Procedures, Functions, Packages, Triggers, Views, Sequences, and Synonyms.

Write and optimize complex SQL and PL/SQL code for large-scale data processing.

Develop and support ETL/ELT pipelines using Oracle Data Integrator (ODI) and Snowflake.

Design and implement data migration solutions from Oracle and other source systems to Snowflake.

Develop Snowflake database objects such as Tables, Views, Stages, Streams, Tasks, and Stored Procedures.

Optimize Snowflake workloads through clustering, partitioning, warehouse sizing, and query performance tuning.

Build and maintain scalable data models and transformation pipelines using DBT.

Create reconciliation and data validation processes to ensure data accuracy and consistency.

Implement data transformation, aggregation, and business rules within Oracle and Snowflake environments.

Schedule and automate database jobs using Oracle DBMS_SCHEDULER and Snowflake Tasks.

Troubleshoot production issues and improve database performance across Oracle and Snowflake platforms.

Collaborate with Data Engineers, Business Analysts, and Application teams to deliver high-quality data solutions.

Preferred Qualifications

Bachelor's degree in Computer Science, Information Technology, or related field.

3.5+ years of Oracle PL/SQL development experience.

1+ year of hands-on Snowflake development experience.

Experience in BFSI/Insurance domain is preferred.

Strong problem-solving and analytical skills.

Excellent communication and stakeholder management skills.