A processor-implemented method for synchronizing and reconciling data stream in real-time between an edge node and a cloud node is provided. The method includes (i) generating classified data by classifying data of the data stream that is obtained from a plurality of edge nodes in real-time to synchronize in a location at a plurality of cloud nodes, (ii) synchronizing the classified data in the plurality of cloud nodes by detecting a first location and a type of database in the plurality of cloud nodes and storing the classified data in the first location in the plurality of cloud, (iii) replicating the classified data in a plurality of second locations in the plurality of cloud nodes, and (iv) receiving, from the plurality of edge nodes, a request signal for synchronizing the classified data from the plurality of cloud nodes to the plurality of edge nodes when the first location in the plurality of cloud nodes fails to transfer the classified data during a transaction.