Can we create a table or manage the schema in athena using AWS Data migration service.

Hello.

You cannot query DMS directly in Athena.
For example, if you set the DMS target to S3 and can output data in CSV or Parquet format, I think it is possible to set up queries for that data with Athena.
Basically, it seems possible to output in CSV, so you should be able to do things like query S3 with Athena.
https://docs.aws.amazon.com/dms/latest/userguide/CHAP_Target.S3.html

I think the following documents will be helpful for creating Athena database.
https://docs.aws.amazon.com/athena/latest/ug/getting-started.html