ETL Developer - Melbourne
- Melbourne, VIC
- $450-500 per day
- Contract
- Full-time
Location: Melbourne
Contract Duration: 6 Months with high possible extensions
Experience: 7+ YearsKey Responsibilities:
- Design and develop complex ETL packages using Full/Incremental Load strategy Using Microsoft integrated services.
- Creating design Document/ Development of Framework and implementation checks in SSIS packages.
- Extensive knowledge and experience developing stored procedures, views and functions using Microsoft SQL Server.
- Troubleshoot issues related to package debugging, SQL performance, configuration.
- Azure DEVOPS Implementation for deploying SSIS Packages.
- Extensive knowledge in Azure Data factory Pipelines, Triggers, and configurations.
- Must have hands on experience in developing ADF pipelines , blob storage, link services , azure logs.
- Must have hands on experience in azure portal.
- Good Knowledge in Azure concepts like storage accounts, Key Vault, azure functions, Log analytics, Azure File storage concepts.
- Good experience in Azure SQL MI Management and configuration of failover Groups
- Knowledge on Database concepts (data base creation, data base restore using storage accounts etc., Backups)
- Knowledge on Database security Roles.
- Knowledge of DB Health check and performance tools.
- Should be able to analyse and optimize SQL queries and provide tuning recommendations time/CPU consuming queries if situation arises.
- Should interface with third party providers, plan and execute releases and hot fixes.
- Establish system administration processes for production support activities.
- System Integration testing and Support to user acceptance testing.
- Experience in development of c#.NET.
- Knowledge on Kingsway soft adaptor with Dynamics CRM is additional.
- Proficiency in git and source control systems.
- Able to provide Estimates and review development tasks based on the requirement.