Job Title: Informatica Developer
Duties / Responsibilities
INNOWIN seeks up to three (3) Senior Computer Programmer (Senior ETL Developer) resources to provide Extract, Transform, and Load (ETL) design, development, implementation, maintenance, and support
services for the Health Benefit Exchange (HBX) and other systems.
Duties / Responsibilities
- Design, develop, automate, support, and monitor performance tuning using Informatica.
- 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.
- 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.
Minimum Qualifications
- 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 hands-on experience using InformaticaPowerCenter.
- Demonstrated analytical and problem-solving skills.
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 InformaticaPowerCenter.
- 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.
- Experience working with the Project Management Office (PMO) processes, policies, and procedures.