IT Operations Engineer - Informatica Team Engineer

INSURANCE COMPANY OF NORTH AMERICA (A Chubb Company); Philippines; Remote; PHP 400,000 - 600,000; Full time

Job summary

INSURANCE COMPANY OF NORTH AMERICA (A Chubb Company) seeks an experienced Informatica developer to join our Treasury applications team. The candidate will provide production support for ETL and data integration workloads, monitor tickets and queues, and work with interface IT partners to resolve issues.

Required skills include Informatica PowerCenter, Unix/Linux scripting, SQL, and experience with scheduling tools such as IBM ROBOT Scheduler and Autosys.

Qualifications

• 4 to 6 years hands-on Informatica PowerCenter production support experience.
• Experience with ETL workflow design and development.
• Experience following full project lifecycle from development to support.
• Familiar with Agile/Scrum ceremonies and daily standups.
• Experience with source code management and DevOps practices.

Responsibilities

• Provide production support for Treasury applications, monitor tickets and queues.
• Handle job failures, perform root cause analysis, fix and reprocess data.
• Generate test results, reports, and respond to outages.
• Improve error handling, mappings, automation and reduce incidents.
• Participate in major incident management and DR activities.
• Coordinate with interfacing teams to resolve issues.
• Create and maintain knowledge base.
• Work in shifts covering US EST and LATAM.

Skills

Analytical skills

Problem-solving

Communication skills

Team collaboration

Independent work

Tools

Informatica PowerCenter

Unix/Linux scripting

IBM ROBOT Scheduler

Autosys

SQL

Git/GitHub

JIRA

DevOps / CICD

Job description

Seeking an experienced Informatica developer to join our Treasury applications team. The candidate should have a strong background in ETL (Extract, Transform and Load) process, data transformation, data integration and warehousing. This positions main job requirement is to provide production support.The position will monitor all the tickets and queues assigned to the application group.

Key Responsibilities:

• Production Support activities include handling job failures, debugging data issues, root cause analysis of failures and working with business and interface IT partners to fix, restart or reprocess.
• Support also includes performing test runs for interface partners, generate relevant test results & reports and responding to outages.
• Continuous process improvements are carried out to enhance error handling, change rules & mappings, increase automation, and reduce incident count.
• Attending major incident management calls
• Participate/Support (application or infrastructure) as necessary
• Participate/Perform DR activities
• Perform minor enhancement work (design and develop)
• Good expertise on the service-now produce usage
• Ability to alert and respond to the issues.
• Track and follow through the issues until complete
• Work/coordinate with interfacing application teams for issue resolution
• Build knowledge base
• Able to work in shifts (US EST and LATAM)

Technical Skills:

• Good knowledge of Informatica PowerCenter components (Designer, Workflow Manager, Workflow Monitor, Repository Manager)
• Experience with Unix/Linux shell scripting and scheduling tools (e.g., IBM ROBOT Scheduler, Autosys)
• Experience with relational databases (e.g., IBM DB2, MS SQL Server) and proficiency in SQL
• Good experience in transformations – XML, CSV, JAVA, HTTP, SQL, Source Qualifier, Expression, Router, Joiner, Lookup, Aggregator, sorter, Union, Rank, Normalizer, XML Source/Target, Stored Procedure, Data Masking
• Knowledge of cloud-based data integration tools, IICS, Azure integration is plus

Soft Skills:

• Strong analytical and problem-solving skills.
• Excellent communication and interpersonal skills.
• Ability to work independently and collaboratively in a team environment.

Experience:

• 4 to 6 years hands on experience with Informatica PowerCenter in providing application production support,
• Experience on small enhancement work (minor development work - designing and develop ETL workflows)
• Experience in organization standards, participation full project development life cycle right from development to implementation and support, change management process, warranty support procedures (incidents/problems/changes)
• Working experience in Agile environment and Scrum framework process (ceremonies, daily standups, agility, responsibilities and accountability)
• Experience in use of source code management (Git, GitHub), DevOps, CICD
• Experience in use of JIRA for requirements, development, daily updates, deployments and communication with project stakeholders.