Senior Oracle EBS Analyst – PL/SQL & Integrations

SMX; Trenton (NJ); On-site; USD 73,000 - 122,000; Full time

Job summary

SMX is seeking accomplished Associates to develop, customize, and maintain Oracle E-Business Suite applications, including writing PL/SQL scripts, configuring modules, and troubleshooting issues. You will support business processes, collaborate with functional teams, and perform data migration and integrations to ensure system functionality meets client requirements.

The role requires strong SQL/PLSQL skills and a solid understanding of Oracle EBS modules, with a focus on GL, Cash Management,

Qualifications

• Active clearance or public trust (sponsor dependent).
• Proficiency in SQL and PL/SQL, along with experience in Oracle EBS development tools and a strong understanding of the EBS application architecture.
• Oracle EBS core financial accounting knowledge with a concentration in GL, Cash Management, and Treasury Management modules experience to include financial accounting experience for transition of legacy financial statements and interrelated data functionality from legacy system to the modules
• Strong analytical and problem-solving skills to troubleshoot and resolve technical and functional issues.
• A good grasp of business processes, especially in areas like financials (AP, AR, GL) or other functional modules.
• Experience with data integrity, system optimization, and working within a Software Development Lifecycle (SDLC).
• A bachelor’s degree in computer science, information technology, or a related field.

Responsibilities

• Development and customization: Design and develop custom applications, reports, extensions, and workflows within Oracle EBS to meet business needs.
• Integration: Build and maintain interfaces for data migration and integration with other systems, often using tools like XML Publisher or APIs.
• Technical support: Provide day-to-day support, troubleshoot issues, and perform root cause analysis for the Oracle EBS environment.
• System administration: Perform system analysis, conduct upgrades, and ensure system performance, stability, and data integrity.
• Testing: Perform functional testing and debugging of RICE (Reports, Interfaces, Conversions, Extensions) components.
• Documentation: Create and maintain detailed documentation for all development processes and solutions.

Skills

SQL

PL/SQL

EBS architecture

Analytical thinking

SDLC

Financials knowledge

Education

Bachelor’s degree in computer science, information technology, or related field

Tools

Oracle APEX

Oracle EBS R12

Procurement module

Projects costing module

Job description

SMX is seeking accomplished Associates to develop, customize, and maintain Oracle E-Business Suite applications, including writing PL/SQL scripts, configuring modules, and troubleshooting issues. You will support business processes, collaborate with functional teams, and perform data migration and integrations to ensure system functionality meets client requirements.

The role requires strong SQL/PLSQL skills and a solid understanding of Oracle EBS modules, with a focus on GL, Cash Management,