Hello There
My name is Amit Kumar and I serve as the Sr. Technical Recruiter at Kanak-IT INC. I am reaching out to share an excellent career opportunity for the role of Kafka Platform Engineer with our esteemed client. If you are interested then please share your updated resume at .
Title: Business Intelligence Analyst 3
Location: 100% Remote Austin TX (Only Local TO TEXAS)
Job Type: Multi Year
Job Description:
Analysts use data to figure out market and business trends for companies to increase profits and efficiency. They may work directly for a company or as a consultant. They able to look at large chunks of data and understand trends and then communicate those trends to the company.
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 - Work with other teams as necessary to accomplish goals.
- Create technical and design documentation as required.
- Perform system analysis and problem resolution as required.
- Analyze software for configuration & performance tuning opportunities as required.
- Develop and maintain data and process models as required.
- Employ contemporary testing methods to ensure applications function properly and without error.
- Provide technical support for testing and implementation efforts.
- Participate in program design coding and test walk-through meetings to provide input regarding technical standards and customer requirements.
- Provide database support (defect repair maintenance and production operations support) for State Portal DataMart reports. Perform system analysis
troubleshooting diagnosis and problem resolution. Analyze software for defects and performance tuning opportunities. Develop and test code/scripts to
resolve defects and improve application reliability and performance - Other duties as assigned.
MUST HAVE
- 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
PREFERRED
- 3 Preferred Knowledge of TIERS or HHSC Programs and Types of Assistance