Description

Job Description

Skills Required

Proficiency using SQL database including SSIS. Create Stored Procedure, Views, Triggers, Functions, T-SQL, Indexes, Cursors, Performance Tuning, and SQL Profiler

Including writing of complex queries using SQL Participate in the on-going development and support of existing production system, both technically and functionally

Work closely with other developers or and analysts to ensure development meets requirements and delivers optimal performance to our end users

Collaborate with Product Owner and SMEs to scope the opportunities, identify constraints, and help mitigate risks

Research and adapt technical solutions based on changing business needs. Provide technical mentoring for team members as needed

Actively look for opportunities to enhance standards and improve process efficiency

Researches, evaluates, and recommends new Internet tools and applications for use in assigned responsibilities. Ability to work independently

Develop automated tests to use for regression and unit testing. Proficiency using SQL database including SSIS

Solid written and verbal communication skills. Advanced knowledge in SSRS to develop reports

Experience Required

7 years of experience in SQL development experience

5 years of experience in Stored Procedures

SSIS ETL Packages

5 years of experience in ETL development

5 years of experience in tools for data extraction and migration5 years’ experience with extensive knowledge of Agile process development in .Net, MVS and SQL

Working hands-on with all aspects of the System Development Life Cycle Ability to document code developed by analyst

 

Education

Bachelor's degree