Job Title:
Informatica PowerCenter Developer
About the Job:
We are seeking an experienced Informatica PowerCenter developer to join our team. The ideal candidate will have a strong background in software development, with a focus on data integration and ETL processes.
2. 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).
3. 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.
4. Proactive ownership of incidents-issues until resolution, logging and tracking identified system problems through resolution.
5. 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:
1. Education: Bachelor's Degree in Computer Science, Information Technology, or related fields.
2. Experience: At least two to three years of relevant experience in IT Role/Operations.
3. Hybrid Work Arrangement: Amenability and readiness to work onsite and from home anytime (dependent on business need AND/OR current external environment/situation).
4. Shift Schedule (Fixed Night Shift): Amenability to work on the assigned schedule (dependent on business need).
5. Minimum Skills to Hire/Must Haves:
o 5 years of experience with Informatica PowerCenter, including version 10.x.
o Must be able to read, analyze, and write PERL or UNIX script.
o Must have experience troubleshooting SQL queries, including stored procedures.
o Knowledge of CAW batch or similar scheduling agent.
o Knowledge of at least one of the Informatica tools is a great plus:
+ Informatica Data Integration Hub (DIH)
+ Informatica Test Data Management (TDM)
+ Other tool: Informatica 10.x including Designer, Workflow Manager, Workflow Monitor, and Repository Manager
6. Nice to Have Skills:
o Strong customer service and interpersonal skills such as teamwork.
o Strong written, verbal, and presentation skills.
o Ability to effectively communicate, cooperate, and collaborate; ability to lead and influence technical peers and decision makers.
o 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.
o Candidate must demonstrate problem-solving skills.
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.