ETL (Extract Transform Load) Developer - Classified

Essential Functions (ADAAA) LIGHT/Office environment: Required to sit, view a computer screen, and utilize a keyboard and mouse for extended periods of time. May be required to lift and move up to 10 lbs of force frequently or 20 lbs occasionally. Required lifting, bending, stooping, pushing, walking, etc.

Light work usually requires walking or standing to a significant degree. DL Not Required : Required to independently obtain and determine means to complete travel requirements.

Position Summary: Turn data into impact at CDE. Join our Data Warehouse team to build and enhance Informatica ETL solutions that power critical reporting and help support education across Colorado. The Information Management Services (IMS) unit provides technology, systems and information to help fulfill the goals of CDE.

IMS supports CDE and Colorado School Districts through five teams: Network/Help Desk; Applications Development; Data Services, Project Management, and Data Warehouse. This position will be within the Data Warehouse team. This position develops, maintains, and enhances Informatica Extract, Load, and Transform (ETL) processes to load data from the Operational Data Store (ODS) and external data sources to the Data Warehouse.

It also develops, maintains, and enhances Informatica ETL processes for Data Marts and file creation for federal reporting. It must follow the Software Development Life Cycle (SLDC) process. This position may perform Informatica Administration functions, including software installation, tuning, defining best practices, and troubleshooting and resolution.

This position may also require primary contact with the tool vendor or third-party vendors. This position consults directly with business users, business analysts, and decision-makers to gather and document requirements and define scope. This position may require developing or assisting "data models" to help define project scope and requirements.

This position assists with project plans, facilitates meetings, and assists with estimating and planning project deliverables and dependencies. This position attends planning sessions with internal customers to review upcoming enhancement requests and requirements for existing ETL processes and reports. This position as necessary, research background of requested enhancements to understand legislative requirements or educational practices driving the requests.

Major Duties and

Responsibilities: Developing Extract, Transform, Load Processes: Develop, maintain, and enhance Informatica Extract, Load, and Transform (ETL) processes to load data from the Operational Data Store (ODS), Assessment collections, and external data sources to the Data Warehouse Develop, maintain, and enhance Informatica ETL processes for Data Marts and file creation for federal reporting.

In all the above, the Software Development Life Cycle (SDLC) process must be followed. Must know how the SDLC works. Gather functional requirements; develop detailed requirements; review the functional and detailed requirements with business users/owners; obtain signoff on requirements; develop software and unit test; migrate software to QA and get the business users/owners to test and approve; migrate approved software to production and set up runbooks and schedules.

Utilize and develop best practices. Gathering

Requirements: Consult directly with business users, business analysts and decision-makers to gather and document requirements and define scope. This may require developing or assisting with "data models" to help define project scope and requirements. Assists with project plans and facilitates meetings.

Assist with estimating and planning project deliverables and dependencies. Attend planning sessions with internal customers to review upcoming requested enhancements and requirements to existing ETL processes and reports. As necessary, research the background of requested enhancements to understand legislative requirements or educational practices driving the requests.

Documentation: Keep existing documentation up to date with changes and modifications applied. Create new detailed documentation for new solutions and reports. This would include adding documentation to related Informatica objects (mappings, workflows, etc.), comments in SQL code, updates to requirements and design documents (process, workflow, and data model documents).

Conducting Training: Coordinate and conduct training and testing for business analysts and other end-users.

Minimum Qualifications, Substitutions, Conditions of Employment & Appeal Rights MINIMUM EDUCATION AND EXPERIENCE

REQUIREMENTS: This position requires three (3) years of experience, OR A combination of education and experience totaling three (3) years. Experience Only: Three (3) years of relevant professional experience in data integration (SSIS), data warehouse management, or database administration. Relevant experience includes work that included systems, processes, and knowledge as described below: Experience in Data integration with systems like Informatica, SSIS, or other ETL tools.

Experience in data warehouse management that included dimensional data modeling, index mgt, etc Experience with Informatica IDMC / Informatica Cloud or PowerCenter with 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. OR Education and Experience Combination: A combination of related education (e.g., computer science disciplines), a formalized apprenticeship program, certification, and/or relevant experience in an occupation related to the assigned work is equivalent to one (1) year of education and at least two (2) years of experience as described below as "Relevant Experience".

Relevant experience includes work that included systems, processes, and knowledge as described below: Experience in Data integration with systems like Informatica, SSIS, or other ETL tools. Experience in data warehouse management that included dimensional data modeling, index mgt, etc Experience with Informatica IDMC / Informatica Cloud or PowerCenter with 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. _______________________________________________________________________________________________________________ QUALIFICATIONS AND CONDITIONS : Qualifications for Success in the Position: High level of proficiency with the Software Development Life Cycle (SDLC) process.

At least two (2) years of development experience as an Informatica developer, including requirements gathering, data mapping, developing new mappings, transformations, and workflows. Experience with UNIX/LINUX scripting. Strong written and verbal communication skills.

Strong attention to detail. Ability to effectively balance quality of work and productivity expectations. Ability to effectively collaborate with internal and external customers (i.e. school districts, other CDE units, etc.).

Ability to prioritize and organize work to accommodate and meet the changing needs of the department and meet deadlines. Takes initiative and exhibits a proactive approach to work. Identifies problems and recommends solutions prior to the standard being jeopardized.

Ability to work independently, as well as on a team. Exhibits CDE's mission, vision and values by the consistent expression of professional, respectful, and customer service. oriented behaviors.

Preferred Qualifications (Preferred/Not Required): High level of proficiency with relational databases, such as Oracle, and data warehouse concepts. Three (3) Years Hands-on experience data modeling and data warehouse design. Three (3) Years Hands-on experience Informatica PowerCenter and IDMC developer.

Conditions of Employment (Required): Must be willing and able to submit to the pre-screening process and pass a background check. Ability and willingness to independently determine, obtain means, and complete required traveling/commuting. Work extended schedule per busin ess needs.

Report to work location per business needs. DL Not Required: Required to independently determine and obtain means to complete travel requirements. Sign the acknowledgment form that this position is funded through state funds and is subject to availability.

Supplemental Information Complete Applications must include : Completed Online Application: Required - Submitted through our ATS . Resume: Required - Copy and Paste into the Supplemental Questions (11,000 character limit, aprx. 3 pages) Resume Required - Attached as a separate document.

Transcript: Required if using education to meet MQs - Attached to the online application and meeting requirements as described under "College Transcripts". College Transcripts: If you are using education to qualify, a legible copy of your official or unofficial college transcript(s) or a foreign credential evaluation report must be submitted with your application.

Transcripts must show the name of the school and that a degree was conferred. Transcripts from colleges or universities outside of the United States must be assessed for U.S. equivalency by a NACES educational credential evaluation service. Failure to provide a transcript or foreign credential evaluation report may result in your application being rejected and you will not be able to continue in the selection process for this position. ** Failure to submit a complete application as defined above by the announcement close will result in your application being removed from consideration.* * ** Resumes and Cover Letters WILL NOT be reviewed for minimum qualification screening.

FOR CURRENT OR FORMER EMPLOYEES OF THE STATE OF COLORADO: Per the requirements of the Step Pay Program implemented on July 1, 2024, any State employee must be paid a rate that is equal to or greater than the appropriate step pay rate within their classification's pay range based on completed years in their current class series as of June 30.

All current and former State employees must ensure that your entire work history within the State Classified System, including at Institutions of Higher Education, is indicated in your application so that your time-in-series can be calculated accurately. Email Address: All correspondence regarding your status in the selection/examination process will be conducted via email.

Include a working email address on your application; one that is checked often as time-sensitive correspondence such as exam information or notification will take place via email. Please set up your e-mail to accept messages from "state.co.us" and "info@governmentjobs.com" addresses. It is your responsibility to ensure that your email will accept these notices and/or review your junk mail and spam-filtered email.

Appeal Rights: If you receive notice that you have been eliminated from consideration for the position, you may protest the action by filing an appeal with the State Personnel Board/State Personnel Director within 10 days from the date you receive notice of the elimination. Also, if you wish to challenge the selection and comparative analysis process, you may file an appeal with the State Personnel Board/State Personnel Director within 10 days from the receipt of notice or knowledge of the action you are challenging.

Refer to Chapters 4 and 8 of the State Personnel Board Rules and Personnel Director's Administrative Procedures, 4 CCR 801, for more information about the appeals process. The State Personnel Board Rules and Personnel Director's Administrative Procedures are available at www.colorado.gov/spb . A standard appeal form is available at: https://spb.colorado.gov/ .

If you appeal, your appeal must be submitted in writing on the official appeal form, signed by you or your representative, and received at the following address within 10 days of your receipt of notice or kno