Job Description
Responsibilities
Analyses current business practices, processes, and procedures as well as identifying future business opportunities for leveraging Microsoft Azure Data Analytics Services.
Engage and collaborate with customers to understand business requirements/use cases and translate them into detailed technical specifications.
Collaborate with project managers for project/sprint planning by estimating technical tasks and deliverables.
Skills
Good hands-on experience in SQL/SSIS
Experience in designing and hands-on development in cloud-based analytics solutions.
Good understanding on Azure Data Factory, Azure Synapse, Azure SQL, Azure Data Lake, and Azure App Service is required.
Designing and building of data pipelines using API ingestion and Streaming ingestion methods.
Thorough understanding of Azure Cloud Infrastructure offerings.
Strong experience in common data warehouse modelling principles.
SQL SERVER and involved in all phases of Software Development life cycle from gathering requirement, development, implementation, testing and support.
Excellent experience in Database Design, Development, and Implementation of client- servers Applications Database systems using MSSQL SERVER 2005 to 2019.
Expert in creating and using Stored Procedures, Triggers, Views and Functions and creating Jobs and SQL Mail Agent Expert in creating Sub-Queries and Joins for complex queries involving multiple tables and Exception Handlers has context menu
Other Requirements
Understanding of software development lifecycle
Excellent analytical and problem-solving skills.
Ability to work independently as a self-starter, and within a team environment.
Good Communication skills- Written and Verbal