Job Description
Position:
Oracle Integration Cloud (OIC) Consultant Duration:
Long-term contract, expected up to 36 months Location:
Detroit, MI (Onsite Position) Client:
City of Detroit (Detroit Water and Sewerage Department) Position Overview:
We are seeking an experienced Application Analyst - Integrations to support enterprise application integration, data flow, testing, and workflow improvement initiatives for a public-sector utility client. The consultant will work closely with internal business and technical teams to understand application needs, document workflows, support system integrations, perform testing, troubleshoot issues, and help improve business processes across critical software platforms. This role requires strong experience with Oracle Cloud Infrastructure, application integrations, APIs, middleware, testing, and business workflow documentation. Key Responsibilities:
Meet with business users and internal teams to gather and document business requirements. Analyze existing applications, systems, workflows, and integrations. Design, configure, test, and support application integrations. Support middleware, APIs, web services, and data mapping between enterprise systems. Troubleshoot application, data flow, integration, and system issues. Develop and support test cases for integrations, software upgrades, and application changes. Support user acceptance testing and coordinate testing with business users. Document business workflows and recommend improvements to reduce inefficiencies. Help improve transaction transparency, data accuracy, and customer-facing system performance. Identify risks, dependencies, and conflicts between applications, systems, and business processes. Support application enhancements, upgrades, replacements, and implementation activities. Provide training or knowledge transfer to end users and internal teams when needed. Work with client staff, project teams, and stakeholders in an onsite environment. Required Skills and Experience 8+ years of progressive experience as an Application Analyst, Integration Analyst, Systems Analyst, or similar IT role. 5+ years of experience with application integration design and development. 5+ years of experience with Oracle Cloud Infrastructure, Oracle applications, or OCI-based integration work. Strong experience with APIs, middleware, web services, data mapping, and enterprise system integrations. Experience developing test cases for integrations, software upgrades, and application changes. Experience supporting UAT, QA processes, and testing documentation. Experience documenting business workflows and recommending workflow improvements. Strong troubleshooting skills for application, integration, and data-related issues. Ability to work with business users and technical teams. Strong written and verbal communication skills. Must be able to work onsite in Detroit, MI during the initial phase of the project. Preferred Experience Experience with public-sector or utility-sector projects. Experience with Oracle Utilities Customer Care and Billing. Experience with enQuesta customer information system. Experience with CityWorks or GIS-based work order management systems. Experience with customer portals, payment systems, or billing integrations. Experience with Java, Python, SQL, stored procedures, CI/CD pipelines, or cloud-native microservices. Experience supporting data quality, customer privacy, data security, and customer satisfaction initiatives. Education Bachelor s degree in Computer Science, Information Systems, Engineering, Business, or a related technical field is required. Master s degree is preferred.
