Description
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 skillsAbout 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