Report this Job
Title: SQL Server ETL
Location: Remote
Length: Long term
Restriction: W2 or C2C
Description:
Very long term project initial PO for 1 year but expected to go for multiple years *** Webcam interview*** Need 3 verifiable references ***Remote***
This position will require a qualified SQL DBA 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:
Extensive experience with development of stored procedures and ETL processes using T-SQL 7 Years
Thorough understanding of data warehouse design hierarchies such as star and snowflake schemas 7 Years
mapping, modeling
Use of ALM tools for work item management, version control, code analysis, and testing 7 Years
Broad and extensive knowledge of the software development process and its technologies
Familiarity with continuous integration 7 Years
Experience creating and scheduling elastic jobs 5 Years
One or more of the following:
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
(link removed) Angular experience
Azure Synapse pipeline experience
msysinc
