Hi,
I am a developer with extensive experience working in Data Integration projects, and I know the challenges involved in the matching, merging and conforming of disparate data sources.
For this project, I can develop a master ETL job using a productivity tool named 'Talend for Data Integration', which is a Java code generator that builds programs out of workflow and data flow designs.
* ETL: Extract, Transform and Load
My approach:
1. Read input rows from source .dbf file
2. Read reference rows from source Excel file
3. Join input rows (main data flow) with reference rows using matching fields via Lookup operation
4. Append 4 columns from reference to main data flow
5. Export updated rows in main data flow as .dbf file.
Deliverable is a master job that orchestrates all steps above.
This is a packaged Java program that can be scheduled or run on demand, and also you can pass parameters on
Looking forward to hearing from you.
PS. I am an Australian resident currently living in Melbourne.
Kind regards,
Yordan B