Oracle EBS Tech Analyst: PL/SQL, Integrations & Migrations

SMX; Madison (WI); Sur place; USD 73 000 - 122 000; Plein temps

Avantages offerts par ce poste

Health insurance

Paid leave

Retirement plan

Résumé du poste

SMX is seeking accomplished Associates to develop, customize, and maintain Oracle E-Business Suite applications. You will write PL/SQL scripts, configure modules, and troubleshoot issues to support business processes and client requirements.

Key duties include integration interfaces, data migration, and collaboration with functional teams, with emphasis on RICE components, documentation, and system optimization. A bachelor’s degree and 5+ years’ experience are expected.

Qualifications

• Active clearance or public trust based on sponsor.
• Proficiency in SQL and PL/SQL, AME and Oracle EBS development tools; strong EBS architecture knowledge.
• Experience with PL/SQL, Oracle Forms, Reports, and OAF for custom solutions.
• Exposure to Projects, Purchasing, and budgeting.
• Familiarity with Oracle R12.2.x application schema and ability to create queries.
• Strong analytical, problem-solving, and communication skills.
• Ability to translate business needs into technical requirements.
• Experience with requirements gathering, testing, and solution design.
• Minimum of 5 years’ experience; postgraduate study may substitute per policy.
• Exposure to creating technical documentation
• Oracle APEX experience (or similar report writer)

Responsabilités

• 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 components.
• Documentation: Create and maintain detailed documentation for all development processes and solutions.

Connaissances

SQL

PL/SQL

Analytical skills

Communication

Requirements gathering

Technical documentation

Problem solving

Oral/written communication

Formation

Bachelor's degree in computer science or related field

Outils

Oracle EBS

PL/SQL

Oracle Forms

Reports

Oracle Application Framework (OAF)

XML Publisher

APIs

R12.2.x schema knowledge

Description du poste

SMX is seeking accomplished Associates to develop, customize, and maintain Oracle E-Business Suite applications. You will write PL/SQL scripts, configure modules, and troubleshoot issues to support business processes and client requirements.

Key duties include integration interfaces, data migration, and collaboration with functional teams, with emphasis on RICE components, documentation, and system optimization. A bachelor’s degree and 5+ years’ experience are expected.