DR 006/2023
Data Migration Staging Database Specialist (Business Transformation)
Manila (Global) Administrative Centre (MAC)
Open to Internal and External Candidates
Job classification
National Officer
Duty station
Manila (Global) Administrative Centre (MAC)
Type of Appointment
Special Short Term-Ungraded
Closing date
Duration of Assignment
Nine-months w/ possibility of extension
PHp 100,000 per month net of taxes (All-inclusive)

Established in 1951, IOM is a Related Organization of the United Nations, and as the leading UN agency in the field of migration, works closely with governmental, intergovernmental and non-governmental partners. IOM is dedicated to promoting humane and orderly migration for the benefit of all. It does so by providing services and advice to governments and migrants.

IOM is committed to a diverse and inclusive work environment. Internal and external candidates are eligible to apply to this vacancy. For the purpose of the vacancy, internal candidates are considered as first-tier candidates.


IOM is undertaking a Business Transformation (BT) process, a priority driven by IOM’s Internal Governance Framework (IGF). IOM has undertaken a global review of its current support and administrative business requirements and Enterprise Resource Planning (ERP) based process flows to update its systems and establish a fit-for-future set of management methods, policies, controls, processes, and systems globally.

The technology supporting the BT is based on a move to Oracle Cloud ERP, Human Capital Management (HCM), Supply Chain Management (SCM)/Procurement, and Analytics, and away from IOM’s existing SAP ECC6 system, known internally as PRISM.

Under the overall administrative supervision of Director, Manila Administrative Center, the direct supervision of the Data Migration Support Officer (Business Transformation) and, working with the respective BT Stream Leads and Business Analysts, the incumbent will be responsible for working within the MAC-based BT Data Migration Support Unit (DMSU) to directly execute activities as directed to prepare data from existing systems, primarily PRISM, for loading into the target solutions of the Business Transformation.

Core Functions / Responsibilities
  • Collaborate with BT Stream Leads, Business Analysts, SMEs, PRISM Technical Experts, and other subject matter experts to:
    • Define data migration source and target data
    • Determine business rules to transform source data structures and data elements to the required target
    • Define data migration pre and post-load validation reports
    • Address any questions / issues that arise during the design, implementation, testing and running of data migration processes
  • Define and create data structures / tables to store source, target and extracted loaded data in the data migration staging database (RDBMS)
  • Create procedures to import source data into the staging database
  • Create queries and stored procedures to validate and transform source to target data, and report errors
  • Create queries and stored procedures to create output files for load to Oracle
  • Create reports to compare input to output data for pre-load validation; and to ensure traceability, troubleshoot and correct errors as required
  • Create import utilities to import extracts of loaded data exported from Oracle
  • Create reports to compare output data to extracted Oracle data for post-load validation reports; and to ensure traceability, troubleshoot and correct errors as required
  • Support unit testing of data migration processes – importing source data, running transformations, providing output files, providing pre and post-load reports
  • Support all test / mock data migration cycles
  • Support production cutover data migration
  • Coordinate with SAP / PRISM colleagues to obtain data extracts
  • Coordinate with Oracle colleagues to ensure clarity and completeness of data migration templates and to address any questions that may arise
  • Provide technical inputs to data migration team colleagues of detected data quality issues
  • Document data migration scripts / procedures
  • Perform other duties as may be assigned.
  • University degree in engineering, computer science, information management, business, or a related field from an accredited academic institution with four years of relevant professional experience.
  • Experience working in the business/functional domain for the specific position under recruitment;
  • 5 years’ experience working with a relational database management system (RDBMS);
  • Experience with Microsoft SQL Server is an advantage;
  • 3 years’ experience with ERP data migration or supporting a large ERP;
  • Experience working with SAP and/or Oracle ERPs is an advantage;
  • Experience in IOM and using PRISM, with good knowledge of IOM’s current business processes and understanding of the data being managed is an advantage.
  • Ability to design and create tables, import and export data, write queries and stored procedures, transform data, create reports in a relational database management system (RDBMS);
  • Proficiency using MS Excel (mandatory) and managing multiple input and output data formats and structures (Excel, CSV, flat files, XML, JSON)
  • Ability to analyse data and compare data between systems to look for errors/inconsistencies); and,
  • Ability to write/contribute to design documentation.

For this position, fluency in English is required. Knowledge of a second official UN language is desirable.

Inclusion & respect for diversity
  • Shows respect and sensitivity towards gender, culture, ethnicity, religion, sexual orientation, political conviction and other differences.
  • Encourages the inclusion of all team members and stakeholders while demonstrating the ability to work constructively with people with different backgrounds and orientations.
  • Promotes the benefits of diversity; values diverse points of view and demonstrate this in daily work and decision making.
  • Challenges prejudice, biases and intolerance in the workplace.
Integrity & transparency
  • Upholds and promotes the Standards of Conduct and Unified Staff Regulations and Rules.
  • Delivers on commitments; manages the organization’s resources reliably and sustainably.
  • Embraces and encourages transparency, balancing this with the need for discretion and confidentiality as appropriate.
  • Maintains impartiality and takes prompt action in cases of unprofessional or unethical behaviour.
  • Does not abuse one’s position and acts without consideration of personal gain. Is motivated by professional rather than personal concerns.
  • Demonstrates professional competence and mastery of subject matter and willingness to improve knowledge and skills.
  • Seeks to raise professional standards in self and others through daily work and activities.
  • Adapts quickly to change and is decisive and versatile in face of uncertainty.
  • Shows self-control and persistence when faced with difficult problems, and remains calm in stressful situations.
  • Is conscientious and efficient in meeting commitments, observing deadlines and achieving results.
Core Competencies
  • Accepts personal responsibility for quality and timeliness of work.
  • Takes ownership of all responsibilities within own role and honours commitments to others and to the Organization.
  • Operates in compliance with organizational regulations and rules.
  • Accepts and gives constructive criticism; acknowledges and corrects mistakes and apply lessons learned for improvement.
  • Presents information using language and sequence of ideas that is easy for recipients to understand.
  • Adapts communication to the recipient’s needs, asks questions to clarify, and exhibits interest in having two-way communication.
  • Encourages others to share their views, using active listening to demonstrate openness and to build understanding of different perspectives.
  • Listens carefully and genuinely to the views and positions of others; acts on received information.
Managing and sharing knowledge
  • Keeps abreast of new developments in own field of competence and creates opportunities for knowledge management initiatives.
  • Shares knowledge and learning willingly, and proactively seeks to learn from the experiences of others.
  • Puts new learning into practice and draws on diverse sources of ideas and inspiration.
  • Contributes to the identification of improvements to work processes and assists in implementing them.
  • Establishes strong relationships with colleagues and partners; relates well to people at all levels.
  • Is fully aware of the team purpose, respects and understands individual and collective responsibilities.
  • Willingly puts in extra effort without being asked and adopts a "hands-on" approach whenever necessary to achieve team objectives.
  • Coordinates own work with that of the team to meet agreed priorities and deadlines.
Delivering results
  • Produces quality results and provides quality services to clients.
  • Meets goals and timelines for delivery of products or services.
  • Manages time and resources efficiently, monitoring progress and making adjustments as necessary.
  • Shows understanding of own role and responsibilities in relation to expected results.
How to apply

Interested applicants may send their applications to hrmanila@iom.int no later than 27 February 2022. VN Number and Position Title (DR 006/2023 – Data Migration Staging Database Specialist (Business Transformation)) should be specified in the SUBJECT field.

IOM welcomes applicants from qualified individuals, irrespective of their race, religion, skin, color, nationality, age, disability status, ancestry, sex, sexual orientation, gender identity or expression, marital status, family structure, mental health status, or any other characteristic.

Only shortlisted candidates will be contacted and an offer will be made following the confirmation of funding.