TEKsystems Interview Question

1. Interacting with REST API using Talend. 2. Some SQL based questions related to check the concepts of group by and partition by. 3. SQL performance tuning. 4. How to design a pipeline to ingest multiple files with different metadata, using Talend. 5. Whether I have created custom components / functions in Talend etc.