POSITION SUMMARY
The Integration & API Developer maintains the service-oriented and API integration layer of the TMS: Web Services (SOA), REST/SOAP APIs, external interfaces to MoCARS, Financial Services, and the FHA Highway Capacity Software XML interface. The TMS exposes approximately 269 functions and 123 stored procedures as services consumed by both internal TMS modules and external state systems. As MoDOT pursues ERP integration and API modernization, this individual leads the technical design of new integrations through the SOW process and maintains the currency and reliability of existing interfaces. This position is not submitted as an Exhibit E biography.
KEY RESPONSIBILITIES
· Maintain and support all TMS external interfaces and integrations: MoCARS accident data import, Financial Services interface for Traffic utility costs, Federal Highway Administration Highway Capacity Software XML file interface, and state ERP system integration as it develops
· Maintain and update online and batch applications that consume or publish Web Services (SOA); ensure REST/SOAP API endpoints remain compatible with downstream consumers after any TMS modification (§2.2.3)
· Support the SIMS interface and integration with the statewide ERP system MoDOT anticipates in the near term
· Design and develop new API-layer SOW deliverables: define interfaces, write service contracts, implement, test, and document according to MoDOT Best Practices and the SOW milestone schedule
· Perform integration-level impact analysis before any TMS structural change: identify which external systems consume affected data and services; document findings for the Lead Analyst
· Maintain WCF services, Windows Communication Foundation components, and Console application interfaces within the TMS application portfolio
· Support the nightly batch processing layer that interfaces with Oracle: batch jobs (80 scheduled), procedures invoked by external triggers, and data exchange packages
· Coordinate with the Oracle DBA (Position 6) on data-exchange schema changes; coordinate with the GIS Engineer (Position 7) on ArcGIS REST service consumption
· Enter time in Service Desk Plus weekly; resolve assigned API/integration tickets within agreed timeframes
REQUIRED QUALIFICATIONS
· Minimum 3 years of integration and API development experience in a .NET enterprise environment
· Minimum 1 year of experience with Web Services (SOA) (§2.2.3)
· Minimum 1 year of experience with REST/SOAP APIs (§2.2.3)
· Experience with WCF, .NET Web API, or ASP.NET Core API development
· Experience with Oracle database integration (ADO.NET, ODP.NET, or equivalent)
· Ability to pass MoDOT background check
PREFERRED QUALIFICATIONS
· Minimum 1 year of experience with transportation-related applications (§2.2.3)
· Experience with XML/XSLT data transformation for federal data-submission interfaces (e.g., NBI submittal, FHA XML)
· Familiarity with EDI or batch file-based integration patterns
· Experience with Azure Service Bus, Logic Apps, or other Azure integration services
· Missouri residency or St. Louis metro area location
· Experience integrating with ESRI ArcGIS REST services from a .NET API consumer perspective.