Every data integration project is completely unique but they all share certain characteristics.  Data integration involves combining data residing in different sources and providing users with a unified view of this data.  Almost always there are data quality issues encountered that must be addressed and a strategy for dealing with them on an ongoing basis formulated.

• Creation of master schema and associated metadata
  
• Creation of an Operational Data Store (ODS)
  
• Creation of a Data Warehouse
  
• Master Data Management (MDM) techniques
  
• SSIS ETL package creation
  
• Data cleansing
  
• Data replication
  
• Provision of service APIs (eg. web service interface)
  
• Provision of UI's to manage data and metadata