Description

Build and optimize ETL pipelines using Informatica Power Center and IICS, integrating data from Oracle, SQL Server, and other sources into Snowflake for Tableau visualization.

This role is hybrid.

Responsibilities

• Design and develop complex mappings, workflows, and efficient Snowflake SQL scripts to automate data integration processes.
• Acquire and integrate data from diverse sources including Excel, Access, Adobe PDF, and relational databases.
• Develop and maintain CI/CD pipelines using GitHub and Git Actions, and write code in Java, JavaScript, and Python.
• Collaborate in an agile sprint team to deliver software platforms, utilizing JIRA for tracking and Mulesoft for integration.
• Create technical documentation and diagrams using Visio and Erwin, ensuring adherence to security principles for healthcare data.

Required Skills

• 14+ years of experience with Informatica Power Center and/or IICS.
• Strong proficiency in writing complex, optimized Snowflake SQL scripts.
• Experience with Tableau data visualization and integrating data sources for BI environments.
• Hands-on experience with CI/CD tools, specifically GitHub and Git Actions.
• Programming skills in Java, JavaScript, and Python.
• Familiarity with Mulesoft, Web Services (REST, SOAP), and AI tools like Snowflake Cortex.
• Background in healthcare industry, HHS agencies, or handling PII/PHI data.
• Bachelor’s degree in Computer Science, Information Systems, Business, or equivalent experience.

Key Skills

Education

Not specified