- Initial contract until end of June'24 - paying up to $158 p/h
- Qld Government Opportunity based in Brisbane CBD
- Must possess migration experience from legacy SQL system to D365
Our client is a Queensland Department is a diverse department, which works towards justice for all Queenslanders through safe, fair and responsible community outcomes.
In this role, you will be an integral part of the Data team working mainly on SQL Server Integration Services (SSIS) and straight SQL, while you must possess a good understanding of the following to be successful in this role:
- Advanced understanding of database design and management
- Experience working with large amounts of data in a variety of formats and structures
- Expertise in programming languages such as SQL,
- Strong analytic skills and the ability to recognize patterns or trends in data
- Understanding of models related to the field, such as:
Database design development
* Segmentation techniques
* ETL frameworks (planning, set up, execution, error and exception reporting, some automation, progress reporting) - Data security and protection in ETL
Understand project, program, risk and data governance frameworks.
Able to insert themselves into any stage/ phase of a project or program comfortably.
Required Skills & Qualifications:
- Minimum of 10 years' experience as Data migration specialist from legacy SQL system to D365.
- Demonstrated experience in developing & implementing ETL solutions using Oracle, Microsoft SQL, and any other Relational Database Management System (RDBMS) databases.
- Hands on experience in creating and maintaining source to target mapping, transformation rules, loading methodology, error and exception reporting and implementation documents to support the ETL processes required to refresh the target database or data mart via multiple sources.
- Must possess exceptional SQL Scripting, data management and data analysis skills including the use of SSIS integration tools.
- Must have exceptional written and verbal communication skills, with an ability to communicate with both technical and non-technical stakeholders.
- Experience in
Data Migration from SQL to D365
* Data Mapping
* Conceptual data mapping
* Entity Relationship Diagrams (creation and analysis)
* Schema review and creation
* Transformation rule formulation
* Azure Data Factory set up with min / max batch sizes
* Azure pipeline heath checks
* Visual Studio
* Expert level - problem solving and logical thinking
* Data Protection acumen
* ETL framework creation, analysis and implementation
If you wish to apply for this position, please submit your resume by clicking the 'Apply Now' button. For further information please contact Monica Rodricks at Clicks IT Recruitment on +61 429 129 ***.
At Clicks we embrace diversity, inclusion and equal opportunity.
We provide reasonable adjustments, including alternate formats to the recruitment process for individuals with disability. If you require an adjustment to be made during the recruitment process, please call 1300 254 257 or email ***********@clicks.com.au