Create an ETL solution with Altova MapForce for 4 disparate systems

  • Posted:
  • Proposals: 2
  • Remote
  • #687889
  • Expired
Lucy S.Aamir K. have already sent a proposal.
  • 1

Description

Experience Level: Expert
Estimated Job duration: 3 - 4 weeks
General information for the business: We are integrating systems that have contact information for Leads Processing
Description of requirements/functionality: This is an Extract-Transform-Load (ETL) solution.

I need a Level Of Effort in one of the following buckets of hours: {8 | 16 | 40 | 80 | more than 80}
to use the Altova MapForce tool (http://www.altova.com/mapforce.html) to move data between

Sys 1 & Sys 2
Sys 1 & Sys 3
Sys 1 & Sys 4

The following will be given:
1. the data schema and mappings of all systems
2. the most data of any one system is 10 fields
3. Sys 1, Sys 2 and Sys 3 are SQL Server
4. Sys 4 is a REST API serving JSON or XML

Sys 1 = SalesLogix/Eventix
Sys 2 = Umbraco Contour Forms
Sys 3 = Live Chat
Sys 4 = Call Rail

Once the mapping is done, the executable will be run from a Windows Task Schedule.

Also - let me know if this is something you have done before or if you/team member needs to become educated on the tool.
Specific technologies required: XML, Altova MapForce, .Net
OS requirements: Windows
Extra notes: Given the MapForce tool, it should not matter what the endpoints are. I am in need of someone who can use the tool to connect the fields of the systems and transform the data when necessary.

I know that a pro in the MapForce tool would be able to get through a mapping in about 4 hours. The entire job should be able to be done in 16-20. I would like to hear from the pros if I am correct...or if I better budget higher.

New Proposal

Create an account now and send a proposal now to get this job.

Sign up

Clarification Board Ask a Question

    There are no clarification messages.