Informatica Production Support Developer

Description

Why choose Manulife?

• Competitive salary package
• HMO on the first day with free dependents
• Retirement benefits
• Merit Increase
• Performance Bonus
• Global network of industry experts
• Extensive training resources

Work Arrangement : Hybrid Work Set-Up

Schedule : Fixed Night Shift

Job Summary

Platform Middleware Application Support (PMAS) team is currently looking for a candidate with proven Informatica Development experience to expand capabilities of the current team.

PMAS team is responsible for providing KLO and troubleshooting support for over 50 Informatica applications in two separate Informatica environments.

Responsibilities include all standard production support tasks :

• Analyze and Debug Informatica ETL Transformation and embedded SQL code.
• Trace and track source / target locations
• Raise and communicate incident tickets in accordance with established Change Management process.
• Consult and guide on proper and preferrable use of Informatica Transformations

Platform Middleware is a 24 / 7 support team. Person in this role is expected to rotate shift coverage on monthly basis, as well as perform On-Call support on weekends as needed.

Person in this role will be expected to know Informatica 10.x, including Designer, Workflow Manager, Workflow Monitor and Repository Manager.

This position is for an established Informatica developer that would be able to jump right into the daily routines. Day 1 responsibilities might include developing new transformation, debugging on-going issue, or providing consultation on Informatica design.

Informatica DIH and TDM are some of the Informatica tools that we use. Knowledge of at least one of these is a great plus.

Training will be provided as needed)

Responsibilities

• Participate in platform upgrades.
• Maintain and update Platform Support documentation as needed.
• Follow established change management procedures.
• Be available to work off-hours and extended shifts if required.
• Provide on-call support as part of on-call rotation within the Platform Support team.
• Proactive ownership of incidents-issues until resolution
• Logging and tracking identified system problems through resolution.
• Creating and maintaining documentation on processes, policies, application configuration and help related materials for users as database applications are developed.
• Ability to effectively communicate, cooperate, and collaborate; ability to lead
• Building effective working relationships with internal and external resources, technology vendors and outsourcing service providers
• Interfaces with IS groups, strategic vendor partners, and other Business Units, peers, IS Managers, Directors, and AVPs.

Key Accountabilities :

Daily Informatica Production support responsibilities :

• Act as one of primary contacts for Informatica PowerCenter
• PowerCenter daily activities :
• Analyzer and Troubleshoot Transformation workflows.
• Consult on Informatica design solutions.
• Enhance or create new Informatica transformations.
• Test existing workflows and transformations for large platform wide events (e.g. upgrades)
• Participate in platform upgrades.
• Create and Maintain Runbooks and other related documentation.
• Follow and enforce code management and change management procedure.
• Provide Consulting services on Informatica Transformation best practices.
• Provide Audit Reports on demand.

Qualifications

Skills and Competencies :

• 3+ years of experience in a large, multinational organizationexperience within financial services, or insurance industry preferred.
• Candidate must pass or exceed the current role’s expectations and meet ALL performance metrics.
• Must not have any attendance issues and has not received any disciplinary actions.
• College / University graduate (Computer Science or related discipline is preferred) or with previous related work experience.

Technical Skills :

• 5+ years of experience with Informatica PowerCenter, including version 10.x
• Must be able to read, analyze and write PERL or UNIX script.
• Must have experience troubleshooting SQL queries, including stored procedures.
• Knowledge of CAW batch or similar scheduling agent

Language and Interpersonal Skills :

• Strong customer service and interpersonal skills such as teamwork
• Strong written, verbal, and presentation skills
• Ability to effectively communicate, cooperate, and collaborate; ability to lead and influence technical peers and decision makers.
• Candidate must have good organizational, time management, and planning skills with the ability to be flexible to changing environments and to work independently and meet tight deadlines.
• Candidate must demonstrate problem solving skills.

Manulife is an Equal Opportunity Employer

At Manulife / John Hancock, we embrace our diversity. We strive to attract, develop and retain a workforce that is as diverse as the customers we serve and to foster an inclusive work environment that embraces the strength of cultures and individuals.

We are committed to fair recruitment, retention, advancement and compensation, and we administer all of our practices and programs without discrimination on the basis of race, ancestry, place of origin, colour, ethnic origin, citizenship, religion or religious beliefs, creed, sex (including pregnancy and pregnancy-related conditions), sexual orientation, genetic characteristics, veteran status, gender identity, gender expression, age, marital status, family status, disability, or any other ground protected by applicable law.

It is our priority to remove barriers to provide equal access to employment. A Human Resources representative will work with applicants who request a reasonable accommodation during the application process.

All information shared during the accommodation request process will be stored and used in a manner that is consistent with applicable laws and Manulife / John Hancock policies.

To request a reasonable accommodation in the application process, contact

Who is MBPS?

Manulife Business Processing Services (MBPS) is a global shared service center providing administrative, finance, investments, contact center, information technology, underwriting, actuarial, and marketing services to Manulife and John Hancock companies around the world.

About Manulife and John Hancock

Manulife Financial Corporation is a leading international financial services group that helps people make their decisions easier and lives better.

With our global headquarters in Toronto, Canada, we operate as Manulife across our offices in Asia, Canada, and Europe, and primarily as John Hancock in the United States.

We provide financial advice, insurance, and wealth and asset management solutions for individuals, groups and institutions.

At the end of 2022, we had more than 40,000 employees, over 116,000 agents, and thousands of distribution partners, serving over 34 million customers.

At the end of 2022, we had $1.3 trillion (US$1.0 trillion) in assets under management and administration, including total invested assets of $0.

4 trillion (US $0.3 trillion), and segregated funds net assets of $0.3 trillion (US$0.3 trillion). We trade as MFC’ on the Toronto, New York, and the Philippine stock exchanges, and under 945’ in Hong Kong.

Manulife is an Equal Opportunity Employer