Hi,
I am a Java developer with extensive practical experience in Data Integration projects building ETL (Extract, Transform and Load) jobs using open-source tool 'Talend for Data Integration', which is a code generator tool that builds Java programs out of workflow and data flow designs.
Also, hands-on experience working with Amazon MWS APIs.
For this project, I can develop a master ETL job that will:
- Read source list of UPCs
- For each UPC code from your list
-- Make request to Amazon API to retrieve corresponding ASIN code(s)
-- Replicate row for each ASIN code
- Generate a CSV file as output.
- Orchestrate all steps above.
Deliverable will be a packaged Java program that can be scheduled daily or even run on demand.
PS. I am able to achieve the same workflow explained above writing Python methods and scripts, but it tends to take longer.
Look forward to hearing from you.
Kind regards,
Yordan B