Informatica Production Support Developer

Manulife; Toronto; Hybrid; CAD 70,000 - 95,000; Full time

Job summary

A leading financial services group is seeking an Informatica Production Support Developer for their Platform Services team in Toronto. This role involves troubleshooting and supporting various Informatica applications while ensuring compliance with best practices. Ideal candidates will possess strong SQL troubleshooting skills and a background in Informatica, along with a Bachelor's degree in a related field. This position offers a hybrid work model requiring adaptability to onsite and remote work environments.

Qualifications

• At least two to three years of relevant experience in IT Role / Operations.
• 5 years of experience with Informatica PowerCenter, including version 10.x.
• Knowledge of CAW batch or similar scheduling agent.

Responsibilities

• Analyze and Debug Informatica ETL Transformation and embedded SQL code.
• Participate in platform upgrades and maintain Platform Support documentation.
• Provide On-Call support as part of On-Call rotation.

Skills

Customer service

Troubleshooting SQL queries

Problem solving

Teamwork

Communication

Education

Bachelor’s Degree in Computer Science

Tools

Informatica PowerCenter

PERL

UNIX

Job description

We’re looking for an Informatica Production Support Developer to join our Platform Services team at MBPS. In this role, you are expected to provide KLO and troubleshooting support for over 50 Informatica applications in two separate informatica environments.

Have the skills and knowledge for the job? Learn more about the opening below!

Key Responsibilities :

• 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 and provide consulting services and guide on proper and preferrable use of Informatica Transformations best practices; follow and enforce code management.
• Participate in platform upgrades, create / maintain / update Platform Support documentation on processes, policies, application configuration and help related materials for users as database applications are developed or as needed and create / maintain Runbooks and other related documentation; act as one of primary contacts for Informatica PowerCenter (Analyze 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)
• Be available to work off-hours and extended shifts if required, provide On-Call support as part of On-Call rotation within Platform Support team.
• Proactive ownership of incidents-issues until resolution, logging and tracking identified system problems through resolution.
• Building effective working relationships with internal and external resources, technology vendors and outsourcing service providers and Interfaces with IS groups, strategic vendor partners, and other Business Units, peers, IS Managers, Directors, and AVPs.

Qualifications :

• Education : Bachelor’s Degree in Computer Science, Information Technology, or related fields
• Experience : At least two to three years of relevant experience in IT Role / Operations
• Hybrid Work Arrangement : Amenability and readiness to work onsite and from home anytime (dependent on business need AND / OR current external environment / situation)
• Shift Schedule (Fixed Night Shift) : Amenability to work on the assigned schedule (dependent on business need)
• Minimum Skills to Hire / Must Haves : 5 years of experience with Informatica PowerCenter, including version 10.xMust be able to read, analyze and write PERL or UNIX script.Must have experience troubleshooting SQL queries, including stored proceduresKnowledge of CAW batch or similar scheduling agentKnowledge of at least one of the Informatica tools is a great plus :
• Other tool : Informatica 10.x including Designer, Workflow Manager, Workflow Monitor and Repository Manager
• Nice to Have Skills : Strong customer service and interpersonal skills such as teamworkStrong written, verbal, and presentation skillsAbility 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 deadlinesCandidate must demonstrate problem solving skills

Let's make every day better together. Learn about our opportunities at JOBS.MANULIFE.COM

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

At Manulife / JohnHancock, we embrace our diversity. We strive to attract,developandretaina 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 toprovideequal 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 withapplicable laws and Manulife / John Hancock policies.To request a reasonable accommodation in the application process, contact .

Create a job alert for this search