] Office of Human Resources - Montgomery County Public Schools

OFFICE OF HUMAN RESOURCES AND DEVELOPMENT → CLASSIFICATION → EXTRACTION TRANSFORMATION & LOAD (ETL) ANALYST PROGRAMMER

Sorted by job title: A - C | D - H | I - Q | R - Z

Extraction Transformation & Load (ETL) Analyst Programmer

MONTGOMERY COUNTY PUBLIC SCHOOLS CLASS DESCRIPTION
OFFICIAL TITLE: ETL Analyst/Programmer CODE: 5201 SQ/OQ: Optimal Qualified
WORKING TITLE: Extraction Transformation & Load (ETL) Analyst Programmer GRADE: 25 MONTHS: 12
SUMMARY DESCRIPTION OF CLASSIFICATION: 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. Translates requirements into detailed specifications, and develops and documents business processes and data requirements. 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.
MINIMUM QUALIFICATION STANDARDS
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.
CERTIFICATE AND LICENSE REQUIREMENTS: None
PHYSICAL DEMANDS: (Special requirements such as lifting heavy objects and frequent climbing.) Must operate computer work stations for sustained periods, lift and move PC equipment.
SPECIAL REQUIREMENTS: (Frequent overtime or night work required, etc.) Some overtime, evening and weekend work required.
OVERTIME ELIGIBLE: No

EXAMPLES OF DUTIES AND RESPONSIBILITIES:

1. Works closely with project management and data warehouse team.

2. Serves as liaison to other development teams to ensure corporate standards and architecture vision is realized.

3. Documents requirements consistent with work products and deliverables defined by project management.

4. Translates requirements into detailed specifications.

5. Prepares accurate task estimates and ensures timely delivery.

6. Prepares test strategies, test scripts, and conducts system tests.

7. Designs, programs, sequences, and maintains ETL processes.

8. Monitors and troubleshoots ETL production jobs.

9. Participates in requirements and design of data warehouse architecture.

10. Develops and maintains load programs, metadata repositories, user programs in the latest database version.

11. Size, develop, test, implement, and maintain code in the appropriate database programming language.

12. Day-to-day support for the Business Intelligence/Data Warehouse System.

13. Fully test and document all development work.

14. Performs related duties as required.
Class Established: 2/2001
Date(s) Revised: 7/06
Last Reviewed:

This description may be changed at any time.