Role name:
PL/SQL Developer with Oracle EBS exp.
Role Description:
Candidate will have strong expertise in PL/SQL, SQL Server (T-SQL), SSIS, and Oracle E-Business Suite (EBS) with a focus on Supply Chain Management modules. You will be responsible for designing, developing, and maintaining PL/SQL programs and integrating them with Web Services and other enterprise applications.
Key Responsibilities:
Develop and maintain PL/SQL programs for integration with third-party applications and Web Services.
Create and optimize SQL Server Integration Services (SSIS) packages.
Support and enhance Oracle EBS modules including Order Management (OM), Inventory (INV), Bills of Material (BOM), Work in Process (WIP), Accounts Payable (AP), and Accounts Receivable (AR).
Collaborate with business analysts and functional teams to understand requirements and translate them into technical solutions.
Design and implement data workflows and integration logic using PL/SQL and T-SQL.
Monitor and troubleshoot integration processes to ensure data accuracy and system reliability. Required Skills & Experience:
Strong hands-on experience with PL/SQL and SQL Server (T-SQL).
Proven expertise in developing and managing SSIS packages.
Solid understanding of Oracle EBS Supply Chain Management - Distribution modules: OM, INV, BOM, WIP, AP, AR.
Experience integrating applications via Web Services (SOAP/REST).
Ability to analyze complex data and provide optimized solutions.
Strong debugging, problem-solving, and performance tuning skills.
Location:
York, PA