Cognos Developer

DirectClient: Texas Health and Human Services Commission(HHSC)
Solicitation#529501164R
Title: Informatica/Cognos Developer
Location: 1609 Centre Creek Drive, Austin, TX 78613
Duration: Until 8/31/2025 with possible extension
Last date for submission: September 29, 2024 (2.00 PM-CST)

Important Note: Position will be remote. Candidates must relocate to Texas before the start date.

DESCRIPTION OF SERVICES:
As part of HHSC IT Applications Social Services Applications initiatives, the worker will perform the following activities to accomplish the following goals:
Performs advanced metrics and reporting development in Informatica and Cognos, and performance monitoring & tuning for TIERS DataMart. Work involves providing for the effective and efficient storage, retrieval, customization, and archiving of data by managing diverse data sets and to ensure integrated and stable database systems.
Supports and performs the planning, design, administration, operation and maintenance of the TIERS DataMart database. Performs database design & development and provides database related support to the application development teams that are performing application enhancements planned to support new program & business requests and to enhance Scalability & Stability of the applications. Provides technical expertise for data retrieval and update programs. Writes and debugs complex reports in Informatica and Cognos. Plans, develops, and implements database policies and procedures; and ensures data integrity as maintenance and modification projects to existing applications are undertaken. Participates in the development of and enforces programming standards for programs interfacing with the databases. Provides technical assistance to programming personnel.
Configures and monitors alerts. Develops and implements appropriate monitoring tools. Plans for future data needs ensuring that needed capacity is available. Develops policies and procedures to ensure consistent implementation of database and programming best practices. Contributes to development of budgets and recommendations for future upgrades. Contributes to improving and creating database application processes and procedures

CANDIDATE SKILLS AND QUALIFICATIONS
Minimum Requirements:
Years Required/Preferred Experience
8 Required Knowledge of Informatica 10.5
8 Required Developing reports in Cognos Analytics 11.1
8 Required Experience Using Unix cron
8 Required Experience Writing Unix shell scripts
8 Required Experience Writing moderate to advance SQL queries
8 Required Extensive Knowledge of Oracle 19
8 Required Basic knowledge of star schemas/dimensional data structures
8 Required Exceptional Technical writing
3 Preferred Knowledge of TIERS or HHSC Programs and Types of Assistance

Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.