|
|
ETL |
Does the same data from your accounting application and sales application differ in value?
Do you have problem in integrating data from multiple application?
Do you want to combine all enterprise level data into a data warehouse?
Our ETL service is the key to consolidating this data and delivering an information infrastructure that meet your strategic business intelligence (BI) initiative and reporting requirement. We take a quality centric approach to the design and development of ETL to ensure that reliable data is delivered at all times.
Our agile development methodology is well suited to support the changing requirement of your data warehouse that evolves with change in your business process. We specialize in Microsoft SQL Server 2000 DTS and Microsoft SQL Server 2005 Integration Service.
|
| Process |
- Understand the requirement of the data warehouse
- Study source system and application in alignment with business goal
- Understand the data model and the data warehouse architecture
- Review and understand data quality requirement
- ETL process specification
– Understand requirement and provide design specification for:
- Scheduling
- Sequencing
- Recovery
- Restart
- Error logging
- Notification
- ETL component specification
– Understand requirement and provide design specification for:
- Data extraction & movement
- Data staging
- Data cleansing & transformation
- Data loading
- Metadata repository
- ETL security
- Create and validate ETL architecture
- Develop processes for ETL
- Create ETL components
- Unit testing & Integration testing
|
|
|