1st Executive are recruiting on behalf of a global, market leading FTSE100 manufacturing organisation, seeking an ETL Data Hub professional to join their organisation and create concepts and expand solutions so they are fit-for-purpose. This is during a significant transformation programme across the business, with this programme focusing on the movement of data from legacy, diseparate data sets to delivery partner resources.

Role Description:

• This is a project based role having responsibilities for Informatica Development and Administration platforms (Informatica 9.6 and above), ETL mappings, workflows and Informatica Data Quality.
• We are looking for a lead on Data Hub concepts and expanding the current solution to meet the new project requirements.
• Experience of creating REST/aPI interfaces, as well as integration methodologies is key to this role.
• This position is a combination of hands on Informatica development, administration, with external implementation partner teams.
• The position requires strong experience in Data Warehouse and data integration. The role requires good knowledge of master data management, in depth understanding of data warehouse concepts, methodologies including dimensional modelling, metadata management, data marts, slowly changing dimensions, change data capture, error recording and audit reporting from metadata repository.
• The position requires excellent collaboration and communication skills as the candidate will be working closely with the business users, different IT groups, offshore teams, implementation partners and leadership teams.

Mandatory Skill Requirements (Personal):

• Highly experienced in multitasking and managing multiple high priorities.
• Strong analytical, critical thinking and problem-solving skills.
• Effective in a team setting or as individual contributor
• Strong communication skills
• Ability to develop documentation and presentations for technical and management purposes

Mandatory Skill Requirements (Technology):

• Data Hub Design principles and evidence of similar projects
• Informatica PowerCenter 9.6 or above 5 years' experience in design and development of complex mappings, transformations, sessions and workflows in Informatica
• Data Modelling Experience using ER/Win / IDERA ER/Studio
• Oracle Database Skills

Optional Skill Requirements (Technology):

• Using JIRA for project activities and tasks