- Data Modeling.
- Develop ETL specifications, source to target mappings and other documentation required for ETL development.
- Completing complex tasks utilizing Visual Management Studio including job, replication and SSIS package creation, modification and maintenance.
- Creating and maintaining appropriate documentation for databases, production support and end-users.
- Data warehouse: Dimension table ETL, Fact table ETL, Audit table creation and ETL.
- Incremental Loading.
- Master Package Design---XML method.
|
|