Oracle Technical Consultant

Responsibilities :

- Analyze source data, map data to target tables, and perform data cleansing and transformations.

- Develop and execute data migration programs using SQL Loader, SQL-Plus, and other

relevant tools.

- Troubleshoot data migration issues and resolve data quality problems.

- Develop and maintain Oracle EBS customizations using RICEW objects (Reports, Interfaces, Conversions, Extensions, Workflows).

- Develop and maintain integrations between Oracle EBS and other systems.

- Troubleshoot and debug technical issues related to Oracle EBS customizations.

- Perform unit testing, integration testing, and user acceptance testing of customizations.

- Participate in all phases of the project lifecycle, from requirements gathering and design to

testing and deployment.

- Collaborate with business users, functional consultants, and project managers to ensure

successful project delivery.

- Provide post-implementation support and maintenance for Oracle EBS customizations.

- Strong understanding of Oracle EBS architecture and data structures.

- Expertise in SQL, PL/SQL, and Oracle database concepts.

- Experience with Oracle Forms, Reports, and Workflow Builder.

- Experience with data migration tools and techniques.

- Document technical specifications, design documents, and test cases.

- Maintain and update technical documentation.

Qualifications :

Essential :

- 3 - 8 years of experience in Oracle EBS technical development.

- Hands-on experience in developing and implementing RICEW objects.

- Strong experience in data migration activities.

- Excellent analytical and problem-solving skills.

- Strong communication and interpersonal skills.

- Ability to work independently and as part of a team.

Preferred :

- Experience with Oracle Application Express (APEX).

- Experience with Agile development methodologies.