Position Description:- 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
Education Required:| Minimum Education Level: BA