ERROR 1227 (42000) : Access denied; you need (at least one of) the SUPER privilege(s) for this operation
This error happens on restoring the dump file to RDS as the cloud service doesn't provide the super user privileges. But we can resolve this by doing a simple hack on dump file.
#sed -i 's/DEFINER=[^*]*\*/\*/g' dump.sql
Where dump.sql need to be replaced with the dump file name.
We can able to import the dump to RDS without any issues now.