ETL Developer – B3 band
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.
SSIS