| T-SQL Developer at Remote, Remote, USA |
| Email: [email protected] |
| Posting ID: 135469 Position: Developer - T-SQL Developer - SME Location: Remote Duration: 2 Years PROJECT DETAILS: The Mississippi Department of Education (MDE) is implementing the Generate tool developed by the Center for Integration of IDEA Data (CIID). https://ciidta.communities.ed.gov/#program/generate The current Generate application is based on an older version of the CEDS data warehouse. The latest version of the warehouse is version 10. https://github.com/CEDStandards/CEDS-Data-Warehouse This project includes updating the Generate data model to utilize version 10 of the CEDS data warehouse and the update ETL processes that generate federal reports (EDFacts files) using the data model. JOB DESCRIPTION: This position will require qualified T-SQL Developers to take the lead in the following tasks: Rationalizing and mapping data between transactional and dimensional database models/systems Working closely with the database and system administrators to develop stored procedures and ETL processes related to the data warehouse system Working in collaboration with vendors and other agency staff to design, develop and manage the creation of federally required reports using the Generate application Translate application storyboards and use cases into functional applications Ability to work independently and cooperatively as part of a team. Ability to work under severe time constraints. Must possess analytical and complex problem-solving skills. Extensive experience with development of stored procedures and ETL processes using T-SQL - 10 Years Thorough understanding of data warehouse design hierarchies such as star and snowflake schemas - 10 Years Use of ALM tools for work item management, version control, code analysis, and testing - 10 Years Broad and extensive knowledge of the software development process and its technologies - 10 Years Familiarity with continuous integration - 10 Years Experience creating and scheduling elastic jobs - 10 Years -- Keywords: information technology Idaho T-SQL Developer [email protected] |
| [email protected] View all |
| Wed Oct 02 00:19:00 UTC 2024 |