What are the responsibilities and job description for the Oracle PL/SQL Developer position at Stellent IT LLC?
Oracle PL / SQL Developer (Integration Exp)
New York City, New York (Local Profile & Hybrid)
12 months contract
JOB DESCRIPTION
Integration Development and Support : Design, develop, and maintain enterprise integrations using Oracle PL / SQL, BizTalk, and UNIX shell scripts.
Implement ETL processes to ensure seamless data exchange between enterprise applications, such as WMS, Oracle CIS, GIS, and Designer XI.
Collaborate with cross-functional teams to integrate utility systems for improved data flow and business operations.
Work Management System (WMS) Integration : Support and enhance integrations with WMS for asset management, ensuring data consistency and reliability.
Troubleshoot and resolve issues related to WMS integrations and workflows.
Database Management : Develop and optimize Oracle PL / SQL packages, functions, stored procedures, and triggers to support integration and application needs.
Design and maintain database schemas, table partitioning, and indexing for performance optimization.
Perform data validation and ensure the integrity of enterprise data across systems.
Middleware and Application Integration : Utilize BizTalk for enterprise application integration, including designing workflows and managing message processing.
Develop APIs and web services to enable communication between internal and external systems.
Leverage middleware platforms like WebSphere MQ for reliable data delivery.
Technical Leadership : Mentor junior developers and provide guidance on integration best practices.
Lead technical discussions and collaborate with stakeholders to ensure solutions meet business needs.
Document integration workflows, system configurations, and data mappings for ongoing reference and support.
Troubleshooting and Problem-Solving : Analyze and resolve complex integration issues, including those related to WMS, CIS, GIS, and other enterprise systems.
Perform root cause analysis and implement preventative measures to ensure system reliability.
Utility Industry Expertise : Work on utility-focused projects, including WMS asset tracking, compatible units, GIS integration, and reporting solutions.
Collaborate with business users to understand requirements and deliver solutions aligned with industry standards.
Thanks and Regards
Kamal Mishra
