Senior Developer - Data Migration

Senior Developer - Data Migration.

• Role Type: Temporary (12-months), full-time opportunity with potential extension.
• Clerk Grade: 09/10 The package includes a base salary range of $ 120,859 to $133,183 plus employer's contribution to superannuation and annual leave loading.
• Location: Sydney, We offer flexible work arrangements across NSW.

Who we are
The Department of Customer Service (DCS) is a service provider and regulator, focusing on delivering first-class customer service, digital transformation and regulatory reform to create better outcomes for the people of NSW.
Government Technology Platforms (GTP) forms part of Digital.NSW and delivers core and common digital capabilities and infrastructure solutions including cross sector leadership across NSW Government underpinned by the Digital Government Strategy. Our Digital Programs team within GTP is currently recruiting at scale to deliver on high profile and exciting large scale digital transformation programs.
Benefits of working for DCS

• Accrued Flexible leave
• Hybrid working options- flexibility to work from home and office
• Potential to work anywhere in NSW
• Generous leave entitlements including up to 14 weeks parental leave
• Access to health and well-being programs including Fitness Passport
• Competitive pay and conditions

Project Background:
The Licensing Program delivered by the NSW Department of Customer Service (DCS) is one of eight Lighthouse Programs, with a vision “To be the world's easiest regulator to engage with through delivering smarter, customer centric digital solutions, reducing red tape, enhancing business productivity and protecting NSW communities.” To achieve that, existing licences 'schemes' will be digitised. This will be achieved by moving away the existing Siebel system into a new state of art licensing platform “Amanda”. As part of this transition all license information will be migrated from the existing Siebel system into the new Amanda system in a phased and agile delivery approach.
The existing Siebel system is a on on-prem solution, with and underlying database in MS SQL Server. Due to the complexity of the data and the scope of the project, additional source systems with varying source types are likely required to be included as part of the Data Migration execution. The target system Amanda is deployed on Microsoft Azure cloud with its underlying database as MS SQL Server.
DCS is looking for an expert Data Migration developer to join the established Data Migration team and be part of the exciting and challenging journey ahead.
Responsibilities:

• Develop pipelines in Azure data factory.
• Develop complex stored procedures, functions, views, triggers, and other DB objects.
• Devise and implement the required data transformations from the source system to the target system.
• Develop and document the functional and technical specifications.
• Execute Data Migration scripts for trial migrations, dress rehearsal and production migration.
• Perform in depth data analysis on defects and patterns surfaced during cut over, parallel/equivalence testing, undertaking root cause analysis and articulating findings to the affected stake holders.
• Understand the source and target systems from Data Migration requirements perspective and drive/contribute in source to target mapping workshops.
• Attend all meetings to provide expertise.
• Provide status updates on a regular basis.

Requirements:

• Expert knowledge and hands on experience of Microsoft's

• Azure data factory for ETL Data Integration pipelines
• Azure Cloud framework
• SQL Server Integration Services (SSIS)
• SQL Server Management Studio (SSMS)
• Expertise in TSQL, writing complex stored procedures, functions, views, triggers, and other Db objects
• Hands on experience in Azure devops CI/CD pipelines.
• Hands on experience in performance improvements.
• Ability to review, analyse and manage large volumes of data.
• Experience in regulatory licensing domain would be considered an advantage.
• Able to work under tight schedules and on multiple tasks.
• Ability to be flexible and adaptable to changing priorities.
• Excellent verbal and written communication skills.
• Outstanding attention to detail and a meticulous approach to work.

Applying is Easy! Launch your career to the next level by submitting your resume and a cover letter (maximum 2 pages) outlining how you meet the skills and experience of this role. We will then get back in touch after the closing date with the next steps.
Salary Grade 9/10, with the base salary for this role starting at $120859 base plus superannuation
Click to access the Role Description.
For enquiries relating to recruitment please contact Sujatha Sankaran Kutty via sujatha.sankarankutty@customerservice.nsw.gov.au.
Visit the to prepare for the recruitment process by accessing practice application and interview questions based on the focus capabilities listed in the role description.
Closing Date: Monday 15th January 2024 at 9:59am
Working at Department of Customer Service
The Department of Customer Service (DCS) is a great place to work! Our values of accountability, trust, service, and integrity drive our initiatives and culture. We support innovative programs in areas as broad as digital government, consumer protection and major public works. We are an inclusive organisation that celebrates diversity and flexible work practices and believe our people are our greatest asset.
Visit our to find out what it means to work for us.
You Belong Here
We are committed to diversity, inclusion, and new ways of working.
We have 8 million+ reasons to care and want our employees to represent the communities that we serve.
You can view our full diversity and inclusion statement .
We want you to bring your best self to this application process. If you feel you may require an adjustment during the recruitment process, please contact our Diversity, Equity and Inclusion team via sujatha.sankarankutty@customerservice.nsw.gov.au or 02 9494 8351.
For more information, please visit