Oracle ETL Developer

Job ID: TX-529300502    5P

Onsite/Local Oracle ETL Developer with DDL/DML, SQL, data analysis, Informatica Power Center/PowerCenter/Data Quality, MDM, EDC, Axon, and Healthcare experience

Location: Austin, TX (HHSC)
Duration: 4 months

Years Required/Preferred Experience
8 Required Experience with Oracle DDL and DML.
8 Required Experience with SQL and data analysis.
8 Required Skill in communicating effectively – orally and in writing
8 Required Ability to manage competing priorities, work under pressure, negotiate among multiple parties, resolve conflicts.
8 Required Ability to establish and maintain effective working relationships – internally and externally.
8 Required Ability to work cooperatively and effectively in a team environment.
8 Required Ability to exercise judgment and work independently with limited direction.
8 Required Ability to work on multiple projects or project assignments.
6 Preferred Strong SQL Experience.
6 Preferred Experience with Oracle Databases.
4 Preferred Graduation from an accredited four-year college or university.
3 Preferred Experience Developing ETL with informatica Power Center and Informatica Data Quality.
3 Preferred Experience with security and data quality metadata.
2 Preferred Strong Informatica Metadata Manager experience. Strong EDC and Axon experience.
2 Preferred Strong ETL development skills in Informatica Power Center and Data Quality.
2 Preferred Familiarity with agile software development lifecycle.
2 Preferred Ability to assess and utilize metadata information.
1 Preferred Experience with the Healthcare business domain.
1 Preferred Experience working with Texas Medicaid Management Information System (MMIS) data and Texas Integrated Eligibility Redesign System (TIERS).
1 Preferred Experience with using and administering Informatica Enterprise Data Catalog and Axon.

Essential Job Functions:
Contribute the development of ETL processes, particularly those targeting HHSC’sMaster data management solution. Coordinate and communicate with cross-agency SMEs to review and confirm technical metadata gaps. Participation and knowledge in the development of processes and guidelines for Metadata Management – change management, metadata access and sharing. Communicate successfully with technical and non-technical groups to facilitate the coordination of project activities. Attends work on a regular and predictable schedule in accordance with agency leave policy and performs other duties as assigned. (10%)

Knowledge Skills Abilities:
Experience with using and administering Informatica Enterprise Data Catalog and Axon.
Experience Developing ETL with informatica Power Center and Informatica Data Quality.
Experience with Oracle DDL and DML.
Experience with SQL and data analysis.
Experience with security and data quality metadata.
Skill in communicating effectively – orally and in writing.
Ability to assess and utilize metadata information.
Ability to manage competing priorities, work under pressure, negotiate among multiple parties, resolve conflicts.
Ability to establish and maintain effective working relationships – internally and externally.
Ability to work cooperatively and effectively in a team environment.
Ability to exercise judgment and work independently with limited direction. Ability to work on multiple projects or project assignments.