ETL application design and development

Closed
InnC LLC
West Windsor Township, New Jersey, United States
Priyanka Khati
Founder and CEO
(4)
3
Preferred learners
  • Anywhere
  • Academic experience
Categories
Information technology Software development Databases
Skills
application development restful api systems architecture transformation rules extract transform load (etl) user interface (ui) wordpress
Project scope
What is the main goal for this project?

We are looking to develop a desktop or web-based ETL application that would extract data from one Wordpress database (preferably using REST API), transform the data as per configurable criteria, and then write it to another Wordpress database. This ETL process then would run either on schedule or triggered by an event. The application will have following functionality.

- User interface to identify the records.

- User interface to configure transformation rules

- Ability to execute ETL process on schedule.

What tasks will learners need to complete to achieve the project goal?

This project would entail following activities.

  • Application requirement gathering.
  • Identification of technologies that are based suited for this application.
  • Software architecture modeling, highlighting key components, software, patterns and anything else needed.
  • Software application development, and testing.
  • Implementation planning.

The final deliverables would include

  • A detailed report which captures our Application requirements, proposed system architecture and the tools to be used.
  • Working ETL application with user interface for setting transformation rules.
  • Test Cases and test result.
  • Implementation plan including a list of integrations with internal or external systems.

About the company

InnC stands for Innovation Connect. InnC offers Technology-based platforms as Services that aim to connect producers and providers with consumers.