PMCS SERVICES
Austin, TX
Post Resume to
View Contact Details &
Apply for Job
Job Description :
We are looking for a Full-time contractor or employee for a Business Intelligence Analyst  role at one of our client sites.
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.
  • 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.

CANDIDATE SKILLS AND QUALIFICATIONS(Required):
  • Knowledge of the principles, practices, and techniques of software development and the full software development life cycle (SDLC).
  • Hands on business intelligence application development or closely related experience
  • Hands on experience in developing complex to moderate SQL queries and procedures 
  • Skill using Cognos, Informatica, SQL, Oracle Database, and/or other similar tools and technologies to design, develop, test, troubleshoot, and repair enterprise-class business intelligence applications.
  • Hands on experience developing & implementing star schemas and dimensional data structures.
  • Hands on experience in developing extract, transformation, load (ETL) and reporting processes using Informatica and/or Cognos platforms
  • Hands on experience with one or more of Informatica v 10.x, Cognos v 11.x, and Oracle 19c
 
Skills(Preferred):
  • Hands on experience with Unix Cron
  • Hands on experience writing Unix shell scripts
  • Experience with Health & Human Services programs, if possible with TIERS (Texas Integrated Eligibility System)
             

Similar Jobs you may be interested in ..