Job Description:
- Development & Customization: Designing and developing custom applications, Reports, Interfaces, Conversions, Extensions typically R12 or later and build RICE components
- Technical Support: Troubleshooting and resolving issues related to Oracle EBS modules.
- Workflow & Integration: Implementing and configuring workflows, approval processes, and system integrations.
- Database Management: Writing and optimizing PL/SQL queries, managing Oracle Forms and Reports Workflow, and BI Publisher
- Collaboration: Working with business units to gather requirements and ensure solutions aligning with organizational goals.
- Documentation: Creating technical documentation for developed solutions and configurations.
Core Technical Skills:
- Oracle SQL & PL/SQL: Proficiency in writing queries, stored procedures, triggers, and optimization techniques.
- Oracle Forms & Reports: Experience in designing, customizing, and maintaining Oracle Forms and Reports.
- Oracle Workflow & AME: Configuration of approval processes and workflows within Oracle EBS.
- Oracle Application Framework (OAF): Developing and customizing web-based applications within c.
- Interfaces & APIs: Expertise in Web Services, XML, and REST/SOAP API integration with third-party applications.
- Data Migration & Conversions: Using tools like Oracle Data Loader, SQL Loader, and API-based methods.
- Unix/Linux Scripting: Ability to automate tasks using shell scripting in a UNIX/Linux environment.
- Performance Tuning: Optimizing queries and system performance for efficient data processing.
- Documentation standards: Familiarity with AIM/MD050/MD070
Functional & Business Skills:
- ERP Module Understanding: Deep knowledge of Oracle EBS modules such as Financials, Supply Chain, Procurement, HRMS, and Manufacturing.
- Requirement Analysis: Ability to gather business requirements and translate them into technical solutions.
- Customization & Extensions: Developing personalization, extensions, and modifications based on business needs.
- Problem-Solving: Diagnosing issues in Oracle EBS and providing technical solutions.
Skills
Soft Skills:
- Communication & Documentation: Writing clear technical documentation and collaborating effectively with business teams.
- Project Management: Managing tasks, deadlines, and deliverables in ERP projects.
- Teamwork & Stakeholder Interaction: Working alongside developers, consultants, and end-users to ensure seamless implementation.
Added Technical Skills:
- Oracle Cloud ERP: Mastering Oracle Fusion Cloud alongside EBS can open doors to higher-paying roles.
- Advanced PL/SQL & Performance Tuning: Expertise in complex queries and system optimization.
- Oracle Application Framework (OAF): Specializing in OAF development for web-based Oracle EBS customizations.
- Integration & API Development: Knowledge of REST/SOAP APIs, Web Services, and cross-platform integrations.
- RPA & Automation Tools: Using UiPath, Power Automate, or Oracle BPA Suite for automating processes.
- Machine Learning & AI in ERP: Companies are increasingly looking for AI-driven ERP analytics and automation.
- Cybersecurity & Compliance: Understanding data security within ERP systems enhances your value in finance and government projects.
Preferred Certifications:
- Oracle certifications (OCP or Oracle Apps Developer Certification) are an advantage
- Oracle Certified Professional (OCP) - Oracle Database: Strong foundation in PL/SQL, database optimization, and administration.
- Oracle Cloud Infrastructure (OCI) Architect Certification: High demand for cloud expertise in enterprise applications.
- Oracle EBS R12 Technical Certification: Validates your knowledge in EBS customization and development.
- ITIL Certification: Useful for roles that involve managing ERP processes in IT service environments.
- PMP (Project Management Professional): Helps in leading ERP implementations, increasing salary prospects.
- Certified Scrum Master (CSM): Agile methodology is increasingly used in ERP project management.
- AWS Certified Solutions Architect: Some companies migrate Oracle workloads to AWS, making this a valuable addition.