Looking for talented Senior ETL Developers to join a Victorian State Government project.
Your new company
Victorian government's top statutory authority is looking for a Developer to be part of their Product Delivery Team for a long term contract.
Your new role
As a seasoned Developer with solid technical and soft skills, your key responsibilities include:
- Conduct data analysis and cleansing
- Perform source system data structure analysis and data profiling
- Perform data modelling as required
- Test, package and deploy the ETL solution
- Develop and maintain documentation related to ETL framework and data mapping
- Train other team members in the use of the ETL framework
- Mass loading of extracts of order texts.
- Release management - maintain multiple code baselines (development, test and production)
- Assist with the design of the data migration environment and perform infrastructure capacity and capability planning
- Liaise with PAAS providers to optimize environment
- Act as the technical liaison with the Vendor's technical data migration resources
- Create back-ups of databases.
- Perform DBA activities such as managing users, query optimisation, monitor database space etc
What you'll need to succeed
You'll need to have excellent communication and interpersonal skills. You'll also need:
- Demonstrable experience of similar roles in large-scale data migration projects, preferably within Victorian Government or similar environments
- Demonstrated abilityto develop technical and solution documentation
- Expert knowledge of Microsoft based ETL architecture and infrastructure
- Demonstrated ability to analyse EXPLAIN_PLAN and perform query optimisation
- Expert knowledge using PowerShell & Python
- 7+ years with ETL tools, including Microsoft SSDT-SSIS (would be highly regarded)
- Expert experience writing T-SQL code and knowledge of advanced SQL programming concepts
- Experience with implementing advance data migration automation e.g. notifications (SQL Mail Agent, Alerts and Scheduled SSIS package deployment)
- Ability to develop custom data flow components and/or scripting to solve complex problems
- Expert knowledge and experience with Database Mirroring and Replication concepts
- Experience of working with ADABAS data sources will be highly regarded
- Experience with migration to cloud-based platforms such as MS Azure will be highly regarded
- Knowledge of environment management or infrastructure (Azure) would be highly regarded.
What you'll get in return
You'll gain experience in teamwork across various technologies
- Flexible work environment
- Be part of the hybrid work culture
- Enjoy the diverse and inclusive workplace
- Excellent Daily Rates
If you think you are the right fit for the role, Please send your profile to .
📌 Senior ETL Developer
🏢 Hays
📍 Melbourne