A leading service provider in Austin is looking for a skilled professional to automate ETL processes using Informatica Power Center or IICS and integrate diverse data sources for data visualization. The ideal candidate will have strong SQL skills, experience in the healthcare industry, and demonstrate excellent analytical abilities. A Bachelor’s degree in a related field is required. This position offers the opportunity to work on advanced data analytics projects in a dynamic environment.
Qualifications
Experience integrating data from various sources using Informatica Power Center or IICS.
Strong analytical and problem-solving skills in data analytics projects.
Experience developing Oracle and Snowflake SQL scripts.
Proficiency with modeling/diagramming tools like Visio or Erwin and MS Office.
Experience planning software platforms used across products and units.
Ability to write well designed, testable, efficient code using best practices.
Responsibilities
Automate ETL processes using Informatica Power Center or IICS.
Design and develop performance metrics data visualization tools.
Analyze data and support data warehousing or performance management projects.
Create diagrams and documentation with Visio/Erwin and MS Office tools.
Plan and deliver software platforms used across multiple teams.
Write clean, maintainable code following best software practices.
Skills
Informatica Power Center
SQL
Tableau
Python
Agile methodology
Excel
Access
Adobe PDF
SQL scripting
Python scripting
Visio
Erwin
MS Project
JIRA
GitHub
Git Actions
REST
SOAP
Education
Bachelor’s degree in Computer Science, Information Systems, or Business
Tools
JIRA
Visio
GitHub
Job description
Austin, United States | Posted on 12/06/2025
Experience developing mappings and workflows to automate ETL processes using Informatica Power Center or IICS.
Required
Experience acquiring and integrating data from multiple data sources/technologies using Informatica Power Center or IICS for use by a Tableau data visualization object. Data source techs should include Oracle, SQL Server, Excel, Access and Adobe PDF.
Experience designing and developing complex Oracle and/or Snowflake SQL scripts that are fast and efficient.
Strong analytical and problem-solving skills with experience as a system analyst for a data analytics, performance management system, or data warehousing project.
Technical writing and diagramming skills, including proficiency with modeling and mapping tools (e.g., Visio, Erwin), and the Microsoft Office Suite (Word, Excel, and PowerPoint) and MS Project.
Experience in planning and delivering software platforms used across multiple products and organizational units.
Proven ability to write well designed, testable, efficient code by using best software development practices.
Preferred
Excellent oral and written communication skills.
Effectively manage multiple responsibilities, prioritize conflicting assignments, and switch quickly between assignments, as required.
Experience on an agile sprint team.
Understanding of security principles and how they apply to healthcare data.
Experience with state of the art software components for a performance metrics data visualization or business intelligence environment.
Bachelor’s degree in Computer Science, Information Systems, or Business or equivalent experience.
Prior experience in the Healthcare Industry.
Prior experience with an HHS agency.
Prior experience working with PII or PHI data.
Experience designing and developing scripts using Python.
Experience with JIRA software.
Functional knowledge or hands‑on design experience with Web Services (REST, SOAP, etc.).
Experience developing CI/CD pipelines with GitHub and Git Actions.