Senior Informatica Developer (PowerCenter / IICS)

Siritech Solutions Corp

Austin, TX

JOB DETAILS
JOB TYPE
Contractor
SKILLS
Agile Programming Methodologies, Analysis Skills, Architectural Analysis, Artificial Intelligence (AI), Atlassian JIRA, Automation, Business Analysis, Communication Skills, Computer Science, Continuous Deployment/Delivery, Continuous Integration, Data Modeling, Data Modeling Tools, Data Warehousing, Database Extract Transform and Load (ETL), Database Programming, Department of Health and Human Services, Dimensional Modeling, Documentation, Enterprise Data Integration, GitHub, Healthcare, Identify Issues, Informatica, Information Technology & Information Systems, Interoperability, Java, JavaScript, Microsoft Visio, Oracle, Oracle Database, Presentation/Verbal Skills, Privacy Controls, Problem Solving Skills, Product Lifecycle, Production Support, Programming Tools, Python Programming/Scripting Language, REST (Representational State Transfer), Requirements Management, SOAP (Simple Object Access Protocol), SQL (Structured Query Language), Scalable System Development, Scripting (Scripting Languages), Scrum Project Management and Software Development, Security Compliance, Snowflake Schema, Sprint Planning, Standup Meetings, Tableau, Testing, Writing Skills, erwin Data Modeler
LOCATION
Austin, TX
POSTED
1 day ago

Total Required Experience in Years:Minimum 14%2B Years

Mode of Work:
Hybrid (3 Days Onsite / 2 Days Remote

Austin, TX Local Candidates Only Within 50-Mile Radius

Interview: Face-to-Face Interview Required in Austin, TX


Job Description: 
The Senior Informatica Developer will support HHSCs PMAS Data Integration Hub initiative by designing, developing, optimizing, and maintaining enterprise-scale ETL solutions and data integration processes supporting analytics and reporting initiatives. The ideal candidate should possess deep expertise in Informatica PowerCenter, Informatica IICS, Snowflake SQL, Oracle, healthcare data environments, and enterprise data warehousing. This role requires developing scalable ETL pipelines, integrating data from multiple enterprise sources, supporting Agile delivery, and collaborating with architects, analysts, and engineering teams to implement secure, high-performing, and scalable enterprise data solutions.


Key Responsibilities:

  • Design, develop, maintain, and optimize ETL mappings, workflows, and enterprise data integration solutions using Informatica PowerCenter and Informatica IICS
  • Integrate data from structured and unstructured enterprise sources supporting analytics and reporting environments
  • Develop, optimize, and maintain Snowflake SQL scripts supporting data transformation, reporting, and analytics workloads
  • Create Oracle views, materialized views, and database objects supporting dimensional data models and enterprise reporting
  • Participate in Agile development lifecycle activities including sprint planning, standups, retrospectives, and release activities
  • Collaborate with data architects, business analysts, and engineering teams to deliver scalable enterprise data solutions
  • Produce technical specifications, workflow diagrams, mappings, documentation, and implementation artifacts
  • Support testing, deployment, troubleshooting, enhancements, and production support activities
  • Analyze changing business requirements and implement scalable technical enhancements aligned with enterprise objectives


Additional Responsibilities:

  • Develop automation scripts and integration processes using Python
  • Support REST and SOAP service integration development activities
  • Assist with CI/CD pipeline development and deployment automation using GitHub Actions
  • Support MuleSoft integration and interoperability initiatives
  • Utilize AI-assisted development tools such as Snowflake Cortex and Informatica Claire for productivity and modernization efforts
  • Support healthcare data governance, compliance, privacy, and security initiatives including PII/PHI handling requirements


Required Skills:

  • Strong Informatica PowerCenter development experience
  • Strong Informatica IICS development expertise
  • ETL development and enterprise data integration experience
  • Snowflake SQL development and optimization expertise
  • Oracle database development and integration experience
  • Data warehousing and dimensional modeling experience
  • Tableau integration and reporting support experience
  • Agile/Scrum methodology experience
  • Python scripting and automation experience
  • Java and JavaScript development knowledge
  • GitHub Actions and CI/CD pipeline experience
  • JIRA experience


Preferred Skills:

  • MuleSoft development experience
  • Healthcare industry experience
  • HHS agency experience
  • PII/PHI data handling and healthcare compliance experience
  • Experience with AI-assisted development tools such as Snowflake Cortex and Informatica Claire
  • Visio and Erwin data modeling tools experience


Qualifications:

  • Strong analytical, troubleshooting, and problem-solving skills required
  • Excellent verbal and written communication skills required
  • Experience supporting enterprise data warehouse projects preferred
  • Experience with healthcare compliance, privacy, and security standards preferred
  • Austin, TX local candidates only (within 50-mile radius)
  • Face-to-face interview required in Austin, Texas


Education:

  • Bachelors degree in Computer Science, Information Systems, Business, or equivalent professional experience


Certifications:

  • Informatica Certification preferred
  • Snowflake Certification preferred



About the Company

S

Siritech Solutions Corp