SSIS & ETL

  • 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.
Comments