Data engineer to complete below task looking for a pro who can also provide logging

Requirement: Provide two solutions for the following scenario – 1) SQL programming language 2) Python scripting**. The python script should be orchestrated in airflow. Provide the read me with the details to build the docker image. 1. Deduplicate the data in players. oprimary keys in players table are name, team and position. oif two records are available with the same primary key - pick the record that has maximum data (ignore the rows that have nulls). 2. Replace empty cells for height and weight in the players csv with the average height and weight from the data. 3. Generate first excel output with total number of players by position. 4. Generate second excel output with - oadd a new column that shows "Yes" for players older than 30 years. Default value should be "No". oadd bmi calculation omerge players and teams - the output file will show all columns in players with the above two additional columns and columns from teams excel as well. 5. Also provide code to ingest from AWS S3 bucket and output to another AWS S3 bucket instead of ingesting and writing data to csv file. Input files: [login to view URL] and [login to view URL] **Please send the python code in html format, if using jupyter notebooks. Feel free to reach out for any questions.