Build ERP Data Integration Pipelines
Design and develop scalable ETL/ELT pipelines to ingest and transform data from enterprise systems including:
•
Sage ERP (e.g., Sage X3, Sage Intacct, Sage 300)
•
Oracle ERP / Oracle Fusion
•
SaaS ERP platforms such as NetSuite
•
Legacy ERP and adjacent enterprise systems
Implement transformation pipelines using SQL and Python.
Implement Data Harmonization Logic
Design and maintain data harmonization frameworks that standardize enterprise datasets across systems.
Define and implement cross-system mapping rules for enterprise data domains including:
•
Customers / Business Partners
•
Cost Centers and organizational structures
•
Financial and operational transactions
Design Enterprise Data Models
Develop canonical enterprise data models that normalize ERP data across heterogeneous systems.
Implement logical and physical models supporting:
•
Relational data platforms
•
Dimensional analytics models
•
Enterprise semantic layers
Translate Functional Requirements into Data Logic
Work closely with ERP functional teams and Functional Data Experts (FDEs) to translate business rules into technical implementations.
Convert functional requirements into:
•
Python-based processing pipelines
•
Validation and reconciliation frameworks
Improve Data Quality and Governance
Implement data validation, reconciliation, and monitoring frameworks.
Identify and resolve enterprise data issues such as:
•
Inconsistent definitions across ERP systems
•
Incomplete or legacy datasets
•
Configuration-driven inconsistencies