Description

You will develop and implement business applications using the Oracle Relational Database Management System.

Responsibilities

• Design and implement business applications using Oracle RDBMS.
• Develop Stored Procedures, Packages, Triggers, and Cursors using SQL and PL/SQL.
• Develop Materialized Views to cache queries or replicate data.
• Tune Oracle RDBMS performance using Explain Plan and HINTS.
• Model data, manage database creation, and handle data loading/retrieval.

Required Skills

• 6+ years of programming experience as an Oracle PL/SQL Developer.
• Expertise in Client-Server application development using Oracle 10g/9i/8i.
• Strong experience in Data warehouse concepts and ETL processes.
• Proficiency in Oracle RDDBMS design, including indexes (BITMAP, B-Tree), views, and sequences.
• Experience with PL/SQL features, including Dynamic SQL, Records, and Exception Handling.
• Expertise in SQL performance tuning using Cost-Based Optimization (CBO) and join types (Nested Loop, Hash Join).
• Experience with DDL, DML, and TCL statements, and techniques for partitioning large tables.
• Proficiency with Oracle database administration tasks (creating links, schemas, profiles).
• Familiarity with tools like Toad and ETL tools like Informatica.

Key Skills

Education

Any Graduate