Job Description :

SQL Developer (Oracle to PostgreSQL Migration)

Location : Hyderabad.

Work Mode : Work From Office (Mandatory).

Experience : 4 to 7 Years.

Interview Process : 1 Round Face-to-Face Interview (Mandatory).

Note : Candidates must be comfortable with Work From Office and should be available for a Face-to-Face Interview as part of the selection process.

We are looking for a strong SQL Developer with hands-on experience in Oracle PL/SQL, PostgreSQL, and Database Migration to support the migration and re-implementation of an Oracle-based reporting database onto the RisingWave platform (PostgreSQL-compatible streaming database).

Mandatory Skills :

- SQL Development

- Oracle Database

- Oracle PL/SQL (Stored Procedures, Functions, Packages)

- PostgreSQL

- ANSI SQL

- ETL Development & Logic Conversion

- Reporting Views & Materialized Views

- Database Migration (Oracle to PostgreSQL)

- Query Optimization & Performance Tuning

- Data Validation & Reconciliation

Key Responsibilities :

- Migrate Oracle-based reporting databases to RisingWave.

- Convert complex Oracle PL/SQL procedures, ETL logic, and reporting views into PostgreSQL-compatible SQL.

- Develop and optimize materialized views and streaming views.

- Ensure business logic and reporting outputs remain consistent in the new environment.

- Perform data validation, testing, and performance optimization.

- Collaborate with engineering and business teams throughout the migration lifecycle.

Good to Have :

- Experience with RisingWave

- Streaming Databases

- Real-Time Data Processing

- Data Warehousing Concepts