SQL – Senior Programmer or Lead SQL

 Job Description

Responsibilities:

       Work with business users and IT analysts to identify changes or improvements need to business processes

       Transform functional requirements into technical specifications

       Plan, design, develop, test, and implement code to address business requirements

       Develop and support data interfaces between internal and external systems using web services.

       Work on ETL processes

       Create test cases and perform unit, system, and integration testing

       Identify, troubleshoot and debug defects in designated application code

       Perform root cause analysis and problem resolution

       Write SQL code to implement complex queries

       Provide level 2 and level 3 support for tickets requiring technical resolution

       Identify potential areas where existing business processes require change, or where new processes need to be developed, and make recommendations in these areas

       Maintain coding standards and design documentations

 Qualifications:

       Bachelor’s Degree in Computer Science or MIS or equivalent experience in related roles

       3+ years of experience in C#

       Proficient in working with APIs and Web Services

       4+ years of experience writing complex MS SQL, procedures, functions etc.

       Experience with Extract, transform and load (ETL) process using SSIS is required

       Knowledge of .NET framework is required

       Experience with SSRS is a plus

       Experience supporting a DW is a plus

       Experience with SDLC (software development lifecycle) processes

       Experience with integrating back office applications

       Ability to work with a minimal amount of direction while being proactive in keeping their management informed of project related issues

       Ability to manage multiple projects at the same time and shift priorities quickly

       Proven strong problem-solving skills, troubleshooting, and root cause analysis

       Strong aspiration to learn new technologies

       Excellent communication skills (verbal and written)