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 fieldsExperience : At least two to three years of relevant experience in IT Role / OperationsHybrid 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 :Informatica Data Integration Hub (DIH)Informatica Test Data Management (TDM)Other tool : Informatica 10.x including Designer, Workflow Manager, Workflow Monitor and Repository ManagerNice 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 skillsLet'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 .