Extraction Transformation - Rockville, United States - Montgomery County Public Schools
Description
Extraction Transformation & Load (ETL) Analyst Programmer - Dept of Students and Data Systems, 8hrs/12mo, Ad Closes 4/29/24
MCPS Official Job Description
SUMMARY DESCRIPTION:
Works closely with project management and data warehouse development teams, creates and maintains multi-dimensional data models defining the data warehouse Extraction Transformation and Load (ETL) architecture, designs and codes ETL processes, administers change controls and processes, and monitors production data loads.
Monitors ETL performance tuning production data loads, controls ETL tool releases, conducts system and acceptance testing, provides production support, implements interfaces to source systems, and balances target to source data.
CERTIFICATE LICENSE:
None
KNOWLEDGE, SKILLS, and ABILITIES:
Strong technical, analytic, and problem-solving skills including: dimensional data modeling, structured batch programming, proficiency in database principles, the appropriate database platforms as they relate to database operations, software change control and data warehouse data load integrity and validation procedures.
Ability to tune ETL performance, to work independently and cooperatively within a team working under severe time constraints, and to develop and implement a test plan.
Requires skill in completing program and system documentation, good oral and written communication skills, and excellent time management skills. Knowledge of and the ability to meet the seven core competencies of the Supporting Services Professional Growth System (SSPGS).EDUCATION, TRAINING, and EXPERIENCE:
Bachelors degree required. Masters degree preferred.
Experience in designing, programming, maintaining and tuning ETL processes; in monitoring and troubleshooting ETL production jobs; and in creation of system requirements and test plans; familiarity with database warehouse architecture and performance issues in a large database system; with database programming tools, SQL, data modeling tools, and database access tools; excellent communication skills, and ability to learn business practices and concepts required.
Other combinations of applicable education, training, and experience which provide the knowledge, abilities, and skills necessary to perform effectively in the position may be considered.
Job:
Information Technology
Job Grade: 25 Optimal Qualified
Organization:
Offices
Primary Location:
Rockville
Schedule:
Full-time | hours bi-weekly)
Working Months: 12
Shift:
Day Job
Job Posting:
Apr 15, 2024, 8:32:15 AM - Apr 29, 2024, 10:59:00 PM
More jobs from Montgomery County Public Schools
-
Fy25: (Spanish Facilitator) Grade 4 Teacher
Gaithersburg, United States - 3 days ago
-
Fy25: Teacher, Art, Rosemont Elementary School, 1.0
Gaithersburg, United States - 3 days ago
-
FY25: Speech Pathologist, Potomac ES, 0.3 FTE
Potomac, United States - 2 weeks ago
-
FY25: Speech Pathologist, Jones Lane ES, 0.5 FTE
Gaithersburg, United States - 2 weeks ago
-
Fy25: Cafeteria Worker I 10 Mo, 3-hour, Robert
Rockville, United States - 2 days ago
-
All In Tutors
Christiansburg, United States - 1 week ago