Project Management

If you need a project manager for your datawarehouse project then we can help. Our project managers are skilled in managing through the whole project lifecycle, from initiation right through to setting up support.

Systems / Data Analysis

Often it is necessary to spend time up front to analyse legacy code or data in systems to allow extracts to be specified and built. This takes not only multi-language skills but also the ability to dissect and analyse multiple data sets. Knowing how to spot potential data quality issues and how to use the available tools to identify key-attributes takes experience and time. At The Datawarehouse Company we have consultants who have years of exposure to exactly this kind of detailed analysis.

We can use tools such as Informatica's data profiler and Avelino to extract a huge amount of meta-data from sample data extracts.

Testing

Taking a set of requirements and extrapolating them into a test strategy and set of test scripts that will cover every business-critical scenario is no mean feat when it comes to something the size of a data warehouse. It is necessary to fully understand the details of the data feeds and the business logic within the ETL layer in order to construct custom input files that allow for negative testing of the system. Our testers have performed this task on numerous projects.

We are also skilled with test and defect management tools such as Mercury Quality Centre.

Support

Delivering a datawarehouse project into production is one thing but having arrived at that point you need to keep it running smoothly. Setting up the required monitoring and alerting, integrating with tools like Autosys, and making sure that data quality is continually checked are all things we can help with. We can also provide people that can operate your datawarehouse systems and deal with day to day BAU issues should they arise.