Description

Design, develop, and support ETL processes and enterprise applications.

You will own the release pipeline and data integrity for reporting databases and data warehouses.

Responsibilities

• Design, develop, and tune ETL processes using Informatica PowerCenter.
• Create complex SQL queries, stored procedures, triggers, and functions.
• Administer ETL platforms and integrate them for performance monitoring and analysis.
• Establish and maintain reporting databases and data warehouses.

Required Skills

• 6+ years of experience in enterprise application development.
• 4+ years of hands-on experience in ETL design, development, performance tuning, and monitoring using Informatica.
• 4+ years of experience 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.

Preferred Skills

• 8+ years of experience developing and enhancing Informatica Mappings and Workflows.
• Experience with healthcare EDI transaction sets (834, 999, H36, H41, 1095-A, 1095-B, SBMI) and ACA eligibility rules.
• Experience with healthcare IT data compliance, quality assurance, and PMO processes.

Key Skills

Education

Any Graduate