Our client is seeking a Senior SQL Developer/Data Migration Specialist to design, develop and implement the data migration of the existing BAU DB2 Data warehouse into the newly completed MS SQL Server data warehouse.
Open to Australian Citizens Only (an internal security clearance will be required after interview)
Client: Federal Government-
Title: Senior SQL Developer/Data Migration Specialist
Location: Sydney CBD
Duration: 6 months + 3months
Christmas break from 23 Dec 2017 to 2 Jan 2018
Reports to Project Manager/Reporting Team Leader
Role:
This role, as part of the project team, is to design, develop and implement the data migration of the existing BAU DB2 Data warehouse into the newly completed MS SQL Server data warehouse.
Requirements:
- Extensive SQL Server / T-SQL development, triggers, stored procedures, SQL server full-text indexing experience
- Proven ETL development experience with Informatica and SSIS
- Visual Studio Data Tools in a source controlled environment (TFS, GIT etc)
- Proven data warehouse architecture knowledge including Data Modelling, Data vault, Scalability, MDM
- Knowledge of the Agile Methodology, Data Vault Methodology, DWH Testing Methodology (nice to Have)
You will be responsible for:
- Integration of current Production systems into the newly built Data Warehouse
- Integration of the system components with the newly built Data Warehouse
- Creation of technical documentation to support related support and development
