Need Informatica with Cognos Consultant

Thorough knowledge of COGNOS report development.

Develop mappings for data extraction transformation and load to the data warehouse. Identifies, designs, codes, debugs tasks necessary to develop Data Warehouse/Mart and ETL BI solutions.

Experience with Informatica PowerCenter version 9.6 and 10.1. Experience with Data Quality. Develops database triggers and SQL queries needed inside the ETL Informatica.

Scope of Work

The Application Systems Architect II shall be contracted to work on the following

ETL processes

• Assist with Accountability Aggregation Table work (Agg Tables)
• Update and automate the SchoolView Data Center processes
• Some requirements analysis
• Some recommendation regarding what should be kept and what should be eliminated
• Assist Informatica and LINK upgrades
• Update and automate the Educator Effectiveness
• Assist with upcoming school year changes
• Automate some if not all of the EdFacts processes
• Update and automate CEDAR processes
• Some requirements analysis
• Some recommendation regarding what should be kept and what should be eliminated
• Additional ETL processes that need attention that have not been identified at this time

All work will be performed at the Colorado Department of Education 201 E. Colfax Denver, CO 80203 and remotely as approved by the CDE CIO & Data Warehouse Manager.

Applicant Qualifications/Key Assumptions

• Applicant shall be an Application Systems Architect II
• Will be required to pass a background check.
• 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 Informatica
• Strong oral and written communication skills working with both business users and technical staff
• Ability to multi-task
• Ability to prioritize their work / tasks and adjust as necessary
• COGNOS report development skills
• Must demonstrate experience in working with a broad cross-section of stakeholders.
• Must have a complete understanding of project SDLC (including agile) development methodologies and formal project delivery methodologies.