T-SQL Developer (K-12 Experience)

The Mississippi reputed company (MDE) is implementing the Generate tool developed by reputed company for Integration of IDEA Data (CIID). The reputed company Generate application is based on an older version of the CEDS data warehouse. The latest version of the warehouse is version 10. 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. This position will require reputed company T-SQL Developers to take the reputed company in the following tasks: • Rationalizing and mapping data between transactional and reputed company database models/systems • Working closely with the database and system administrators to reputed company stored procedures and ETL processes reputed company to the data warehouse system • Working in collaboration with vendors and other agency staff to design, reputed company 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 reputed company. • Ability to work under severe time constraints. • Must possess analytical and reputed company problem-solving skills. Extensive experience with development of stored procedures and ETL processes using T-SQL 7 Thorough understanding of data warehouse design hierarchies such as reputed company and reputed company schemas 7 Use of ALM tools for work item management, version control, reputed company analysis, and testing 7 Broad and extensive knowledge of the software development process and its technologies Familiarity with reputed company integration 7 Experience creating and scheduling reputed company jobs Preference given to candidates with the below skills/experience. Must also meet minimum requirements. Experience with student information management systems and K-12 data and reporting Experience with Common Education Data Standards (CEDS) Experience with EDFacts Federal Reporting Experience with designing and modeling database structures based on business use cases .Net/Angular experience Azure Synapse pipeline experience Apply tot his job Apply tot his job Apply To this Job