Informatica Developer

HYBRID 2 days a week on-site in Baltimore, MD 3-5 year Project Duties: Must be capable of utilizing third- and fourth-generation or current state-of-the-art IT equipment and languages to develop and prepare diagrammatic plans for solution of business, management, communications, and strategic problems. Must be able to design detailed programs, flowcharts, and diagrams showing mathematical computations and sequence of machine operations necessary to copy and process data and print results. Must be able to verify the accuracy and completeness of programs and systems by preparing sample representative data and perform testing by means of cycle and system processing. 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 MHBE Project Management Office (PMO) policies, processes, and methodologies. Note: The candidate must be flexible to work overtime as needed, including weekends, holidays, and off-hours. Preferred Qualifications 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. Experience with data quality assurance, quality control, and large-scale Healthcare IT Systems data compliance processes. Experience working with the Project Management Office (PMO) processes, policies, and procedures. Job Types: Contract, Full-time Pay: $70,314.81 - $165,062.28 per year Benefits: 401(k) Dental insurance Health insurance Paid time off Vision insurance Schedule: Monday to Friday Overtime Weekend availability Ability to commute/relocate: Baltimore, MD 21202: Reliably commute or planning to relocate before starting work (Required) Application Question(s): Do you have EDI or Healthcare experience? If so, how many years? Can you work on-site 2 days a week in Baltimore, MD? What is your work authorization status? What is the salary/pay rate you are looking for? Experience: Informatica: 8 years (Preferred) ETL: 4 years (Preferred) Work Location: Hybrid remote in Baltimore, MD 21202