Overview: We are looking for a Python developer to build a microservice that is part of a digital loyalty program. The service must generate personalized stickers (with transparent backgrounds) and deliver them via WhatsApp using the Twilio Business API (we are open to alternatives). Please ask any questions before applying to ensure clarity about the scope and expectations. No price negotiations will be accepted after your proposal is submitted. The price you offer must be final and binding upon project award. Required Functional Flow: The service receives a request with the following parameters: 1, name of the user 2. phone number (WhatsApp) 3. sticker type It queries a MySQL database (see attached file database_structure) to fetch the first available code (status = pending) for that sticker type, marks it as active, and logs the assignment. It loads a transparent PNG base image (based on the sticker type) and overlays the code as text, preserving the transparency. It generates the final PNG sticker with the overlay. The sticker is sent via Twilio WhatsApp API to the provided phone number. Technical Requirements: The entire solution must be developed in Python (preferably using FastAPI or Flask). The service must run inside a Docker container, production-ready. Twilio credentials for testing will be provided. The output image must maintain transparent background. The image must be sent as a sticker (not a regular image) through WhatsApp, or as close as possible given Twilio’s constraints. Deliverables: Clean, well-documented source code. Dockerfile and working containerized solution. MySQL schema/init script. Deployment instructions. Important Notes!!!!!!!!! We are looking for a professional and detail-oriented developer. Clean code, modular structure, and good documentation will be highly valued.