Issue with Time Zone while migrating MySQL on-premises DB to AWS RDS
I was using MySQL replication with Mixed mode replication which captures the data with timestamp and timezone.

Later, I changed the MySQL replication to Row based replication which captures the data with time. So what ever the time format it is, it just send the insert/update statements with time, which solved my problem.