US Citizen
Green Card
EAD (OPT/CPT/GC/H4)
H1B Work Permit
Corp-Corp
W2-Permanent
W2-Contract
Contract to Hire
Consulting/Contract
UG :- - Not Required
PG :- - Not Required
No of position :- ( 1 )
Post :- 18th Mar 2024
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.
• Bachelor’s degree
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