AYAN InfoTech is looking for ETL Developer to join an exciting project based in Melbourne. The role offers you the opportunity to contribute towards an extremely well structured and mature environment, working on sophisticated enhancement projects.
Role: ETL Developer
Location: Melbourne
Contract Duration: 6 Months with high possible extensions
Experience: 7+ Years
Key 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.
Contact: 61-(02) 7207 6926 for more details.
Please note we will be able to contact only shortlisted candidates for this role. We thank you in advance for your interest.
