Application Development & Support Specialist

Job Title: Application Specialist SCM Technical

Location:

Job Summary:

Application Specialist SCM Technical

Key Responsibilities:

• Design, develop, and customize Oracle EBS concurrent programs using PL/SQL packages, procedures, and functions to automate key SCM business processes.


• Build and maintain custom interfaces and data migration scripts using SQL Loader, PL/SQL, and Oracle APIs.


• Develop operational and analytical reports using Oracle Reports Builder, XML Publisher, and Discoverer.


• Troubleshoot and resolve issues related to Sales Orders, Purchase Orders, and Drop Ship Orders in Oracle EBS.


• Implement bug fixes and performance enhancements in Oracle PL/SQL objects.


• Ensure seamless integration of Oracle EBS with third-party applications via Enterprise Integration (EI).


• Collaborate with business users to resolve issues in P2P and O2C processes, ensuring smooth transaction flows.


• Ensure code quality through rigorous testing, debugging, and documentation.

Required Skills:

• Strong expertise in Oracle EBS (SCM modules), PL/SQL, and Oracle APIs.


• Experience with Oracle Reports Builder, XML Publisher, and Discoverer.


• Familiarity with SQL Loader and data migration techniques.


• Experience with DevOps practices, CI/CD pipelines, and automation tools.


• Strong analytical, problem-solving, and debugging skills.


• Ability to work independently and collaboratively in a fast-paced environment.


• Excellent communication and cross-functional collaboration skills.


• Familiarity with Waterfall methodology and task ownership mindset.

Tools & Technologies:

• Development & Integration:

  SQL Developer, Oracle EBS, Oracle APIs



• Monitoring & Deployment:

  WinSCP, SBM, Dimensions CM



• Reporting & Analytics:

  Oracle report builder and XML publisher, Power BI, DAX, Snowflake



• Additional, it is nice to have skills

  - Power BI, Dax, Snowflake, Grafana, Splunk, AppDynamics (or similar tools)

Preferred Qualifications:

• Bachelor s degree in computer science, Information Technology, or a related field.


• Prior experience at IT Consulting services organizations.