ETL Developer


Location: All Canberra > Canberra
Worktype: Contract
Profession / Role: I.T. & T > Analyst/Programmer

  • Federal Government Client
  • 6 months + 6 months contract
  • Australian Citizenship required
Our Federal Government client requires the service of an experience ETL Developer to join their team in Canberra. You will be responsible for the data migration ETL and can include identifying data sources within the system, analysing, assessing data, ETL development and documenting source to target mappings.

Responsibilities:

  • Leading the end to end data migration exercise and supporting the Project Manager to meet project timelines;
  • Undertaking data migration activities including identification of data requirements, data analysis and cleansing, source to target data mapping and the development of data migration plan and SQL scrips for data validation;
  • Collaboration and communication with third party vendors, analysts, application designers, project team members and business SMEs; and
  • Tracking and management of data migration risks and issues.

The successful candidate will have:
  1. Minimum of 5-7 years working as a Data Analyst/Developer with extensive data quality, data migration and data integration experience
  2. End to end data migration experience using SSIS & SQL Server Relational Database technologies
  3. Experience, including design, analysts, data extraction/cleansing and data quality assurance
  4. Demonstrated knowledge of data modelling, data cleansing and data enrichment techniques
  5. Demonstrated experience in technical writing, documenting guidelines and operational procedures including the ability to develop a data migration plan, schedule and test plans

Desirable to have:
  1. Experience with software vendor, Technology One's Business ETL tool
  2. Experience with Event Driven Architecture (EDA) or Service Oriented Architecture (SOA
  3. Demonstrated understanding of technical principles and the ability to assist with configuration of system interfaces using APIs
  4. Experience with data visualization and business intelligence software (e.g. Power BI)

Australian Citizenship required/ Baseline clearance preferred.

To be considered for this role, respond to this advertisement or contact Cameron at AUREC on 6162 9600.