Specifications include, but are not limited to: Data Integration Specialist (SQL Server) Work with assigned technical lead to understand data mapping requirements between SCS legacy systems and Oracle ERP Cloud data load requirements Work with SCS IT staff to understand APECS table structure and relationships Document all mapping relationships, data transformation logic, and data cleansing requirements Design, code, and test all required extract, transform, and load (ETL) programs to support SCS Oracle ERP Cloud data load requirements Work closely with the District’s Oracle implementation partner (CherryRoad Technologies) to test, validate, debug, and confirm all data load processes and results Complete all required ERP conversion export files, complete with file ordering requirements, using the mapping provided by the functional team and technical support team.
