Technical Consultant – Data Lead Developer

Job Title
Technical Consultant – Data Lead Developer
Years of Experience
10+ Years of Experience
Job Description

• Must work with Functional consultant and Customer Subject Matter Experts to understand the requirements and provide a solution.
• Participate in all the Sprint ceremonies – Daily standup, Sprint Planning, Backlog Grooming and Sprint Review calls.
• Experience with the Microsoft Azure platform and Synapse Workspace, as well as knowledge of database design principles, data acquisition, and data access analysis and design are highly desired.
• The ability to translate technical specifications and/or logical and physical design into code for new or enhancement projects.
• You should be self-motivated with the ability to work with minimal supervision while supporting multiple projects and activities.
• Experience working with Microsoft SQL Server in a database development role, with the ability to understand and write complex SQL code. Knowledge of query optimization, indexes, and performance tuning techniques in MS SQL Server

Required Skillset

• Must Have

o Must have worked as an SQL Developer for minimum 8 years, with relevant experience of minimum 2 year in Azure Data Factory, Azure Data Bricks, Azure Data lake and Azure Synapse
o Must have experience is writing Azure Dat bricks Notebooks
o Experience in writing complex SQL Stored procedures, SQL Queries.
o Experience in SSIS packages.
o Worked on SQL Performance improvements.
o Must have good Experience in Power BI
o Basic knowledge in testing.
o Knowledge on Azure Data Factory, Azure Data Bricks, Azure Data Lake and Azure Synapse

• Preferred

o Knowledge on Dynamics 365
o Knowledge in Azure Devops
o Knowledge on Scrum Process