Job Description :
Requisition ID                                                  6xb1401-0001Created On                                                      12/21/20203:13 PM ESTDate/Time Posted                                                                                      12/22/202012:27 PM ESTRequisition Name                                              DataBase Programmer/AnalystFolder                                                                                                                          CDE-IMSCustomer                                                                                                                COCDEQuantity Requested                                                                                1Submission Deadline                                                                            12/23/2020Estimated Duration                                                                                  2/28/2020- 06/30/2021Location                                                                                                                                                                                              201E Colfax AveDenver, Colorado 80203-0000
    Location Requirements Candidate must be local or willing to commute or relocatenbsp; No Additional details: Able to work remotely from any location during COVIDnbsp; Post-COVID may do some work from the 201 E. Colfax location as needed.   The Colorado Department of Education (CDE) is contracting for Department") is seeking an on-site, qualified Extract-Translate-Load (ETL) programmer/developer well versed in Informatica for Information Management System''s development teams. This is a staff augmentation to develop, maintain, and enhance ETL processes to load data from the Operational Data Store (ODS) and external data sources to the Data Warehousenbsp;   Develop, maintain, and enhance Informatica ETL processes for Data Marts and file creation for federal reporting   This engagement includes administering Informatica Administration functions, including software installation, tuning, defining best practices and trouble shooting and resolution.   This position also may require contact with tool vendor or third-party vendors.   In addition, this work may involve additional work associated with the staging of data for Tableau and Cognos reporting purposes. This initiative is critical for IMS support of CDE Informatica, Tableau and Cognos reporting. We need a data warehousing expert that, can quickly ramp up on the CDE environment, understands the work needed, can do the work, and can communicate to others how to do the work. We need explanations and documentation throughout This includes any supporting tools, hardware and software configurations using best practices in all areas. The contractor will be performing backfill services for the SLDS grant which is an allowable use of grant fundsnbsp; This is necessary so CDE permanent staff are available to work on grant activities, to reduce the need for contractor-to-staff knowledge transfer in the future.   Description  ·                Consultswith users to identify current operating procedures and clarify programobjectives. ·                Developsdatabase from project specifications and statement of problem and procedures tocreate or modify computer data base programs applying knowledge of programmingtechniques and computer systems. ·                Plan, coordinate, and implement security measures to safeguard computer databases. ·                Knowledgeand Skill sets include Oracle, DB2, Sybase, ADABAS, SQL Server, Informix, Linux, and decision support systems such as COGNOS, and BOA. ·                Coordinatechanges to computer databases, test and implement the database applyingknowledge of database management systems. ·                Preparesor receives from Data Base Analyst flowcharts and diagrams to illustratesequence of steps program must follow and to describe logical operationsinvolved.