Informix SQL Expert

Description

Study and understand the data structure and system requirements of the Court s CORIS case management application.Study and understand the data structure and system methodologies of the Salt Lake City Justice Court's legacy case management systems. (Salt Lake City Justice Court's data is currently split between two systems, and must be consolidated into a single CORIS system.) Design and create Informix tables to mimic the legacy system s data structures (staging tables).Develop and test the procedures to populate the raw data from the legacy systems into Informix staging tables.Develop a process to consolidate the data from the two legacy systems into a single set of data.Identify the appropriate data element correlations between the two legacy systems and the CORIS system.Identify the appropriate data value mappings between the two legacy systems and the CORIS system.Using Informix Stored Procedure Language, write, test and document the programs needed to appropriately massage and migrate the data from the two legacy system s data base structure into the court s CORIS data base structure.Assist in the execution of the data conversion.Respond with action plans to post conversion issues that arise