Avensys is a reputed global IT professional services company headquartered in Singapore. Our service spectrum includes enterprise solution consulting, business intelligence, business process automation and managed services. Given our decade of success, we have evolved to become one of the top trusted providers in Singapore and service a client base across banking and financial services, insurance, information technology, healthcare, retail and supply chain.
We are currently looking to hire a Historical Data Migration Architect. This is an exciting opportunity to expand your skill set, achieve job satisfaction and work-life balance. More details as below.
ROLES AND RESPONSIBILITIES
Strategy & Planning
- Define and own the end-to-end Data Migration Strategy, including scope, approach, tooling, timeline and resource plan aligned to the overall programme schedule.
- Conduct legacy system assessment and data landscape analysis to identify volumes, complexity, data quality gaps and migration risk.
- Establish the Data Migration Governance Framework, including RACI, escalation paths, data sign-off protocols and cutover decision gates.
- Develop and maintain the Migration Project Plan (MPP), tracking progress against key milestones including mock migrations and dress rehearsals.
- Define data retention, archiving and disposal policies for historical records not migrated into Oracle HCM Cloud.
Design & Architecture
- Lead data mapping workshops with HR, Payroll and IT SMEs to produce comprehensive source-to-target mapping documents covering all HCM data objects (Core HR, Absence, Talent, Payroll Balances, Position, Assignment History, etc.).
- Design Oracle HCM Cloud HDL (HCM Data Loader) and HSDL (HCM Spreadsheet Data Loader) templates for all in-scope data objects, accommodating legacy data structures and transformation rules.
- Architect the historical data migration approach for payroll balance migration, ensuring year-to-date, period-to-date and statutory balances are accurately converted.
- Define data cleansing and enrichment rules, working with the client's HR Operations team to remediate systemic data quality issues prior to migration.
- Establish a robust data reconciliation and audit framework to validate migrated data against source systems.
Execution & Delivery
- Lead and manage a team of Data Migration Analysts and ETL developers through iterative extraction, transformation, loading and validation cycles.
- Oversee development of extraction scripts, transformation logic and HDL load programs, ensuring alignment with Oracle best practices and client IT standards.
- Plan and execute multiple mock migration cycles (typically 3-5), conducting lessons-learned reviews and continuous improvement of migration artefacts between cycles.
- Manage data migration cutover activities including freeze dates, delta extraction, final load sequencing, rollback procedures and go-live validation.
- Coordinate with Oracle Support and Accenture Oracle CoE to resolve data load errors, HDL exceptions and system-specific configuration issues.
- Produce and maintain a comprehensive Data Migration Artefact Library: strategy, mapping specs, transformation rules, DQ reports, sign-off logs and reconciliation evidence.
Stakeholder & Programme Management
- Serve as the primary point of contact for all data migration matters with client senior stakeholders, including HR Directors, CIO, and Data Protection Officers.
- Provide regular migration status reporting to the Programme Board, including RAG status, volume metrics, DQ KPIs and key risk/issue updates.
- Facilitate data sign-off workshops with business owners to obtain formal approval of migrated data prior to go-live.
- Collaborate with Oracle Functional Leads (Core HR, Payroll, Absence, Talent) to ensure migration sequencing respects functional dependencies.
- Manage third -party supplier relationships where legacy data extraction is performed by incumbent system vendors.
Quality, Risk & Compliance
- Maintain and actively manage the Data Migration Risk Register, ensuring all risks have mitigation plans and owners.
- Ensure all data handling practices comply with GDPR, public sector data governance frameworks, and client-specific information security policies.
- Apply data quality scoring methodologies to baseline and track improvement in data completeness, accuracy, consistency and uniqueness across all migration objects.
- Coordinate with the client's internal audit and data assurance teams to provide evidence of data integrity throughout the migration lifecycle.
- Support post-go-live hypercare activities including data correction, balance adjustments and retrospective historical record validation.
WHAT'S ON OFFER
You will be remunerated with an excellent base salary and entitled to attractive company benefits. Additionally, you will get the opportunity to enjoy a fun and collaborative work environment, alongside a strong career progression.
To submit your application, please apply online or email your UPDATED CV in Microsoft Word format to [Confidential Information]. Your interest will be treated with strict confidentiality.
CONSULTANT DETAILS
Consultant Name: Keerthana Ramakrishnan
Avensys Consulting Pte Ltd
EA License 12C5759
Privacy Statement: Data collected will be used for recruitment purposes only. Personal data provided will be used strictly in accordance with the relevant data protection law and Avensys privacy policy.
