ETL Developer

The 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 (MDM) 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.