T-SQL Developer

Hi

 

We have an immediate requirement with our direct client

 

 

Please fill the details below asap and send me

 

Please attach your latest word resume ,DL copy and Visa copy

 

 

Basic Details

Full Name:

Contact Number:

Email:

Visa Status:

Current Location:

Relocation:

Last 5 Digits of SSN:

Availability to join:          

Availability for In-person interview:

Best time to reach:

Employer details :

 

Three (3) references of submitted candidates required. Please provide the following information. Must submit with resume.

•           First/last name of reference:

•           Title:

•           Company Name:

•           Job title of contractor while reporting to this supervisor/manager:

•           Telephone number:

•           Email Address (if available):

 

 

Title: Developer – T-SQL Developer – SME – MS – MDEK12

Posting ID: 135469

Project End Date: 02/28/2026

State: Mississippi

Worksite: Remote

 

 

PROJECT NAME: OTSS

PROJECT DETAILS The Mississippi Department of Education (MDE) is implementing the Generate tool developed by the Center for Integration of IDEA Data (CIID).

 

The current 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. 

 

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.

 

REQUIRED SKILLS/EXPERIENCE # YEARS

 

  • Extensive experience with development of stored procedures and ETL processes using T-SQL 7
  • Thorough understanding of data warehouse design hierarchies such as star and snowflake schemas 7
  • Use of ALM tools for work item management, version control, code analysis, and testing 7
  • Broad and extensive knowledge of the software development process and its technologies 7 
  • Familiarity with continuous integration 7
  • Experience creating and scheduling elastic jobs 5

 

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

 

 

 
 

 

Thanks and Regards

__________________________________________________________

Vijaya

Real World Technologies Inc  | 29105 Lorie Lane, Suite A | Wixom, Michigan 48393

OFFICE: 248-516-7335 | FAX: 248-779-1789  [email protected] | http://www.rwts.net

0 0 votes
Article Rating
Subscribe
Notify of
guest
0 Comments
Most Voted
Newest Oldest
Inline Feedbacks
View all comments