ETL (Extract Transform Load) Developer - Classified

State of Colorado • Denver, CO

7d • Hybrid

About The Position

The Colorado Department of Education (CDE) is hiring an ETL Developer for its Information Management Services (IMS) Data Warehouse team. The position is open only to current Colorado residents, and work for CDE must be completed within Colorado. The role is full-time, supported by state funds subject to funding availability, and eligible for a hybrid work environment. A remote home office is required, and reporting to CDE buildings may be required based on business needs.

The position develops, maintains, and enhances Informatica ETL processes that load data from the Operational Data Store, assessment collections, and external sources into the Data Warehouse. It also supports ETL processes for Data Marts and file creation for federal reporting. The work follows the Software Development Life Cycle (SDLC), from requirements gathering and review through development, testing, migration, production deployment, and documentation of runbooks and schedules. The role may include Informatica administration, software installation and tuning, best-practice development, troubleshooting, and contact with tool or third-party vendors.

The ETL Developer consults with business users, analysts, and decision-makers to gather and document requirements, define scope, and help develop data models. The position assists with project plans, estimates, dependencies, and meetings; reviews enhancement requests; and may research legislative or educational context behind requests. It maintains and creates technical documentation and coordinates or conducts training and testing for business analysts and end users.

Requirements

• Three years of relevant professional experience in data integration, data warehouse management, or database administration, or a qualifying combination of education and experience totaling three years.
• Experience with data integration systems such as Informatica, SSIS, or other ETL tools.
• Experience in data warehouse management, including dimensional data modeling and index management.
• Experience with Informatica IDMC/Informatica Cloud or PowerCenter, including migration exposure.
• Experience supporting or administering Informatica environments.
• Strong SQL skills with Oracle databases.
• Experience working with stored procedures and database-driven logic.
• Experience supporting ETL testing, validation, and issue resolution.
• High proficiency with the SDLC process.
• At least two years of Informatica developer experience, including requirements gathering, data mapping, and developing mappings, transformations, and workflows.
• Experience with UNIX/Linux scripting.
• Strong written and verbal communication skills and attention to detail.
• Ability to balance work quality with productivity expectations; collaborate with internal and external customers; prioritize and organize work to meet changing needs and deadlines; take initiative; identify problems and recommend solutions; and work independently and as part of a team.
• Professional, respectful, customer-service-oriented conduct consistent with CDE's mission, vision, and values.
• Must be a current Colorado resident and complete work for CDE within Colorado.
• Must be willing and able to complete the required pre-screening process and pass a background check.
• Must be able to independently determine and obtain the means to complete required travel or commuting.
• Must work an extended schedule as business needs require and report to the work location as required.
• Must sign an acknowledgment that the position is funded through state funds and is subject to funding availability.
• Applicants must be legally authorized to work in the United States without employer-sponsored visa assistance.

Nice To Haves

• High proficiency with relational databases such as Oracle and with data warehouse concepts.
• Three years of hands-on experience in data modeling and data warehouse design.
• Three years of hands-on experience as an Informatica PowerCenter and IDMC developer.

Responsibilities

• Develop, maintain, and enhance Informatica ETL processes that load data from the Operational Data Store, assessment collections, and external data sources into the Data Warehouse.
• Develop, maintain, and enhance Informatica ETL processes for Data Marts and for creating files used in federal reporting.
• Follow the SDLC, including gathering and detailing requirements, reviewing and obtaining approval of requirements, developing and unit testing software, supporting QA testing, migrating approved software to production, and establishing runbooks and schedules.
• Use and develop best practices for ETL development and related work.
• Consult with business users, business analysts, and decision-makers to gather and document requirements and define project scope.
• Develop or assist with data models to help define project scope and requirements.
• Assist with project plans, facilitate meetings, and help estimate and plan deliverables and dependencies.
• Attend planning sessions with internal customers to review enhancement requests and requirements for existing ETL processes and reports.
• Research legislative requirements or educational practices relevant to requested enhancements when needed.
• Keep existing documentation current and create detailed documentation for new solutions and reports, including Informatica object documentation, SQL comments, requirements, and design documents.
• Coordinate and conduct training and testing for business analysts and other end users.
• May perform Informatica administration, including software installation, tuning, defining best practices, troubleshooting, and resolution.
• May serve as a primary contact for the Informatica tool vendor or third-party vendors.

Benefits

• Flexible work schedules and flexible workplace options, which may include flexible hours, working from home, working in the office, or a hybrid environment.
• Medical, dental, vision, and dependent life insurance options with employer contributions.
• Employer-paid short-term disability and life insurance.
• Up to 160 hours of Paid Family Medical Leave.
• 11 paid holidays per year.
• Vacation and sick leave accruals.
• Retirement through the Public Employees Retirement Association (PERA).
• Employer-paid RTD Eco Pass, subject to restrictions.
• Paid professional development opportunities.

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level
• Education Level: No Education Listed