ETL Developer

DatamanUSA, LLC is a full-service IT Solutions Company that provides a variety of technical, IT, professional and administrative support services to both State and Federal government agencies. We also support commercial clients both large and small with staff augmentation and direct hire placement. If you are interested in this position and believe that this role is a great fit for your knowledge, skills, experience and career path.

Currently, we have an opening for ETL Developer in Austin, TX for our direct Client. The position details are below. If you are interested apply but please read the Job requirement first carefully

Title: ETL Developer

Duration: 8+ Months (with possibility of extension)

Location: Austin, TX

Job description:

The ETL Developer position will be an Information Technology (IT) resource that will assist in the development of data transformations, particularly targeting master data management solutions, in support of the Health and Human Services Commission (HHSC) Center for Analytics and Decision Support's, Enterprise Information Management (EIM) team. As a secondary requirement, the candidate should be familiar with technical and business metadata management and the related acquisition and administration requirements for Informatica Enterprise Data Catalog (EDC) and Informatica Axon.

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.

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.
• Ability to assess and utilize metadata information.

II. CANDIDATE SKILLS AND QUALIFICATIONS

Minimum Requirements: Candidates that do not meet or exceed the minimum stated requirements (skills/experience) will be displayed to customers but may not be chosen for this opportunity.
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.