CVS Health Data Engineer interview questions

this company has really shady hiring practices none of the jobs that they post actually exist they are fake jobs labor department should investigate them for their hiring practices its biased and discriminatory recruiter contacted me directly on LinkedIn for an opening but when I applied as per the link she sent me application got rejected in half hour even though I had all the skill set in the job position,

Its a coder pad interview where they asked the following questions: 1. Take me through your Resume 2. How do you migrate the data from an on premises database to the cloud? SQL coding: 1. Check if there are any duplicate records in the table and select all the duplicates into a table 2. What percentage of members have at least 2 records in each game 4 return the count of unique members who do not have wins and order by birth_date Python: Input A = [2,0,8,4,6,0,0,2] Result = [0,0,0,2,8,4,6,2] arrange so that output looks this way.