Remote Data Migration Consultant: Salesforce ETL Expert

MTX APAC; City of Melbourne; Hybrid; AUD 90,000 - 130,000; Full time

Benefits offered by this job

Remote work flexibility

Health insurance discounts

Employee Assistance Program

Paid training and development

Monthly All Hands meetings

Job summary

MTX APAC is seeking a Data Migration Consultant to profile, map, transform, load and reconcile data across migration cycles within Salesforce environments. You will own the data domains assigned to you, work with source data, business rules and the Salesforce target model, raising issues early to act on them.

As part of a global cloud technology consulting firm with a focus on government and public sector, you will contribute to data quality, perform mappings and validation, and support

Qualifications

• Practical experience in data migration, conversion, ETL, analysis or data engineering.
• Experience with Salesforce data loading or comparable CRM migration activities.
• Working SQL knowledge and confidence manipulating, validating and reconciling structured data.
• Experience producing source-to-target mappings and transformation rules.
• Strong attention to detail and a systematic approach to investigating data issues.
• Clear communication skills and the ability to work effectively within a multidisciplinary delivery team.
• Experience with Salesforce Data Loader, Workbench, Bulk API or comparable tools.
• Experience with Python, PowerShell, MuleSoft, Informatica, Talend or Azure Data Factory.
• Knowledge of Salesforce relationships, external IDs, automation and security.
• Consulting or regulated-industry experience in Australia.

Responsibilities

• Profile source data to identify structure, volume, quality, anomalies and referential integrity issues.
• Support workshops to confirm data definitions, mappings, transformation rules and ownership.
• Maintain source-to-target mappings, data dictionaries, rule catalogues and issue logs.
• Work with data owners to resolve duplicates, invalid values, gaps and quality concerns.
• Develop or support extraction, transformation and load routines using approved tools and scripts.
• Prepare load files and sequence Salesforce objects while preserving relationships and external identifiers.
• Execute controlled loads across development, test, rehearsal and production environments.
• Investigate failed records, correct defects and maintain repeatable rerun processes.
• Complete record-count, field-level, relationship and exception reconciliation after each cycle.
• Familiarity with the common checksum approaches including MD5.
• Maintain run logs, reconciliation reports, defect evidence and migration outcomes.
• Support mock migrations, cutover planning, production migration and hypercare.
• Provide accurate progress updates and communicate data, access or environment blockers early.

Skills

Data migration

ETL

SQL

Data analysis

Data mapping

Communication

Tools

Salesforce Data Loader

Workbench

Bulk API

Python

MuleSoft

Informatica

Talend

Azure Data Factory

Job description

MTX APAC is seeking a Data Migration Consultant to profile, map, transform, load and reconcile data across migration cycles within Salesforce environments. You will own the data domains assigned to you, work with source data, business rules and the Salesforce target model, raising issues early to act on them.

As part of a global cloud technology consulting firm with a focus on government and public sector, you will contribute to data quality, perform mappings and validation, and support