ERP Analyst, Level 3

Jobtailor; Richmond (VA); On-site; USD 110,000 - 140,000; Full time

Job summary

Jobtailor in Richmond, VA is seeking an experienced Oracle E-Business Suite specialist to design, develop, and maintain PL/SQL packages and interfaces for EBS Financial modules (R12). You will work with APIs, Web Services, and flat-file integrations, and collaborate with DBAs and business teams to implement new functionality.

Responsibilities include troubleshooting defects, optimizing performance, coordinating system updates, adhering to secure coding and change-management policies, and

Qualifications

• 7 years of PL/SQL development and maintenance experience with Oracle tools.
• 7 years troubleshooting application issues, performance problems, and data discrepancies.
• 7 years experience developing data migrations and interfaces using APIs, Web Services, and flat-file formats.
• 7 years designing, developing, optimizing, and maintaining EBS Financial module customizations.

Responsibilities

• Analyze, design, develop, optimize, and maintain Oracle EBS Financial customizations, extensions, and integrations (R12).
• Support and enhance AR, AP, GL, and related financial processes.
• Develop and maintain PL/SQL packages, procedures, triggers, functions, and reports using Oracle tools.
• Support data migration initiatives and interface development via APIs, Web Services, and flat files.
• Troubleshoot defects, performance issues, and data discrepancies.
• Coordinate EBS updates with Database Administrators and IT teams.
• Implement system enhancements to meet evolving business needs.
• Ensure secure coding, change management, and IT governance compliance.
• Collaborate with business teams to gather requirements and document solutions.
• Work with DBAs and infrastructure teams to maintain reliable environments.
• Participate in planning, testing, deployment, peer reviews, and post-production support.
• Prepare technical documentation and conduct knowledge transfer.

Skills

PL/SQL development

Oracle EBS

Troubleshooting

Interfaces & data migration

Tools

TOAD

Oracle Forms

Oracle Reports

BI Publisher

Job description

Responsibilities

• Analyze, design, develop, optimize, and maintain customizations, extensions, and integrations for Oracle E-Business Suite Financial modules, primarily Oracle EBS R12.
• Support and enhance Oracle Financial modules, including Accounts Receivable, Accounts Payable, General Ledger, and custom-developed business processes.
• Develop and maintain PL/SQL packages, procedures, triggers, functions, and reports using Oracle development tools, including TOAD, Oracle Forms, Oracle Reports, and BI Publisher.
• Support data migration initiatives and develop interfaces using APIs, Web Services, and flat-file integrations.
• Troubleshoot and resolve application defects, performance issues, and data discrepancies.
• Coordinate Oracle EBS system updates with Database Administrators.
• Implement system enhancements that support evolving business and operational requirements.
• Ensure compliance with secure coding standards, change management processes, and IT governance policies.
• Work closely with business and functional teams to gather requirements, document solutions, and implement new functionality.
• Collaborate with DBAs, system administrators, and infrastructure teams to maintain reliable, high‑performing environments.
• Participate in project planning, testing, deployment activities, peer reviews, and post‑production support.
• Prepare technical documentation and provide knowledge transfer to internal teams and stakeholders.

Requirements

• 7 years of experience developing and maintaining PL/SQL packages, procedures, triggers, functions, and reports using Oracle development tools.
• 7 years of experience troubleshooting application issues, performance problems, and data discrepancies.
• 7 years of experience supporting data migration and interface development using APIs, Web Services, and flat-file integrations.
• 7 years of experience analyzing, designing, developing, optimizing, and maintaining customizations, extensions, and integrations for Oracle E-Business Suite Financial modules.
• Must be legally authorized to work in the United States without employer sponsorship, now or in the future.
• Must be a U.S. Citizen or Green Card holder.
• Must physically reside within the United States for the duration of the assignment.
• Must be able to interview via both Web Cam and In Person.
• Must be able to work on‑site as required.
• Local Richmond‑area candidates are strongly preferred.