Possess strong SQL skills and implements best practices.
Reviews coded and compiled structured programs.
Prepares test data and conducts unit testing to ensure compliance to specifications.
Analyzes automation requests.
Creates work plans, develops schedules, and develops time and cost estimates for projects.
Creates all required SDM technical documents: Technical Specs, Design docs, etc.
As an active team member, interfaces with users to gain the understanding necessary for enhancements, maintenance, and problem resolution for existing applications; and maintains continuous awareness of users' plans/activities relevant to the project.
Translates requirements and specs into computer programs; designs, codes, analyzes, tests, and documents computer software programs and systems using full life cycle development techniques.
Prepares routine periodic project status reports and communicates with customers, as needed.
Attends staff and technical meetings for the work unit
Skills Required:
Expert SQL Server, Advanced SSIS, Expert TSQL both DML and DDL, SQL Optimization.
Has the ability to receive a request from the business and translate that into a query/ad hoc report independently.
Has the ability to review table structures and understand the database
Has the ability to review existing stored procedures and SSIS packages to understand processes.
Experience Required:
8 years+ of SQL development.
Agile Experience, Dev Ops, SSMS, SSIS packages, C# Scripting Tasks Scoping and writing user stories