Sr. Computer Programmer / ETL(Hybrid)

Job Title

Location: Baltimore, MD (Hybrid)

Duties/Responsibilities

• Design, develop, automate, support, and monitor performance tuning using Informatica.
• Develop stored procedures, triggers, and functions in SQL in PostgreSQL or other databases.
• Architect Extract, Transform, and Load (ETL) solutions and data conversion strategies for integrating disparate systems.
• Create data mapping and modeling for data migrations.
• Create an end-to-end solution for ETL transformation jobs that involve writing Informatica workflows and mappings, SQL procedures, and functions.
• Develop, maintain, and enhance Informatica Mappings, Work-flows, and processes.
• Adhere to all security, change control, and project management office (PMO) policies, processes, and methodologies.

Required Skills

• A minimum of six (6) years of experience in enterprise application development.
• A minimum of four (4) years of hands-on experience in Extract, Transform, and Load (ETL) design, development, performance tuning, monitoring, and supporting using Informatica.
• A minimum of two (2) years of hands-on experience in creating complex and efficient SQL queries, stored procedures, triggers, and functions.
• A minimum of two (2) years of hands-on experience in ETL platform administration and integration for performance monitoring and analysis.
• A minimum of four (4) years of experience as a database or reports developer utilizing SQL.
• A minimum of four (4) years of hands-on experience using Informatica PowerCenter.
• Experience in establishing and maintaining reporting databases and data warehouses.
• Demonstrated ability to manage multiple critical priorities and tight deadlines.
• Demonstrated analytical and problem-solving skills.

Preferred Skill

• A minimum of eight (8) years of experience developing, maintaining, and enhancing Informatica Mappings, Work-flows, and processes.
• A minimum of six (6) years of hands-on experience using Informatica PowerCenter.
• A minimum of four (4) years of experience in developing ETL solutions and data conversion strategies of disparate systems and creating data mapping and modeling for data migrations.
• A minimum of four (4) years of hands-on experience in ETL design, development, performance tuning, monitoring, and supporting using Informatica.
• A minimum of four (4) years of hands-on experience in creating complex and efficient SQL queries, stored procedures, triggers, and functions.
• A minimum of four (4) years of ETL-related experience supporting health exchange, health care EDI (Electronic Data Interchange), or Health and Human Services applications.
• Experience in analyzing, converting, and transforming EDI transaction sets such as the 834 and 999 IRS datasets, such as the H36, H41, 1095-A, 1095-B, and SBMI.
• Knowledge of the Affordable Care Act (ACA) eligibility rules.