Snowflake-Kafka Database Developer Starter Code using AWS cloud

I'm seeking a proficient developer to build a comprehensive demo or starter code integrating Snowflake and Kafka using AWS cloud. The ideal candidate should have deep understanding of concepts such as:

- Data ingestion
- Data transformation
- Data storage and retrieval

The code should ensure:
- Optimal performance
- Scalability
- Security

The code can be written in Python or Java. In-depth knowledge of these languages, as well as experience with Snowflake and Kafka integration, is a necessity for a successful bid on this project.