Description

You will design and implement data integration workflows and automated ETL processes to support analytics and warehousing projects.

Responsibilities

• Develop mappings and workflows to automate ETL processes using Informatica Power Center or IICS.
• Integrate data from Oracle, SQL Server, Excel, Access, and Adobe PDF sources for Tableau visualization.
• Design and develop complex, efficient Oracle and Snowflake SQL scripts.
• Build and maintain software platforms across multiple organizational units within an agile sprint environment.
• Create technical documentation and diagrams using Visio, Erwin, and MS Project.

Required Skills

• 8+ years of experience in ETL development using Informatica Power Center or IICS.
• 8+ years of experience with Oracle, SQL Server, Excel, Access, and Adobe PDF data sources.
• 8+ years of experience writing complex Oracle and Snowflake SQL scripts.
• 8+ years of experience designing and developing Python scripts.
• 8+ years of experience working on agile teams using JIRA.
• 8+ years of experience with Java, JavaScript, and C# development.
• 8+ years of experience developing CI/CD pipelines with GitHub and GitHub Actions.
• 8+ years of experience as a MuleSoft developer and SAS Viya Administrator.
• 8+ years of experience with technical writing and modeling tools like Visio or Erwin.

Preferred Skills

• Experience with Web Services (REST, SOAP).
• Knowledge of healthcare data security principles, PII, or PHI.

Key Skills

Education

Any Gradute