Data Extraction and Transformation Consultants
Axia Metrics
|
Industry |
Retail |
|
Location |
Auckland, New Zealand |
|
Engagement type |
Time & Materials contract; work and allocation subject to client demand and staffing confirmation |
|
Resource requirement |
2 consultants planned for Release 1; later release staffing indicative |
|
Expected start |
March 2027 |
|
Expected duration |
Program horizon: March 2027 to September 2029. Assignment periods and effort are indicative; no continuous or full-time allocation is guaranteed. |
|
Work arrangement |
Hybrid — remote delivery with mandatory on-site presence as required |
1 Role Overview
We are seeking two experienced Data Extraction & Transformation Consultants to support a large-scale Oracle Retail Cloud transformation program for a major retailer in New Zealand. The consultants will extract, transform, validate, and prepare data from the customer’s legacy applications for migration into Oracle Retail Cloud Services. The engagement is on a Time & Materials basis, with work and allocation confirmed against client needs.
The role centers on legacy data extraction and transformation rather than Oracle Retail application implementation or configuration. The customer’s technical teams will provide knowledge of legacy systems, including database structures, business rules, and source application functionality. Release 1 is expected to require predominantly full-time allocation for two consultants, subject to client demand, actual consumption, and staffing confirmation. Later release support may be provided by one of the same consultants per release, if required and available; continuity is not guaranteed.
2 Key Responsibilities
Data Extraction and Transformation
• Analyze legacy data structures, relationships, and dependencies with the customer’s technical teams.
• Design, develop, and maintain SQL-based extraction scripts and ETL processes.
• Extract transactional and operational data from legacy retail applications, including sales transactions, inventory positions, stock movements, and historical datasets.
• Transform extracted data into agreed structures and formats for downstream Oracle Retail data loading.
• Implement approved data cleansing, normalization, enrichment, and validation rules.
• Develop reusable, maintainable components for multiple migration cycles.
• Implement full and incremental extraction, including delta mechanisms where applicable.
• Optimize extraction for performance, reliability, and large data volumes.
Data Conversion and Migration Support
• Work with Oracle Retail functional and technical consultants to understand target data requirements and conversion specifications.
• Support source-to-target mapping and document transformation logic.
• Prepare datasets to agreed conversion templates, formats, and loading specifications.
• Support initial loads, mock conversions, migration rehearsals, and production cutover.
• Investigate and resolve extraction and transformation issues found during testing and migration.
• Identify data dependencies, extraction sequencing, and migration prerequisites.
• Assist with reconciliation and issue resolution during System Integration Testing (SIT) and User Acceptance Testing (UAT).
Data Quality and Reconciliation
• Identify missing, duplicate, inconsistent, or invalid records through data quality checks.
• Develop reconciliation mechanisms for completeness and accuracy, including record counts, control totals, and balances where applicable.
• Produce exception reports, error logs, and data quality summaries.
• Investigate discrepancies with customer business and technical teams.
• Maintain traceability and auditability of extraction and transformation processes.
Technical Documentation and Best Practices
• Document extraction logic, transformation rules, mappings, and execution procedures.
• Maintain technical specifications and operational runbooks.
• Follow coding standards, version control, and change management procedures.
• Implement error handling, logging, and recovery mechanisms.
• Make extraction processes repeatable, testable, and maintainable.
• Apply data security and confidentiality requirements to customer information.
• Support knowledge transfer and handover.
Collaboration and Project Delivery
• Work closely with customer teams responsible for legacy applications and with Oracle Retail consultants, architects, and migration leads.
• Participate in workshops, design reviews, migration planning, and issue resolution.
• Provide progress updates and identify technical risks, dependencies, and delays.
• Support project governance, documentation, and reporting requirements.
• Participate in on-site activities when required.
3 Required Qualifications
• Bachelor’s degree in Computer Science, Information Technology, Engineering, or equivalent professional experience.
• At least 4 years of experience in data extraction, ETL development, transformation, or enterprise data migration.
• Strong SQL development skills and experience with Oracle Database, SQL Server, PostgreSQL, or comparable relational databases.
• Experience developing extraction and transformation scripts in SQL, PL/SQL, T-SQL, Python, or equivalent technologies, and practical experience with ETL tools or frameworks.
• Strong understanding of relational models, database structures, and data dependencies; experience with large transactional datasets.
• Experience with data cleansing, validation, reconciliation, and exception handling.
• Familiarity with enterprise migration methods, mock conversions, and production cutover.
• Strong analytical, troubleshooting, and problem-solving skills; ability to work independently and with distributed teams.
• Excellent written and verbal communication skills in English.
• Willingness and ability to travel to New Zealand and work on-site at the customer’s premises in Auckland as required throughout the engagement.
• Availability to collaborate during New Zealand business hours.
4 Preferred Qualifications
• Experience in retail, ERP, or large-scale enterprise transformation programs.
• Understanding of retail data such as sales, inventory, stock movements, merchandise hierarchies, products, and suppliers.
• Familiarity with Oracle Retail applications, including MFCS, RDS, SIOCS, MFPCS, APCS, IPOCS, AIF, and RI.
• Experience with Oracle Data Integrator, Oracle Integration Cloud, or comparable ETL and integration technologies.
• Experience with custom-built legacy applications, Oracle Retail conversion templates, and standard data loading mechanisms.
• Experience with high-volume batch processing, performance optimization, and multi-release programs.
5 Expected Deliverables
The consultants will produce and maintain the following deliverables, as applicable to each release:
• Documented extraction and transformation specifications and source-to-target mappings.
• Reusable SQL and ETL scripts and extracted, transformed datasets aligned to agreed loading specifications.
• Data quality validation, reconciliation reports, exception logs, and issue-resolution records.
• Execution procedures, technical runbooks, and knowledge transfer materials.
• Support for migration rehearsals, testing cycles, and production cutover.
6 Project Timeline and Resource Requirements
This Time & Materials engagement is planned across three releases. Release 1 is expected to involve predominantly full-time work for two consultants, subject to client needs, actual consumption, and confirmed staffing. Release 2a and Release 2b represent indicative, targeted effort in line with the release plan. Each may be supported by one of the same two consultants, if required and available, without a commitment to continuous assignment.
|
Release |
Expected start |
Indicative staffing |
Estimated effort |
|
Release 1 — Core Retail Implementation |
March 2027 |
2 consultants; predominantly full-time expected, subject to demand and confirmation |
960 person-days (estimate) |
|
Release 2a — Planning and Optimization |
2028 |
Potentially 1 of the same consultants, if required and available |
159 person-days (estimate) |
|
Release 2b — Assortment Planning |
2028 |
Potentially 1 of the same consultants, if required and available |
120 person-days (estimate) |
|
Total |
March 2027–September 2029 |
Staffing and continuity not guaranteed |
1,239 person-days (estimate) |
The estimates total 1,239 person-days across the releases: 960 for Release 1, 159 for Release 2a, and 120 for Release 2b. These are planning estimates, not guaranteed work volumes. The March 2027 to September 2029 period describes the program horizon; it does not guarantee full-time allocation, uninterrupted work, or retention of either consultant throughout that period. Assignments and staffing will be confirmed as the client’s plan and demand develop.
7 Location and Travel Requirements
The hybrid delivery model combines remote work with on-site presence at the customer’s premises in Auckland, New Zealand. Candidates may be based in New Zealand or offshore if they can meet the working arrangements. Travel and on-site work in Auckland are mandatory when required.
On-site assignments may support technical workshops, extraction planning, collaboration with customer teams, migration rehearsals, validation, SIT and UAT, production cutover, go-live, and knowledge transfer. Frequency and duration will depend on project needs. Candidates must be available during New Zealand business hours.
8 Additional Considerations
• The customer will provide knowledge of legacy applications, including data structures, business rules, and source system functionality.
• The consultants’ primary focus is legacy data extraction and transformation. Oracle Retail configuration and implementation are outside the roles’ primary responsibilities.
• Oracle Retail experience is beneficial but not mandatory.
• All release effort and staffing are indicative under the Time & Materials contract; work is confirmed against client demand, actual consumption, and availability. No full-time or continuous assignment is guaranteed across the program.
• Candidates should be able to work with unfamiliar legacy technologies and customer-specific environments.
• Experience delivering extraction and transformation work in structured enterprise implementation programs is highly desirable.
