Senior Informatica ETL Operations Support Engineer

Install, configure and manage Informatica Power Center. Assess the impact of upgrading Informatica and all its components (Informatica PowerCenter mappings, workflows, jobs, and other ETL processes).

Identify and troubleshoot system outages, installation issues, and application code errors running Java applications in AWS.

Generate and install security certificates and PGP keys.

Work with the Control-M tool or equivalent to create and schedule batches and to create calendars and daily schedules for critical batches.

Restore Informatica Power Center services and manage users and governance controls.

Configure, maintain, and troubleshoot Redhat Jboss, Fuse, Apache, and Tomcat HTTP servers.

Perform system troubleshooting by reading and deciphering app logs, and system logs from Splunk.

Configure, deploy, verify, and troubleshoot SSL certificates.

Read/understand/improve scripts related to the application, batches, and/or web services.

Identify installation issues and application code errors running in JBoss/ Tomcat/ Informatica/ Control M.

Provide options, recommendations, and additional actions related to resolving issues, mitigating risks, and resolving escalated items.

Work with configuration management tool Jenkins to automate tasks such as code check-in software build.

Manage, monitor, and configure the Splunk application monitoring tool.

Support releases and adherence to change control standards.

Perform scheduled maintenance activities such as patching, performance tuning, and backups.

Execute daily batch scripts, days, evenings, weekends, and holidays as required.

Perform capacity planning and scalability planning.

Work with JIRA Service Desk to manage Incidents and Change Processes.

Availability to work in rotation shifts mode.

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.

A minimum of three (3) years performing day-to-day Informatica PowerCenter operations, functions, administration, or troubleshooting tasks.

A minimum of three (3) years of experience as a Batch Operator using Control-M or equivalent.

A minimum of two (2) years of experience working in a PostgreSQL DB or equivalent environment.

Experience working in the health insurance marketplace, healthcare, or health and human services domains.

Demonstrable analytical experience and ability to work in a complex system environment.

Demonstrable experience with application and batch integration.

Familiarity with Database and SQL functions.

Ability to troubleshoot system issues by collaborating with a team of system operations professionals.

Ability to work in a multidisciplinary team and effectively communicate with different functions.

A minimum of five (5) years of experience supporting day-to-day operations functions of a complex enterprise system.

A minimum of five (5) years of experience as a Batch Operator or equivalent, supporting day-to-day configurations and operations of various batch jobs in a complex enterprise system.

A minimum of three (3) years of experience in identifying and troubleshooting system outages, installation issues, and application code running JBoss/Tomcat applications in AWS.

Experience demonstrating critical thinking, providing options, recommendations, and additional actions relating to resolving issues, mitigating risks, and resolving escalated items in supporting a large or complex infrastructure/systems.

Experience with operating, configuring, and troubleshooting Control-M or equivalent batch applications.

Experience managing web-based systems hosted on the AWS platform.

Working knowledge of Electronic Data Interchange (EDI) operations.

Understand java runtime environment concepts such as heap memory, thread dumps, garbage collection, etc.

Experience working with the Project Management Office (PMO) processes, policies, and procedures.