Connecting...

Sr SQL Developer/Data Migration Specialist

Job Title: Sr SQL Developer/Data Migration Specialist
Contract Type: Contract
Location: Sydney CBD, New South Wales
Industry:
Salary: Negotiable
Start Date: October 2017
Reference: 177170_1505184486
Contact Name: Nivy Sahoo
Contact Email: nivy.sahoo@peoplebank.com.au
Job Published: September 12, 2017 12:48

Job Description

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