MDM Infosphere Expert

Description

1. Must have 5+ years of experience building out IBM Infoshphere MDM (Master Data Management) server applications
2. Must understand how to extract data from DB2 databases using Informatica V9 (ETL) and linking them to the MDM Server
3. Must understand how to code XML (within the MDM process there is a data vault which is built in XML)
JH IS (IIS) is the Information Systems organization supporting John Hancock Insurance business and we are looking for a dynamic, enthusiastic, team oriented Master Data Management Developer who has a passion for solving problems, analyzing data and finding creative technical solutions while always having the customer at the forefront of their thinking. This position requires background and experience in developement and analytical roles, a proven ability to work closely with various stakeholders, and a strong desire to learn what is needed to properly support the business. The successful candidate will work with various business clients to understand and influence the business and technical requirements of the users in order to support their business intelligence needs. The role is responsible for translating business intelligence and analytical requirements and needs into technical data/information management platform ensuring that the user's requirements are clearly understood, communicated and implemented. Develop solutiond to support user functions, procedures, data and information needs through a variety of methods and sources. This role will support the Director Business Intelligence for John Hancock Insurance. Primary responsibilities Collaborate with Data Architects to design and communicate complex data integration requirements. Create and document logical Data Integration (ETL) strategies for data flows between disparate source/ target systems and the Enterprise Data Warehouse. Collaborate with Data Architect, BI Architect and Lead Data Steward to develop a strategy to integrate BI with the corporate ESB and MDM initiatives. Collaborate with the BI team on the development of data acquisition and archive recovery strategies Operational Management Development of customized Data Integration Scripts, run scripts, make changes, monitor production jobs, and automate and schedule jobs Designs and develops customized MDM code based on Specification. Documentation such as Extension and Additions and Lightweight Services. Designs and develops customized MDM services. Designs and develops necessary batch interfaces to and from MDM hub Development of Validation, Quality and Profiling Routines. Work with project teams (Project Managers, QA Analysts, BSAs, Data Architects, Developers, Server Administrators, DBAs, Data Quality Analysts, BI Systems Analysts, and External Vendors) and business representatives to clarify requirements and decide on a technical solution. Troubleshoot systems, and software; work with the DBAs to performancetune these applications as necessary. Facilitate and/ or attend meetings related to projects to provide guidance on best practices and capabilities of the integration systems Collaborates with other team members in the creation, documentation and implementation of flows, data mapping Lead technical discussions impacting solutions and data integration technology Responsible for the analysis of project requirements and the development of technical specifications. Designs and architects the proposed business applications and/or computer systems. Must be able to document and facilitate the augmentation of the MDM skill set. Candidate must have excellent technical and analytical skills. Candidate should also be willing to provide all needed system support.
QUALIFICATIONS At minimum, completion of an undergrad degree in computer science, data management, mathematics, statistics, or recognized equivalent required. Masters preferred. Minimum 8 years practical and related experience, including at least 5 years experience in end to end implementation of MDM solutions and 5 years experience in InfoSphere MDM Server Extension Framework and InfoSphere MDM Server Transaction Suite Experience in data analysis and data management, preferably within in insurance and/or financial services industry Capability in data storage, database design, as well as manipulation, extraction, linking and analysis of data; Prior experience working with data in the insurance or financial services industry; Ability to develop and maintain strong working relationships with partners and colleagues. Advanced knowledge of qualitative and quantitative data collections and analysis techniques, statistics, and database development Knowledge of maintaining and managing external and internal data resources to achieve project goals Strong knowledge and experience with Informatica ETL, data storage functions, SQL, DB2, XML, Linux, mainframe and/or client/server Strong statistical skills, including computational analysis using R and SAS; Strong leadership and management skills and experience. Project management skills and/or experiencing overseeing projects Organizational skills and demonstrated ability to set priorities and meet deadlines; Demonstrated problem solving skills; Excellent verbal and written communication skills; Ability to coordinate and manage large diverse projects and teams; Postion to be located in Boston and/or Toronto, preferably Boston.