Informatica ETL Developer - Remote

Overview

We are seeking a highly experienced Informatica Extract Transform Load (ETL) Developer to join our Enterprise Data Warehouse (EDW) team. This role is responsible for designing, developing, and maintaining robust ETL processes using Informatica PowerCenter and Teradata, focusing on supporting healthcare-related data systems.

In Short

• Design and implement ETL solutions using Informatica PowerCenter.
• Automate data staging processes and optimize ETL job scheduling.
• Administer and support ETL environments.
• Monitor and troubleshoot ETL jobs across various environments.
• Write and optimize complex SQL queries and Unix Shell scripts.
• Collaborate with stakeholders to define requirements.
• Participate in unit, integration, and system testing.
• Provide technical support and mentoring to team members.
• Continuously learn and apply new technologies.
• Communicate project status and deliverables to leadership.

Requirements

• 7+ years of experience with Informatica PowerCenter and ETL development.
• 5+ years of experience writing complex SQL and performance tuning.
• 5+ years of experience with relational database management systems.
• 5+ years of Informatica PowerCenter administration experience.
• Strong communication and collaboration skills.
• Bachelor's or advanced degree in IT or related field.
• Strong organizational and time management skills.

Benefits

• Opportunity to work remotely with occasional travel.
• Engagement in innovative healthcare data projects.
• Collaborative team environment.
• Professional development opportunities.
• Supportive management.