Data Engineer (Consulting)

Executive recruitment company Monroe Consulting Group Indonesia is recruiting on behalf of a leading global business consulting group. We are seeking a skilled and experienced Oracle Data Migration Specialist to join our client's team. The successful candidate will be responsible for executing data migration projects, specifically focused on transferring data from various sources to Oracle databases. This role requires a deep understanding of Oracle database architecture, strong technical expertise in data migration methodologies, and the ability to collaborate effectively with cross-functional teams.

Key Responsibilities:

  • Plan and Execute Data Migration Projects: Lead end-to-end data migration projects from planning and assessment through to execution and validation. Develop comprehensive migration strategies and timelines to ensure successful migration of data to Oracle databases.
  • Data Analysis and Mapping: Analyze source data structures and business requirements to develop data mapping and transformation rules. Ensure accurate mapping of data elements between source and target systems, taking into account data integrity and quality standards.
  • Technical Implementation: Utilize Oracle Data Integrator (ODI), SQL Loader, or other relevant tools to perform data extraction, transformation, and loading (ETL) tasks. Write and optimize SQL scripts and PL/SQL procedures to facilitate data migration processes.
  • Quality Assurance & Testing: Conduct thorough testing of migrated data to validate completeness, accuracy, and integrity. Develop and execute test plans, perform data reconciliation, and troubleshoot issues to ensure successful migration outcomes.
  • Documentation and Reporting: Create detailed documentation of migration processes, including data mapping documents, migration scripts, and test results. Generate progress reports and provide regular updates to stakeholders on project status and milestones.
  • Collaboration and Communication Work closely with cross-functional teams, including database administrators, developers, business analysts, and project managers, to align on migration requirements and timelines. Communicate effectively with stakeholders to address concerns, provide updates, and ensure project success.


  • Bachelor's degree in Computer Science, Information Technology, or related field.
  • Minimum of 2 years of experience in Oracle database administration, data migration, or related roles.
  • Proficiency in Oracle database technologies (e.g., Oracle Database, Oracle Data Integrator).
  • Strong SQL and PL/SQL programming skills, with experience in writing complex queries and procedures.
  • Hands-on experience with data migration tools and techniques, such as Oracle Data Pump, SQL Loader, or similar tools.
  • Excellent analytical and problem-solving abilities, with a keen attention to detail.
  • Effective communication and interpersonal skills, with the ability to collaborate with diverse teams and stakeholders.
  • Proven track record of successfully leading data migration projects from inception to completion.