Description

Design and implement automated ETL processes and data integration workflows to support analytics and warehousing systems.

This role is on-site.

Responsibilities

• Develop mappings and workflows to automate ETL processes using Informatica IICS, IDMC, or Power Center.
• Acquire and integrate data from Snowflake, Oracle, SQL Server, Excel, Access, and Adobe PDF for Tableau visualizations.
• Design and develop complex, efficient SQL scripts.
• Plan and deliver software platforms used across multiple business units.
• Work within agile/scrum sprint teams using JIRA for management.

Required Skills

• 8+ years of experience in ETL development and data integration.
• Proficiency with Informatica IICS, IDMC, or Power Center.
• Strong SQL skills for complex script development.
• Experience with Snowflake, Oracle, and SQL Server.
• Python scripting and automation experience.
• Data modeling and diagramming using Visio or Erwin.
• Experience in data warehousing or performance management systems.
• Ability to work in Agile/Scrum environments using JIRA.

Preferred Skills

• Experience handling PII/PHI data and applying security principles in healthcare environments.
• Proficiency in HTML, CSS, JavaScript, jQuery, and REST/SOAP Web Services.
• Developing Tableau dashboards and reports with external data sources.

Key Skills

Education

Any Gradute