Back to job search
ETL (SSIS) & SQL Developer
Job title : | ETL (SSIS) & SQL Developer |
Contract type : | Contract |
Sectors : | |
Job Reference : | 2924302 |
Contact name : | joanne Finchett |
Contact email : | joanne@whizdom.com.au |
Job published : | about 5 years ago |
Seeking a ETL (SSIS) & SQL Developer to develop and maintain programs that will be used to support a data migration project and will be responsible for the data migration ETL. This can include identifying data sources within Technology One, analysing, assessing data, ETL development, documenting source to target mappings.
The Role:
You will report to the Project Manager and the successful candidate will work closely with the IT Project Manager, Data Migration Lead, Business Analyst, Architecture Team and Business to facilitate data migration success.
Duties will include but are not limited to:
- Designing, developing and maintaining new and existing ETL for a data migration project using the Microsoft SSIS and SQL Server Relational Database technologies;
- Support Data MIgration Lead and Project Manageer in meeting project timelines;
- Identify risks, issues in the data and escalate for review and corrective action where necessary;
- Undertake data analysis and migration activities;
- Undertake data analysis over various production-scale data sets to understand data/data structures;
Duties will include but are not limited to:
- Designing, developing and maintaining new and existing ETL for a data migration project using the Microsoft SSIS and SQL Server Relational Database technologies;
- Support Data MIgration Lead and Project Manageer in meeting project timelines;
- Identify risks, issues in the data and escalate for review and corrective action where necessary;
- Undertake data analysis and migration activities;
- Undertake data analysis over various production-scale data sets to understand data/data structures;
Skills and Experience Required:
- Minimum of 5 years demonstrated experience working as a Technical/Systems/Data Analyst delivering multi-faceted artefacts for government programs and/or projects.
- Demonstrated ETL experience
- Demonstrated experience and skills in identifying 'as is' and 'to be' system and data requirements
- Demonstrated experience with strong communication skills, including prioritizing, problem-solving and interpersonal relationship building
- Strong engagement skills and ability to act as the technical SME while communicating with the project team, vendor, business and
- SME's to define the needs based on an understanding of business, information and technical constraints
- Demonstrated experience in technical writing, documenting guidelines and operational procedures
- Demonstrated ability to understand various data extracts, transform and join together for a successful data load as part of data migration
- Ability to use various methods to analyse and query data under limited direction
Nice-to-have skills and experience:
- Experience in the analysis, design, delivery and transition of solutions for Human Resource (HR) functions at Australian Federal Government organisations, which may include our legacy; PeopleOne HRP (TechnologyOne)
- Demonstrated understanding of technical principles and the ability to assist with configuration of system interfaces using API's.
SSIS experience
Canberra based
Contract Term - 6 Month Contract with possible 6 month extension
Security Requirements- Applicants must be Australian Citizens.
Applications close 28 April, please upload your resume to apply. Please note, that selection criteria is required for this role.
Call Jo Finchett 1300 944 936 for any further information.
Job has Expired