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.

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.

Students will connect directly with us for guidance and mentorship throughout the project.