• Principal Database Developer Jobs in Chandigarh,India

  • BD INDIA PVT LTD
  • Save Job
  • 13 - 16 Years
  • Posted : above 1 month

Job Description:

Job Description SummaryThe Database Developer position will be responsible for the design, and development of database objects and procedural code supporting various products developed by D&A The developer will create programs to maintain data integrity in the online transaction processing and data warehouse schemas Additionally, the database developer will be responsible for creating the stored procedures, triggers, constraints and ETL (extraction, transformation and data loading) programs The position requires extensive hands-on experience developing stored procedures, ETL code and associated code in a MS-SQL Server and Windows environment

Job Description Position Description

I Department Overview

The Data & Analytics department is responsible for developing and maintaining commercial grade software products, that are in compliance and supportive of the overall architectural and product strategy Utilizing best practices within the industry, as well as the currently defined technology stack, this department is responsible for delivering high quality, highly stable, and robust applications that perform to present and future expectations

II Purpose

The Database Developer position will be responsible for the design, and development of database objects and procedural code supporting various products developed by D&A The developer will create programs to maintain data integrity in the online transaction processing and data warehouse schemas Additionally, the database developer will be responsible for creating the stored procedures, triggers, constraints and ETL (extraction, transformation and data loading) programs The position requires extensive hands-on experience developing stored procedures, ETL code and associated code in a MS-SQL Server and Windows environment

III Specific Duties, Activities, and Responsibilities

1 Understand database design principles, including normalization and aggregation, for both on-line and data warehouse schemas to support the needs of application developers

2 Design, plan, and develop programs to optimally extract, transform and load data between data sources

3 Diagnose and resolve database performance issues

4 Maintain developed source code in the repository for all databases and keep all build programs up to date

5 Responsible for overall development success (inclusive of peer/code reviews, adherence to corporate standards, build process guidelines, maintainability, unit tests) of the project

IV Position Requirements

Education or Equivalent

BS in Computer Science or Information Systems

Experience or Equivalent

13 years experience working on relational database platform with emphasis on database code development

Knowledge, Skills, and Abilities Requirements List unique knowledge, skills, or problem-solving requirements

Data modeling tools like ER/Studio or ERWin
Database design skills including normalization and data warehouse design
Strong TSQL skills
Strong SSIS skills
Strong analytical skills
Structured troubleshooting skills
SQL query performance tuning experience
Reporting tools like Qlikview, SSRS, Tableau or PowerBI
Experience in the healthcare industry, a plus
Partitions
Application Coding (C#) is a plus
Deployment Strategy

Unit Testing

Ability to communicate clearly both verbally and in writing
Ability to analyze complex application and business operational issues

Primary Work LocationIND Chandigarh - DLF IT Park

Additional Locations

Work Shift

Profile Summary:

Employment Type : Full Time
Eligibility : Any Graduate
Industry : Manufacturing/Industrial, Healthcare
Functional Area : Teaching/Education
Role : Lecturer/Professor
Salary : As per Industry Standards
Deadline : 24th Feb 2020

Key Skills:

Company Profile:

Company
BD INDIA PVT LTDarfix

Salary trends based on over 1 crore profiles

View Salaries

All rights reserved © 2018 Wisdom IT Services India Pvt. Ltd DMCA.com Protection Status