I am Azure Data engineer and mainly use Azure Data factory to ingest the data and t-sql to transform/process the data in my day to day job.