Description

Develop and maintain database logic in an Oracle 12 environment to support data migration and reporting.

Responsibilities

• Write stored procedures, packages, and functions to perform ETL processes from transactional tables to reporting data marts.
• Execute data migration programming to move data from legacy structures into new application tables.
• Define and manage Oracle database objects, including tables, triggers, and indexes using PL/SQL DDL.
• Perform performance tuning on PL/SQL queries and stored procedures to ensure efficiency.
• Conduct data updates for Oracle applications as required.

Required Skills

• 5+ years of experience as a PL/SQL Developer.
• Substantial experience working in an Oracle 12 database environment.
• Expertise in writing PL/SQL procedures for ETL and data migration.
• Proficiency in defining database objects using Oracle PL/SQL DDL.
• Experience with performance tuning of queries and stored procedures.
• Ability to build well-documented Oracle procedures, functions, and packages.
• Strong knowledge of Oracle PL/SQL.

Preferred Skills

• Experience implementing error handling and logging in PL/SQL scripts.
• Experience developing and testing Oracle Forms and Reports applications.

Key Skills

Education

Any Graduate