Don't worry, we can still help! Below, please find related information to help you with your job search.
Job Title:
Company | CAT Software Services |
Address | Mississippi, United States |
Employment type | CONTRACTOR |
Salary | |
Expires | 2023-07-24 |
Posted at | 11 months ago |
Job Title: T-SQL Developer
Location: 100% Remote
Duration: 12+ Months Contract
PROJECT DETAILS
Client 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 (Common Education Data Standards) 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 (ED Facts 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- 7 Years
Extensive experience with development of stored procedures and ETL processes using T-SQL
Thorough understanding of data warehouse design hierarchies such as star and snowflake schemas
Use of ALM tools for work item management, version control, code analysis, and testing
Broad and extensive knowledge of the software development process and its technologies
Familiarity with continuous integration
Experience creating and scheduling elastic jobs
Preference given to candidates with the below skills/experience beyond minimum requirements:
Experience with student information management systems and K-12 data and reporting
Experience with Common Education Data Standards (CEDS)
Experience with ED Facts Federal Reporting
Experience with designing and modeling database structures based on business use cases
.NET/Angular experience
Azure Synapse pipeline experience
Best Regards,
Sridhar | IT Recruiter
CAT Software Services INC.
Direct number : 8483000245
Email : [email protected]
-
Systems Analyst - Excel, Xml, Sql, Scripting
By CyberCoders At Salt Lake City, UT, United States 8 months ago
-
(Senior) Finance & Shared Services Manager
By Catholics For Choice At Washington, DC, United States 8 months ago
-
Paralegal - Probate Administration
By CyberCoders At Miami, FL, United States 8 months ago
-
Account Executive - Automotive Software
By ECW Search At United States 8 months ago
-
Construction Project Coordinator Jobs
By CyberCoders At River Falls, WI, United States 8 months ago