ACTICO Senior Technical Consultant - Java interview questions

First round asked about my background. Second round was technical questions about Java and an ETL-type challenge with their modeler. Some technical questions: What is ACID and explain, Java memory types and how it is handled. How to make sure objects will be garbage collected. How to make table creation faster in SQL, multithreading, streams, what are the different types of collections in java, what is an example of an ordered map, etc