Data Extraction, Transformation and Loading

Data Agent ETL capabilities are specifically designed to facilitate the movement and transformation of large disparate data sets. The Data Agent ETL process has three major functions

• Extraction of data from one or more internal and/or external data sources
• Transformation of data along predefined business rules for data cleansing, reformatting, standardization, and aggregation
• Loading of data into the Data Mart

The Data Agent team has real-world data management capabilities, having worked with some of the largest global investment managers on a variety of data integration projects. Our “out of the box” data integration loaders include but are not limited to the following data sets:

• Built-in Data Loaders/Adapters
• General ledger packages
• Partnership accounting systems
• Private equity
• CRM systems
• Market data vendors (Bloomberg, Reuters, Compustat, S&P, MSCI, etc.)
• Custodian data (State Street, BoNY, Northern Trust)
• Synthetics (Markit Partners, Intex, etc.)
• Trade order systems (Charles River, Latent Zero)
• MBS analytical data (Fannie Mae, Freddie Mac, HUD, FHA)
• Economic statistics from MSCI, IMF, and U.S. government data sources (census data, Bureau of Labor Statistics, etc.)