Pergunta de entrevista da empresa HR.com

You have 4 hours to automate weekly ingestion of inconsistent Excel data. Do you use Python, a no-code tool, or enforce a strict template? Explain your architecture.