Migration Architect - Hounslow, United Kingdom - INTEC SELECT LIMITED

INTEC SELECT LIMITED

Verified Company

Hounslow, United Kingdom

3 weeks ago

Posted by:

Tom O´Connor

beBee Recruiter

Migration Architect

Overview:

Our client have a flexible approach to home working but will require weekly trips to their HQ's located in Heathrow.

Role & Responsibilities:

Come up with migration strategy and solution for the onpremises components (Teradata/Informatica) in cloud (AWS PAAS services + Snowflake)
Design, review, and approve all objects that will be part of the database
Establish and maintain meta data standards
Coordinate with the business staff and the warehouse support staff in matters regarding meta data capture and meanings, schema modifications and enhancements
Develop and maintain technical documentation about the data
Coordinate with the ETL specialist on data mappings and conversion rules, and with the DBA for instantiating logical schemas into physical schemas
Enforce applicable standards, policies, procedures, and best practices in the implementation and/or maintenance of ETL mappings
Architect the modern data platforms while leveraging cloud offerings such as AWS/SaaS/IaaS, other tools, tableau, Power BI
Create and maintain data definition language (DDL) that can be used to create and update the database

Essential Skills and Experience:

Proven experience as an Enterprise Data Vault Architect
Proficiency in the ETL design/development
Solid knowledge of various AWS PaaS services within data and analytics
Experience in migration of data from Legacy to Cloud environments (Migrating Teradata to Snowflake)
Background in data platform/pipeline management and performance optimisation
Ability to perform all the skills required for data warehouse design, implement and monitor.
Familiarity with designing and delivering data and analytics solutions for an enterprise which aligned to business drivers, architecture principle, and security policies.
Familiarity with a data strategy for enterprise and data management
Working experience of the Data Vault Model
Experience with Snowflake Data Warehouse projects

Package: