SQL Developer - Data Warehousing & Performance Tuning

Job Designation : SQL Developer

Job description :

Roles and Responsibilities (Along with Skills Required) :

• SQL development via expertise in all aspects related to it. This means analysis to understand the business requirement, taking an optimized approach to developing code and ensuring data quality in outputs presented
• Advanced SQL to create and optimize stored procedures, ctes, functions and performance optimize
• Approach analytically to translate data into last mile SQL objects for consumption in reports and dashboards
• Develop reports in SQL Server Reporting Services.
• Design, Develop and Deploy SSIS Packages.
• Identify and write best possible code in case of new deployments or when rewriting code when migrating to newer version of SQL Server.
• Participate in discussions involving the application creation and understand the requirements and provide the back-end functionality for the applications.
• Participate in development and creation of Data warehouses.
• Create cubes in SQL Server Analysis Services.
• Must have knowledge of MS-Excel
• Should be good in different types of Joins, writing queries as per scenarios and using different type of clause (like where, IN, OR, NOT IN etc.

indexes and code optimization.

• Should have good analytical experience and working with data and tables to make relevant queries as per requirement.
• Knowledge in MYSQL features to use in Data Analysis.

ref : hirist.tech)