Senior Database Developer

Solugenix; Hyderabad; On-site; INR 1,500,000 - 2,300,000; Full time

Job summary

Solugenix in Hyderabad is seeking a Data Warehouse Developer with strong SQL Server skills to design, implement and optimize data warehouse solutions.

You will develop SSIS packages, SSRS reports, and nightly SQL jobs, monitor loads, and coordinate with onsite client counterparts, taking end-to-end ownership of deliverables using Azure DevOps. Collaboration across teams and adherence to processes are expected. Synapse, ADF and performance tuning are beneficial assets.

Qualifications

• Bachelor's degree in technology or equivalent.
• Experience with SQL Server Data Warehouse design and development.
• Strong knowledge of SSIS/SSRS and ETL processes.

Responsibilities

• Development of new projects/enhancements in Data warehouse (SQL server Datawarehouse).
• Implementation/enhancement of new Procs, functions, views, Triggers and jobs.
• Creation, scheduling and maintenance of nightly jobs using SQL Server Agent
• Monitoring the nightly loads.
• Development /enhancing of SSIS packages.
• Excellent command on SSIS - Deep knowledge of SSIS package - Visual Studio 2017
• Development /enhancing of SSRS reports.
• Optimizing/ performance tuning the SQL objects
• Ability to coordinate independently with Onsite client counterparts
• Takes end-to-end ownership of deliverables
• Follows all required processes and status updates including Azure DevOps status and timekeeping.

Skills

Data warehouse

SQL Server

Stored procedures

Functions

Triggers

Views

SSIS

SSRS

Azure DevOps

Git

Azure Data Factory

Synapse

Microsoft Fabric

Education

Bachelor's degree in technology

Tools

SSIS

SSRS

Azure DevOps

Git

Azure Data Factory

Synapse

Microsoft Fabric

Job description

• Good knowledge and understanding of Data warehouse
• Good knowledge of SQL Server
• Stored procedures,
• functions
• Triggers
• Views
• Optimization/ performance tuning of procs/functions/views.
• Excellent Command on SSIS and SSRS
• Knowledge of Azure DevOps and GIT
• Knowledge of Azure Data factory (ADF ) concepts and hands‑on experience of working on ADF on one or more projects

Must Have & Desired Skills: Must have skills:

• Development of new projects/enhancements in Data warehouse (SQL server Datawarehouse).
• Implementation/enhancement of new Procs, functions, views, Triggers and jobs.
• Creation, scheduling and maintenance of nightly jobs using SQL Server Agent
• Monitoring the nightly loads.
• Development /enhancing of SSIS packages.
• Excellent command on SSIS - Deep knowledge of SSIS package - Visual Studio 2017
• Development /enhancing of SSRS reports.
• Optimizing/ performance tuning the SQL objects
• Ability to coordinate independently with Onsite client counterparts
• Takes end-to-end ownership of deliverables
• Follows all required processes and status updates including Azure DevOps status and timekeeping.

Desired Skills:

• Synapse
• Microsoft Fabric.

Education:

Bachelor's degree in technology or equivalent.