They will interview you with no intention of considering you for the job. I met all the required and preferred qualifications. I even had specific experience in the TMS they use. 1st interview, I didn't get to interview with the hiring manager but with a manager of an adjacent department(red flag). The job posting was also taken down after only being up for a few days(red flag). 2nd interview with hiring manager, he was 10 min late, was on camera in a t-shirt looking like he just rolled out of bed, and seemed very disinterested despite me being very well qualified and having a very successful first interview. They are only considering internal candidates. Do not waste your time.

know well about the company and what are the things you mentioned in the resume be clear about it. be confident while speaking and little bit analytical skill on sql and power bi