While organisations all long for that elusive single version of the truth, and while BI certainly can deliver, the real work starts way back – as far back as where data from multiple sources are integrated.Extract, Transform and Load (ETL) tools provide developers with a range of techniques to bring data together, and deal with differing data structures, business rules, granularity, timings, currencies, time-zone, languages… The list goes on and on.
We work closely with system and business analysts (either yours or ours) to determine the correct business rules, and develop robust loads to your data warehouse or other data repositories.
We have experience in Microsoft’s SSIS and IBM’s DataStage toolsets, as well as Oracle scripting skills.
