Microsoft ETL tools support generating the data pipelines/ETL/ELT workflows programmatically through their REST API. Is there any such feature on Matillion where I could achieve similar thing?
Yes, it should be possible. Matillion under the hood generates a JSON file to create your Orchestration and transformation jobs. You can programatically update the JSON file to add new jobs