Specifications include, but are not limited to: UMS (minimum) requirements for Data Integration (DI) tool: Access data and integrate with a variety of sources (both various databases & data files), as well as enterprise applications, such as enterprise resource planning (ERP), customer relationship management (CRM), Software-as-a-Service (SaaS); data services such as SOA and REST; and unstructured data sources. Insert, modify and delete data into a variety of target systems, such as databases and files. Must interact with sources and targets supporting a variety of data capture and delivery methods, including batch acquisition and delivery, bulk import and extract, change-data capture (CDC), and scheduled or event-based data acquisition. Must have basic transformation capabilities, including data-type conversion, date functionality, string handling, NULL processing, mathematical functions and relational-type logic. Must have workflow orchestration capabilities that include IF-THEN-ELSE logic, looping, case style conditional processing, and passing variables. Must have advanced transformation capabilities that support integration processing specific for DW and BI such as slowly changing dimensions (SCD), aggregation and time series.
