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:

• Market data (Bloomberg, Reuters, Compustat, S&P, MSCI, Barclays)
• Trade order management systems (Charles River, Latent Zero)
• Accounting system data (Geneva, STAR, Axys, AFS)
• U.S. government data (census data, Bureau of Labor Statistics, etc.)
• Custodian data (State Street, BoNY, Northern Trust, BofA)
• Analytical data (Factset, Barclays, Intex, Markit Partners)
• Hedge fund data providers (Eurekahedge, Hedge Fund Research, LipperTASS)