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
Bachelor's degree