Description

You will design, develop, and monitor ETL solutions and data conversion strategies to integrate disparate systems.

Responsibilities

• Architect end-to-end ETL transformation jobs using Informatica workflows, mappings, and SQL procedures.
• Develop and maintain stored procedures, triggers, and functions in PostgreSQL or other databases.
• Design data mapping and modeling for large-scale data migrations.
• Perform performance tuning, monitoring, and support for ETL processes.
• Adhere to established security, change control, and project management office policies.

Required Skills

• 6+ years of experience in enterprise application development.
• 4+ years of hands-on ETL design, development, and performance tuning using Informatica PowerCenter.
• 4+ years of experience as a database or reports developer utilizing SQL.
• 2+ years of experience creating complex SQL queries, stored procedures, triggers, and functions.
• 2+ years of experience in ETL platform administration and integration for performance monitoring.
• Experience establishing and maintaining reporting databases and data warehouses.
• Strong analytical and problem-solving skills to manage multiple critical priorities.

Preferred Skills

• 8+ years of experience developing and enhancing Informatica mappings and workflows.
• Experience with healthcare EDI transaction sets (834, 999) and ACA eligibility rules.
• Background supporting health exchange or Health and Human Services applications.

Key Skills

Education

Any Graduate