onsite
Oracle iStore Technical Analyst EBS PL/SQL OM AR - Frontend Arts Inc
Software Engineer
Senior analyst responsible for designing, documenting, and optimizing Oracle iStore e‑commerce solutions within EBS, leveraging PL/SQL, Order Management, and Accounts Receivable modules to deliver high‑performance, secure, and scalable digital commerce platforms.
About the role
Key Responsibilities
- Analyze, document, and enhance Oracle iStore e‑commerce architecture within Oracle E‑Business Suite.
- Develop and maintain PL/SQL scripts, stored procedures, and triggers to support iStore, Order Management, and Accounts Receivable processes.
- Collaborate with cross‑functional teams to design integration points between iStore and external systems (CRM, ERP, payment gateways).
- Perform performance tuning, data migration, and data integrity checks to ensure optimal system reliability.
- Provide technical guidance and troubleshooting for production incidents and user support.
Requirements
- 5+ years of experience with Oracle EBS, specifically iStore, Order Management, and Accounts Receivable modules.
- Strong proficiency in PL/SQL, SQL, and Oracle database administration.
- Hands‑on experience with Oracle Forms/Reports and iStore configuration.
- Excellent analytical, documentation, and communication skills.
- Ability to work independently and in a fast‑paced, collaborative environment.