T-SQL Developer
T-SQL Developer
Employer Active
Job Alert
You will be updated with latest job alerts via email
Share
Job Alert
You will be updated with latest job alerts via email
Not Disclosed
Salary Not Disclosed
1 Vacancy
Job Description
W2 Only
VISA : USCL2EADH4EAD
This position is only for W2 Candidates
This position will require qualified TSQL 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 problemsolving skills.
REQUIRED SKILLS/EXPERIENCE
- Extensive experience with development of stored procedures and ETL processes using TSQL
- 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. Must also meet minimum requirements.
- Experience with student information management systems and K12 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
Employment Type
Full Time
