We are looking for Immediate Joiners.

Job Description

Job Title: Oracle SQL, PL/SQL Developer and Oracle Apps Technical Developer (SCM), AP (Accounts

Payable), AR (Accounts Receivables).

Location: Chennai (5 days)

Experience: 8+ Years

Job Summary:

We are seeking an experienced Oracle SQL, PL/SQL Developer and Oracle Apps Technical Developer with

over 8+ years of expertise in the Release 11i & R12 E-Business Suite. The ideal candidate will be proficient

in SQL, PL/SQL objects, and have extensive experience in various phases of the system development life

cycle. This role requires a deep understanding of Oracle SCM Applications and the ability to develop and

customize RICE components.

Key Responsibilities:

• Develop and maintain SQL, PL/SQL objects including packages, procedures, functions, triggers,

cursors, and PL/SQL collections.

• Execute SQL scripts using DDL and DML statements, and manage SQL objects such as tables, views,

indexes, sequences, and synonyms.

• Implement exception handling mechanisms within PL/SQL code.

• Participate in all phases of the system development/implementation life cycle, including requirement

gathering, analysis, design, development, testing, implementation, and support.

• Work with various Oracle SCM modules (PO, OM, INV) and possess knowledge of Application Object

Library, AR, and AP.

• Understand and apply Order to Cash (O2C) and Procure to Pay (P2P) cycles.

• Develop and customize RICE components (Reports, Interfaces, Conversions).

• Create XML Publisher Reports and RDF Reports for Finance and SCM modules.

• Prepare technical design documents for customizations and conversions using AIM documentation

methodology (MD070, CV60, TE20, MD120).

• Develop SQL*Loader control programs and PL/SQL validation scripts for pre-import processing of

legacy data from feeder systems to Oracle.

Qualifications:

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

• 8+ years of experience as an Oracle SQL, PL/SQL Developer and Oracle Apps Technical Developer.

• Proficiency in SQL, PL/SQL, and Oracle E-Business Suite (Release 11i & R12).

• Strong understanding of Oracle SCM Applications and related modules.

• Experience with AIM documentation methodology.

Preferred Skills:

• Knowledge of XML Publisher and RDF Reports.

• Familiarity with SQL*Loader and PL/SQL validation scripts.

• Experience in Order to Cash (O2C) and Procure to Pay (P2P) cycles