Database Developer Job in Osbindia Private Ltd

This role requires database development skills. We use SQL Server so those in the role must have experience of that tool and coding in T-SQL. Many people can write SQL code but fewer have the experience to engineer data solutions. We re looking for developers who can build solutions which extract data from source and transform it into objects which the business can use to generate value.

This role is primarily technically focused working on data warehousing, ETL and migration projects plus database objects for self-service data consumers. Most of the interactions will be with fellow technical colleagues developers, testers and DBAs and data architects - and allied professionals such as business analysts and project managers.

Core Responsibilities

Working with the Product Owner and Data Architects to understand change requests

Developing the changes required in your tickets in a current code version on your own local database instance

Creating SQL Server database objects such as Tables, Views, Stored Procedures and Functions

Creating SQL Server Integration Services packages

Unit testing your changes and liaising with the test team who will write repeatable automated tests

Liaising with the Integration Lead to merge your changes into an Integration Build for Testing

Peer reviewing other Developers code

Attending Agile planning, retrospective and stand-up meetings

Maintain the company s compliance standards and ensure timely completion of all mandatory on-line training modules and attestations

Qualification/Certification

Educated to degree level or above in an IT related subject with significant a data element

Any MS SQL Server certification is a benefit but not essential so long as you can demonstrate your skills

GCSE/GCE qualifications in both maths and English are essential

ExperienceRequirements

3 years of experience of database development specifically for ETL / Data Warehousing /MI projects

3 years of experience with Microsoft SQL Server. Preferably 2016 and above

Experience of Azure DevOps / Visual Studio TFS or proxies such as JIRA and GIT

Previous experience working with an Agile project team is desirable

Previous experience working collaboratively with non-technical business users would be a benefit but is not essential

Knowledge Requirements

Advanced T-SQL is essential. By which we mean the ability to use a range of T-SQL objects and design patterns to solve complicated data problems

Proficiency in SSIS development is essential

Knowledge of SSRS and / or PowerBI would be desirable but is not essential

Knowledge of SQL Server temporal tables would be a benefit but not essential

Knowledge of Kimball Dimensional Modelling / Star Schema would be a benefit but not essential