Specifications include, but are not limited to: The University of Maine System (UMS) Information Technology (UMS:IT) department is in the process of building out a reporting environment for its institutional, human resources, and financial data. UMS:IT uses Peoplesoft Campus Solutions for its student information system, and is currently in the process of transitioning from Peoplesoft HCM and Financials to Oracle HCM Cloud and Oracle ERP Cloud, respectively. Previous attempts to build custom data warehouse objects have stalled due to lack of experience and resources. UMS:IT has experience working with Informatica IICS and Talend Open Studio for ETL transformations, and uses custom SQL Server databases to house data warehousing objects. We are seeking to partner with a firm with previous experience in consulting and contracting with institutions of higher education to design and build data warehouse objects. UMS:IT will work alongside the vendor to ensure appropriate transfer of knowledge to UMS:IT staff. The contracting/consulting services the vendor will provide include the following: ● Review of the current data warehousing architecture in use in the UMS environment, ● Review of the current ETL and data modeling tools for the UMS resources, and ● Data modeling and ETL pipeline assistance in building out initial data warehouse objects in service of the delivery of both a small scale student information data mart (or similar appropriate structure) and small scale human resource data mart (or similar appropriate structure). The focus of those structures will be determined during this engagement. The expected deliverables for this engagement are mapped to the above and should enable UMS:IT to define a strategy for continuing to build out the reporting environment. They will include: ● Delivered assessment and recommendations for a data warehousing structure/architecture, using Informatica IICS and integrations using Oracle Integration Cloud. ● Delivered assessment and recommendations for tooling regarding ETL pipelines and data modeling, ● One completed data mart (or structure in line with recommendations above) for student information and similar for human resources data. The scope of these deliverables will be determined as part of the engagement.
