Vacancy expired!
Title : Data Base Programmer/Analyst-23-10003-ETLLocation : 80203,Denver,CODuration : 3 + MonthsJob Type : CDescription : This statement of work is to engage a contractor for this partnership. Included in the daily work but not limited to, is maintaining the existing Oracle Data Warehouse environment and ETL development. The contractor will need experience in Informatica and SQL. This involves using Informatica and SQL to load tables and generate files for federal reporting. In addition, this individual may be requested to provide recommendations, documentation, and knowledge transfer to the CDE staff. With this partnership the need for knowledge transfer should happen in the normal course of work between the DW team and the contractor. Database Programmer, applicants can expect to work remotely.The Contractor shall provide documentation to the Project Manager. This documentation must provide details on the work provided and at a level a Department employee can use the information to support the work at the end of the contract.1.5 The Contractor shall submit detailed status reports or participate in weekly status meetings as required by the Department during the engagement.1.6 The Contractor shall attend required meetings with the required project stakeholders as directed by the Department. These meetings will be scheduled by a Department employee. All questions and communication should go through the Project Manager, Kevin Smith. If Kevin is not available, he will designate a Department employee for the communication.1.7 Contractor shall retain all work papers generated for reference through the duration of the project and project acceptance.1.8 Contractor shall respond to all telephone calls, voicemail, and e-mail inquiries from the Department within one business day.Skills : Informatica Skills Strong development skills: ability to develop very difficult or complicated transformation from scratch Strong administrative skills including repository management and knowledge of best practices regarding Informatica3.3. Strong oral and written communication skills working with both business users and technical staff3.4. The contractor shall demonstrate their understanding of the overall project goals and the specific goals as pertains to the contractor’s assignment for this project to the satisfaction of the Project Manager.3.5. The contractor be able to advise and provide guidance on the requested work.3.6. The contractor shall develop, maintain, and support Extract Transform and Load processes which are written using Informatica and SQL.3.7. The contractor shall use Informatica and SQL to load the Data Warehouse tables and generate Ed Facts files for federal reporting.3.8. The contractor shall thoroughly test and document each step taken and perform knowledge transfer to the staff SkillsYears of ExpLast UsedETL Informatica Oracle Data Warehouse SQL
- ID: #49060230
-
State: Colorado
Denver
80201
Denver
USA
- City: Denver
- Salary: Depends on Experience
- Job type: Contract
- Showed: 2023-02-07
- Deadline: 2023-04-04
- Category: Et cetera