dreamwork_

Specific skill set required

Microsoft Azure, .NET Core, Web API, SQL Server, Azure Data Factory + Data Flow and PowerBI

Graduation

B.E./ B.SC

 

Professional qualification

Graduate/ Postgraduate

  

?   Software prototyping and Construction

?   Design, Build and Modify existing business-tier components, Cloud solutions, Web applications, and database objects using Microsoft platform technologies (SQL Server) and Azure components.

?   Azure ADF related data flow activity, Processing API data, Azure data lake, updates to database through files using different kinds of ADF Activities

?   Experience in data migration

?   Experience in Designing data models

?   Experience in Optimization of SQL Server queries and performance tunning

?   Understand the functional specifications from management in a clear and concise manner

?   Experience in Data Retrieval and Analysis using SQL, Excel and other data management systems

?   Create prototypes, if necessary, to validate proposed solutions and seek feedback from stakeholders

?   Good understanding and experience following test-driven development and continuous integration practices

?   Analysis and Design

?   Transforms high-level design into the low-level design, and implementation.

?   Work with Project Managers and Business Analysts to properly define/clarify business requirements, development estimation, and work plan finalization

?   Analyze business user requests, estimate tasks throughout the project life cycle, design and document appropriate solution, and design the business components and database objects required to implement the solution

?   Work with the Development Team to design the front-end and back-end systems necessary to fulfil document requirements

?   Database normalization, performance tuning and expertise in complex SQL queries

?   Coordinate with peers on design implications and work with them to resolve issues

?   Support and Troubleshooting

?   Assist Operations Team with any environment issues during application deployment across Development, QA, Staging, and Production environments.

?   Assist Networking Group with troubleshooting problems that may arise from applications or integration of various components

?   Experience in working with the corporate environment by collaborating with teams across geographies

 

The key skills required are as follows:

?       Bachelor's/master?s degree in computer science, MIS, Information Technology, or related field of study

?       Should have 6+ years of overall experience in application design and development using the below Tools & Technologies

o    Primary: Expertise in SQL Server (design, programming and optimization), Azure Database components

o    Secondary: NET Core, Power BI

?       Experience in Report Analysis and Designing.

?       Experience in Designing data models.

?       Experience in Data Retrieval and Analysis using SQL, Excel and other data management systems.

?       Experience in optimization of SQL Server queries optimization and performance tuning.

?       Experience in working with the corporate environment by collaborating with teams across geographies.

?       Understand the functional specifications from management in a clear and concise manner

?       Facilitate the performance tuning of reports and timely issue resolution related to reporting support