Business Problem: There was a need to integrate data across various systems as part of the overall Enterprise Application Integration portfolio for the client
Our Solution: Develop Data Integration jobs to integrate various systems using the existing Enterprise Application Integration infrastructure. This includes a variety of sources ranging from flat files, Complex Flat files (mainframe), XML, RDBMS, SFDC to MQ messages. Services were also developed in PL/SQL to expose data from the data warehouse. The outputs include flat files, XML, RDBMS and MQ messages. The scope of work included production support for these newly developed data integration jobs.
Technology: IBM InfoSphere Information Server 8.7 – DataStage (Connectors for MQ & SFDC, XML pack, Complex File Stage), QualityStage, Oracle 11i, XML processing in PL/SQL