Full Time: Need SQL Server Developer based at Columbia, SC, United States

Hello ,

We have Full Time position available with one of our direct client .

JD:

Title: - SQL Server Developer

Duration – Full Time

Location: Columbia, SC, United States

The Database Developer is responsible for creation of SSIS packages and integration work, SSRS Reports, Data marts, Data warehouse and SSAS Cube Development.This role requires a service oriented mentality, high sense of ownership, focus on delivering the projects on time, establishing and maintaining communication with customers/PMs/Client to keep them updated with status of their projects, initiating and performing development and proactively escalating any issues that cannot be resolved within the established timeframes.

Duties and Responsibilities Technical Responsibilities

Develop and maintain a real time data warehouse environment and create real time feed to all subscriber application from Data warehouse

Experience on Type 2 Dimension Data modeling and Historical ETL

Develop and support SQL server database objects and code for BAU Support.

Develop and support SSIS integration jobs required to manage integration between application databases and the corporate data warehouse, including

XML/CSV/Excel integration

Business & Technical Reconciliations

Develop and support SSAS Cubes and related processing tasks.

Develop and support SSRS reports (deployed on SharePoint).

Provide and maintain documentation for all developed objects and processes.

Use TFS to track all end to end changes and artifacts

Follow strict change control process throughout development lifecycle

Develop and run test scripts to ensure the quality of code and integrity

Testing against acceptance criteria for requirements

Following data / integration design patterns and architecture as prescribed by the Lead and/or Architect

Following Enstar policy, procedures, controls and processes for the development and testing life-cycle

Qualifications

Four to six years working as a productive member of a Database team supporting MSBI initiatives

Good task management and organizational skills

Willingness to take responsibility and ownership for tasks and issues

Ability to follow through on the analysis, communication and resolution of issues and problems

Willingness and ability to provide and maintain high quality documentation to strict deadlines

Ability to facilitate decision making and collaboration necessary for key data architecture issues

Ability to work both independently and collaboratively with various teams (BA/Architects/Support/Business) while working on data quality issues

Good communication and documentation skills

Good presentation skills