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.