ETL Developer-Hybrid

• 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