
ETL Informatica Developer
PMCS Services, Inc. ·Austin, TXClosing in
Term:Full timeWork:Onsite
Type:EmployeeContract
We are looking for a Full-time contractor or employee for a ETL Informatica Developer role.
The ETL Developer’s responsibilities may include:
The ETL Developer’s responsibilities may include:
- Working with subject matter experts (SMEs) across agencies to collect and update technical and business metadata.
- Load collected technical business metadata into EDC and Axon.
- Administer EDC and Axon
- Develop ETL in Informatica Power Center and Informatica data quality
- Develop data quality processes and scorecards?
- Perform outreach and communication with source systems to support change management automation adopted by source systems.
- Review and assessment of the design, implementation and management of security access roles and privileges for all types of metadata consumers.
- Identification and documentation of business processes.
- Other duties as assigned.
Essential Job Functions:
Contribute the development of ETL processes, particularly those targeting HHSC’s?Master 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.
Skills(Required):
- Experience with Oracle DDL and DML.
- Experience with SQL and data analysis.
- Skill in communicating effectively - orally and in writing
- 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.
Skills(Preferred):
- Strong SQL Experience.
- Experience with Oracle Databases.
- Graduation from an accredited four-year college or university.
- Experience Developing ETL with informatica Power Center and Informatica Data Quality.
- Experience with security and data quality metadata.
- Strong Informatica Metadata Manager experience. Strong EDC and Axon experience.
- Strong ETL development skills in Informatica Power Center and Data Quality.
- Familiarity with agile software development lifecycle.
- Ability to assess and utilize metadata information.
- Experience with the Healthcare business domain.
- Experience working with Texas Medicaid Management Information System (MMIS) data and Texas Integrated Eligibility Redesign System (TIERS).
- Experience with using and administering Informatica Enterprise Data Catalog and Axon.