Hi,
Please find my direct client job requirement for your consideration.
Title: Microsoft SQL Server Developer
Location: Salem, OR
Duration: 07 Months
Client: State of OR
Job Description :
The Office of Information Services (OIS) is a shared service provider for the Oregon Health Authority (OHA) and the Oregon Department of Human Services (ODHS). OIS provides the technology systems and services that support more than 11,000 OHA and DHS agency staff at local offices and facilities around the state. These systems and services help the two agencies determine client service program eligibility; provide medical, housing, food and job assistance; provide addiction, mental health, vocational and rehabilitative services; protect children, seniors and people with physical and/or developmental disabilities; process claims and benefits; manage provider licensing and state hospital facilities; and promote and protect the state public health.
OIS seeks an experienced Application Systems Analyst/Programmer 4 to function as an Exchange Developer in support of the OR-Kids Child Welfare information system.
Scope:
With multiple new systems being developed and implemented, the Child Welfare development team needs extra support to implement data exchanges between the systems. The OR-Kids Exchange system uses Enterprise Integrations Patterns to provides data exchanges using Rest and Soap transactions for real time communications and a variety EDI formats such as HL7, x12 and NACHA for batch file transactions. The OR-Kids Exchange system uses Apache Camel Java DSL on a Red Hat JBoss EAP platform as well as Microsoft SQL Server database stored procedures and functions. The key person will focus on implementing these services and updating the data structure interface to map to our current data model.
Required skills and experience:
In addition, the ideal candidate will have skills and experience in:
Technical Skills:
Type
Category
Qualification
Description
Competency
Required
Skills
Architecture
Service oriented architecture (SOA)
Proficient (4-6 Years)
Yes
SOAP
Database
Microsoft SQL Server
Advanced (7-9 Years)
Languages
Java
JSON
SQL
XML
Others
Service oriented architecture / Web Services - REST
SQL Server Stored Procedures, Functions, Queries
Understanding of Git
JBOSS Fuse
No
.Net Core 3.1 Development
Apache Camel
Business to Technical translation
Able to understand business requirements, translate them into technical requirements
Curious, creative thinker
ETL Development
Experienced Problem Solver
Familiarity with Continuous Integration
Communication skills both verbal and written