Short Description:
This resource will analyze, design, develop and test code enhancements, and/or required fixes to meet the proposed requirements for the PIMS Data Collection Consolidation project.
Complete Description:
Job Description: The SQL programmer will work with the business analyst to design SQL for reports. The programmer will develop and test the SQL based upon test criteria provided by the BA. The programmer will provide tested SQL packages to the BA for further testing. The SQL programmer will ensure that all report specifications are fully documented. The BA will perform additional testing and evaluate the accuracy of the final report. The SQL programmer will work with the BA to resolve issues.
Skills:
Skill
Required / Desired
Amount
of Experience
Experience writing SQL queries
Required
5
Years
Database design and modeling expertise in SQL Server 2000/2005/2008
Required
5
Years
Design and coding skills for report design warehousing using SQL Server Analysis Services tools
Required
5
Years
Visual SourceSafe for source code version and control
Required
5
Years
Experience with developing SQL code and stored procedures
Required
5
Years
Create and use reusable software components where possible
Required
5
Years
Experience with System Testing
Required
5
Years
Create content for operational documentation
Required
5
Years
Research problems independently and participate in ongoing process improvement.
Required
5
Years
Provide estimates for change requests
Required
5
Years
Ability to use Access and Excel for data analysis
Required
5
Years
Understanding of Cognos Reports
Required
5
Years
Experience and knowledge in supporting application system development life cycle.
Required
5
Years
Communicate accurate and useful status updates.
Required
Ability to follow quality standards
Required
Ability to work independently as well as a team environment
Required
Strong communication skills; both written and spoken
Required
Experience using MS Office
Required
5
Years