Data Integration Services
Featured Case Studies
Enterprise Data Warehouse
CapTech deployed a team of consultants on an Enterprise Data Warehouse data integration project to provide the client with a data mart necessary to optimize business operations...
Enterprise Data Warehouse Testing Process
CapTech provided the overall strategic direction and detailed planning for the system testing process and managed several teams of testers...
Enterprise DW Merchandise Financial Planning
CapTech provided a team of consultants responsible for providing the MFP group with the metrics and data necessary to optimize business operations...
CapTech has extensive experience developing Extraction, Transformation, and Load (ETL) applications in a variety of industries using ETL technologies such as Ab Initio, Informatica PowerCenter, IBM WebSphere Information Integration (formerly Ascential Software), and Microsoft's SQL Server Integration Services (SSIS).
CapTech has experience creating, conceptual, logical, and physical data models using common techniques/schemas (e.g. 3rd normal form, 4th normal form, star schemas, snowflake schemas, dimensional models) and common tools (e.g. ERWin, Visio, Designer 2000, etc.). Our consultants are experienced in all major relational database technologies including Oracle, Teradata, SQL Server, Netezza, and DB2.