Senior Data Migration Architect

AVENSYS CONSULTING PTE. LTD.; Singapore; On-site; SGD 140,000 - 190,000; Full time

Benefits offered by this job

Attractive company benefits

Career growth prospects

Fun and collaborative environment

Job summary

Avensys is hiring a Technical Architect to lead enterprise data migration strategy, architecture, and governance. You will design scalable migration solutions, define data integration patterns, and create runbooks for cutover activities across multiple technologies.

We seek 8+ years in data management or large-scale migrations, strong SQL and data modelling skills, and hands-on ETL experience (Azure Data Factory, Informatica, SSIS, Talend, Databricks).

Qualifications

• 8+ years of experience in Data Management, Data Engineering, or large-scale data migrations.
• Strong SQL, database administration, and data modelling knowledge.
• Hands-on experience with ETL tools such as Azure Data Factory, Informatica, SSIS, Talend, or Databricks.
• Experience with SQL Server, Oracle, PostgreSQL, MySQL, or Azure SQL.
• Knowledge of data governance, MDM, data warehousing, and migration activities including profiling, transformation, validation, and reconciliation.
• TOGAF and/or CDMP certifications preferred.
• Strong analytical, problem-solving, and communication skills.

Responsibilities

• Define enterprise data migration architecture and roadmap.
• Develop migration frameworks, standards, and best practices.
• Create source-to-target mapping specifications.
• Design data validation and reconciliation processes.
• Establish migration governance and controls.
• Design scalable and secure migration solutions.
• Define data integration patterns and architecture.
• Perform data profiling and impact assessment.
• Develop migration runbooks and cutover plans.
• Identify dependencies, risks, and mitigation strategies.
• Engage business, functional, and technical stakeholders.
• Present architecture recommendations to senior leadership.
• Collaborate with project managers and solution architects.
• Support performance tuning and optimization activities.

Skills

SQL

Data modelling

Data governance

Analytical skills

Education

TOGAF certification

CDMP certification

Tools

Azure Data Factory

Informatica

SSIS

Talend

Databricks

SQL Server

Oracle

PostgreSQL

MySQL

Job description

Avensys is hiring a Technical Architect to lead enterprise data migration strategy, architecture, and governance. You will design scalable migration solutions, define data integration patterns, and create runbooks for cutover activities across multiple technologies.

We seek 8+ years in data management or large-scale migrations, strong SQL and data modelling skills, and hands-on ETL experience (Azure Data Factory, Informatica, SSIS, Talend, Databricks).