This Job Vacancy has Expired!

Data Migration Architect

Posted on Sep 26, 2020 by SidTech LTD

Zürich, Switzerland
Immediate Start
Annual Salary

Data Migration Architect


Has at least 10-12 years of experience in ETL based Data Migration projects (preferably in Core Banking or any other large data migrations)

Hands on experience in Informatica ETL development. Should be Hands-on with PWX and Performance tuning for extracting large volume data.

Secondary skills - Informatica Power exchange and DB2

Proven experience in handling data migration projects (using ETL based solution) in Architect capacity

Able to translate business needs into Technical requirements

Excellent communication and listening skills

Having prior working experience of Customer interfacing role

Able to provide thought leadership to the DM team

Flexible to travel onsite for long term

Job Description:

- Responsible for E2E Data Migration Solution for the UBS RIGI program using existing Central Migration Framework (Informatica Powercenter and PWX)

- Drive Knowledge transition sessions on existing Framework from incumbent vendor

- Participate in workshops to understand the migration volumes, sources and transformation needs

- Provide overall architecture of ETL solution and plan for Data migration execution

- Participate in DM strategy discussions and implementation planning

- Gather business cleansing and data validation requirements by working with Business SMEs, Client Migration Lead

- Gather Business inputs for data reconciliation, validation and auditing requirements

- End to end ownership of data objects starting with source data extraction till target system uploading

- Understand the data selection criteria, source-target mappings, data transformation/conversion logic

- Hands-on in Informatica Development using PWX connectors for DB2 Mainframe databases

- Identifying data gaps and designing system logic/approach to generate missing data

- Responsible for Performance tuning using Advance tuning features in PWX

- Define Migration Cutover Strategy & Load Schedule along with Client Migration Lead

- Gain input and acceptance from Client governance IT and business data, process and technical owners during design phase of new/changed requirements

- Run review meetings with the Client stakeholders and provide updates on achieving optimization and industrialization targets

- Responsible for timely delivery of phase wise Project Deliverables

Must to have

Informatica Power centre V10 ( min )experience with Informatica Power exchange and DB2 as secondary skill.

Reference: 957347565

Set up alerts to get notified of new vacancies.