Backend Automation Testing

Job ID: 35964682

Budget: $30 – $250 USD

Create a Selenium Java project based on the detail below:
The script should be able to read data from Oracle SQLDeveloper database for all the new records being posted to data base and match them with the data saved in excel sheet and gives the success output.
After successful data match in the database and excel sheet
The script should be able to read the message from Kafka topic producer about the record being confirmed in database and print out the success statement.
After kafka topic is being read the script should be able to view the subsequent log in Rancher or Splunk.

Due to business nature no actual data will be provided. Just write a script which can perform all the task without any breakthrough. Once the script is submitted it will be executed in real time environment and if any compatibility issues encountered , your support will be needed to trouble shoot that. After only the script being executed successfully in the real project will be considered as the delivery of project.
Required Tools: Eclipse, Selenium, Java, Cucumber, Kafka, Rancher , Splunk, TestNG
The pom.xml file should have all up to date dependencies using Maven.
NO GRADLE PROJECT please.
Looking for the clarity of code which is easy to understand and simple and comments.
The max time for this project to be delivered is within 3 days – 24 hours – 8 hours per day once started.