Medicaid/MCare Eligibility Interface DeveloperOur client needs someone to help us reverse-engineer and document and upgrade the Medicaid/MCare eligibility interfaces that include highly complex data transformations written in PL/SQL and SQL. This Developer will be primarily responsible for upgrading and maintaining these interfaces, as well as making recommendations for future enhancements to these interfaces and help us transfer ownership of these interfaces from one support team to another.Representative tasks may include:Modifying or writing new PL/SQL packages and procedures based on requirements.Regression testing an interface after it has been migrated.Investigating interface issues:Troubleshooting slow SQL queries.Investigating underlying dataReverse-engineering undocumented logicReverse-engineering undocumented data structuresAnalyzing undocumented source dataCommunicating with other IT teams that support source systems to understand their underlying data and logicOracle SQLOracle PL/SQLData AnalysisRequired Skills:Oracle SQL and PL/SQL programmingUnderstand complex database table structures and relationships in an Oracle DatabaseAbility create tests that validate assumptions about interface code, both existing and newAbility to communicate with both technical and non-technical staff to understand existing systems.