Over the past eight years, Lunexa consultants have worked with a variety of extract, transform, and load (ETL) technologies in order to build data warehouses, datamarts and operational data stores (ODS) by integrating data from multiple transactional source systems. Many of these ETL development efforts have required high performance to load large volumes of data in a short period of time, either due to very compressed batch windows or due to requirements for near real time data. Lunexa consultants have the expertise to work with different ETL tools and to optimize the underlying code to meet the performance requirements.

Some of the technologies used by Lunexa consultants for ETL development include Ab Initio, Microsoft Data Transformation Services, Oracle Warehouse Builder, perl scripts and PL/SQL.