I don't know anything about Pfizer's DWBI group, but I do know this (as I am sure of anybody who has worked among DW, BI, IT groups):
- quotes from external vendors are almost always understated. Furthermore, those vendors still require a lot of internal support and hand holding - and these are not included in the quote. Also, depending on the actual contractors, the decision making and architecture being implemented are very slow. If Pfizer spends years specifying the project in its entirety and in absolute detail, then the contractors generally do a fine job. Problem is, that may already be the bulk of the work. And also who the hell can minutely detail out the entire project - there are on-the-fly decisions that must be made, and the contractors in India sure as heck can't or won't make those.
- Data requirements are definitely, absolutely, going to increase exponentially. Teradata is well placed to handle that; it is certainly better than Oracle. However, there are other possibly better options (such as Neteeza, in my opinion). Also, if Pfizer's DW is geared towards analysis/reporting as most BI systems are, then they should also explore some of the newer column based databases.
- Generally, BI pros have a much broader knowledge base (including multiple platforms and customer facing skills) than the IT folks (i.e. DBAs, network admins, border security, SANs admins, etc). Again, not knowing about the DWBI group, I can only say that I sure hope that group falls within that pattern - it can't be successful without it. From the Wyeth world, the IT group (Shared Services) had slipped into a non-accountable/arrogant (but generally individually capable) stance. The concept of power corrupts, does apply here. Whereas, the Applications group have been treated as lepers - even though there are some very broadly skilled folks with excellent business knowledge, and extensive admin experience. This should be the technology group that is outsourced last, and then only when the business groups have acquired the necessary knowledge and skills to manage multi-platform solutions. However, years of management neglect has not well positioned Wyeth's IS/IT services. It's become like a technology Animal Farm, and the best option is to just sell the farm.