JOBSEARCHER

Senior Informatica Developer

ARCHIVED

We can't find an active application page for this role right now. It may reopen or be listed elsewhere. Use Next Steps to search for an active apply link and similar live jobs.

Hello Everyone,
Title: Senior Snowflake ETL Developer (with Informatica IICS & Informatica Powercenter)
Location: Austin Texas (Hybrid) Mode of Interview: In person
Experience: 14+ Years
Note: ***Only W2 Consultants and H1 transfer
Skills: ETL, IICS, Oracle, SQL Server, Adobe PDF, Snowflake, Visio, Erwin, PowerPoint, JIRA, JAVA, CI/CD, Github, AI, and Informatica experience Position will be 2 days remote with 3 days required to be onsite at the location listed above. Program will only allow candidates who are LOCAL TO THE AUSTIN AREA ONLY (Within 50-mile radius).Please do not submit candidates who are currently out of state and are planning to move to Texas. Candidates must already reside in Texas.
Job Summary: We are looking for a skilled ETL Developer to support the development of a Healthcare Data Integration Hub for HHSC. The role involves building ETL pipelines, integrating data from multiple sources, developing SQL scripts, and supporting analytics/reporting solutions in an agile environment.
Key Responsibilities:
  • Lead and support agile data engineering projects
  • Develop ETL workflows using Informatica PowerCenter/IICSBuild and optimize complex Snowflake SQL scripts
  • Integrate data from Oracle, SQL Server, Excel, Access, PDF, and other sources
  • Create database views and dimensional data models
  • Automate data acquisition and validation processes
  • Participate in sprint planning, standups, reviews, and retrospectives
  • Work with architects and business teams on data solutions
  • Develop technical documentation, diagrams, and specifications
  • Support testing, deployment, enhancements, and production support
  • Ensure secure handling of healthcare, PII, and PHI data
Required Skills:
  • Strong experience with Informatica PowerCenter or IICSExperience with Snowflake SQL and ETL development
  • Knowledge of data warehousing and dimensional modeling
  • Experience with Oracle, SQL Server, Excel, Access, and PDF data integration
  • Agile/Scrum team experience
  • Strong analytical, troubleshooting, and communication skills
  • Experience with Python scripting
  • Familiarity with JIRA, GitHub, and CI/CD pipelines
  • Understanding of healthcare data security principles
Preferred Skills:
  • Healthcare or HHS agency experience
  • Experience handling PII/PHI data
  • Java, JavaScript, REST/SOAP web services
  • MuleSoft development experienceAI tools experience such as Snowflake Cortex, Informatica Claire, or similar
EducationBachelor’s degree in Computer Science, Information Systems, Business, or equivalent experience.