GovServicesHub | Contract
ETL Administrator
Austin, United States | Posted on 11/05/2024
Job Information
- Target Date 11/08/2024
- Date Opened 11/05/2024
- Job Type Contract
- Industry IT Services
- Work Experience 5+ years
- City Austin
- State/Province Texas
- Country United States
- Zip/Postal Code 78717
Job Description
Job Location: Available to
work Hybrid, Austin, TX.
Note: 2
days/week On-Site, Local to TX
Job Description:
HHSC IT is continuing to develop an HHS data integration hub with
a goal to accomplish the following:
- Implementation and configuration of the infrastructure for the
data integration hub
- Design, development, and implementation (DD&I) of the data
integration hub using an agile methodology for all standard SDLC phases that
includes, but is not limited to:
- Validation of performance metric requirements
- Creation of Epics/User Stories/Tasks
- Automation of data acquisition from a variety of data sources
- Development of complex SQL scripts
- Testing – integration, load and stress
- Deployment / publication internally and externally
- Operations support and enhancement of the data integration hub
This development effort will utilize an agile methodology based
upon the approach currently in use at HHSC for the Texas Integrated Eligibility
Redesign System (TIERS). As a member of the agile development team, the
worker responsibilities may include:
- ETL Administration with a focus on data warehousing and business
intelligence solutions.
- Experience with Informatica IICS Administration, including
installation, upgrades, and maintenance of the Informatica IICS environment.
- Knowledge of Power Exchange Change Data Capture (CDC) on both
PowerCenter and IICS.
- Experience with a cloud background and knowledge of Continuous
Integration and Continuous Deployment (CI/CD) tools such as GitHub and Jenkins.
- Ability to think innovatively and automate various administrative
tasks in the admin space using Python and shell scripting skills.
- Excellent analytical skills to triage and resolve production
issues and outages.
- Proven expertise in designing, developing, and deploying ETL
pipelines using industry-standard tools like Informatica and IICS.
- Familiarity with a wide range of data sources: relational
databases (e.g., Oracle, SQL Server, MySQL, Snowflake), flat files, and cloud
platforms (e.g., AWS S3, Azure Blob).
- Experience in data quality, validation, and data migration
projects.
- Linux/Unix experience
Requirements
Skills Set:
Skill | Required /Desired | Experience |
ETL
Administrator with a focus on data warehousing and business intelligence
solutions | Required | 8 years |
Experience
with Informatica IICS Administration, including installation, upgrades, and
maintenance of the Informatica IICS environment | Required | 8 years |
Knowledge of
Power Exchange Change Data Capture (CDC) on both PowerCenter and IICS | Required | 8 years |
Experience with a
cloud background and knowledge of Continuous Integration and Continuous
Deployment (CI/CD) tools such as GitHub and Jenkins | Required | 8 years |
Ability
to think innovatively and automate various administrative tasks in the admin
space using Python and shell scripting skills | Required | 8 years |
Excellent
analytical skills to triage and resolve production issues and outages | Required | 8 years |
Proven
expertise in designing, developing, and deploying ETL pipelines using industry-standard
tools like Informatica and IICS | Required | 8 years |
Familiarity with
a wide range of data sources: relational databases (e.g., Oracle, SQL Server,
MySQL, Snowflake), flat files, and cloud platforms (e.g., AWS S3, Azure
Blob). | Required | 8 years |
Experience in
data quality, validation, and data migration projects | Required | 8 years |
Linux/Unix
experience | Required | 8 years |
Technical writing
and diagraming skills, including proficiency with modeling and mapping tools
(e.g., Visio, Erwin), and the Microsoft Office Suite (Word, Excel, and PowerPoint)
and MS Project | Required | 8 years |
Experience on an
agile sprint team | Required | 8 years |
Experience with
JIRA software | Required | 8 years |
Experience
working with multiple teams concurrently, being able to prioritize and
complete work on time with high quality | Required | 8 years |
Knowledge of
relational databases and data warehousing, including platforms like Oracle,
Snowflake, SQL Server, and MySQL. | Required | 8 years |
Proficiency in
SQL, Python and Bash | Required | 8 years |
Familiarity with
cloud ecosystems like AWS, Azure, or GCP and their respective data services | Required | 8 years |
Data Quality
& Modeling: Knowledge of data quality frameworks and data modeling
techniques | Required | 8 years |
Proven ability to
write well designed, testable, efficient code by using best software
development practices | Required | 6 years |
Understanding of
security principles and how they apply to healthcare data | Required | 4 years |
Experience with
state of the art software components for a performance metrics data
visualization or business intelligence environment | Required | 4 years |
Excellent oral
and written communication skills. | Required | 4 years |
Effectively
manage multiple responsibilities, prioritize conflicting assignments, and
switch quickly between assignments, as required | Required | 4 years |
Bachelor’s degree
in Computer Science, Information Systems, or Business or equivalent
experience | Required | - |
Prior experience
in the Healthcare Industry | Preferred | 3 years |
Prior experience
with an HHS agency | Preferred | 2 years |