Your company is building a data ingestion pipeline that needs to handle both stateful and stateless data transactions. Which AWS service would you recommend for this scenario, and how would you design the pipeline to handle both types of transactions?