Skip to contentSkip to footer

Programmer Trainee Interview Questions

Salaries
Interviews

2,759 programmer trainee interview questions shared by candidates

1. What are the differences between OLTP and OLAP systems ? 2. What type of data are stored in a retail database ? 3. How date dimension table can be used as both conformed dimension table and role play based dimension table. 4. What are Top Down and Bottom Up approaches of Data Warehouse designing ? 5. What is Monkey Patching in Python ? 6. Difference between AWS S3 and AWS Redshift ? 7. Name some Cloud Data Warehouse services. 8. Importance of Machine Learning in IT industry. 9. Difference between supervised and unsupervised learning algorithms. 10. Difference between Data Warehouse and Data Lake solutions. 11. Name some Cloud ETL products. 12. An Employee table was given and I was asked to find the employees who are getting 3rd highest salary from each department. 13. Find those employees whose salary is higher than average salary of sales employee. 14. What is dimensional modeling in Data Warehouse ? 15. Give examples of data modification anomalies if a database is not properly normalized. 16. Importance of denormalized tables for analytical systems.
avatar

Programmer Analyst Trainee

Interviewed at Cognizant

3.6★
Apr 3, 2023

1. What are the differences between OLTP and OLAP systems ? 2. What type of data are stored in a retail database ? 3. How date dimension table can be used as both conformed dimension table and role play based dimension table. 4. What are Top Down and Bottom Up approaches of Data Warehouse designing ? 5. What is Monkey Patching in Python ? 6. Difference between AWS S3 and AWS Redshift ? 7. Name some Cloud Data Warehouse services. 8. Importance of Machine Learning in IT industry. 9. Difference between supervised and unsupervised learning algorithms. 10. Difference between Data Warehouse and Data Lake solutions. 11. Name some Cloud ETL products. 12. An Employee table was given and I was asked to find the employees who are getting 3rd highest salary from each department. 13. Find those employees whose salary is higher than average salary of sales employee. 14. What is dimensional modeling in Data Warehouse ? 15. Give examples of data modification anomalies if a database is not properly normalized. 16. Importance of denormalized tables for analytical systems.

Viewing 1351 - 1360 interview questions

Glassdoor has 2,759 interview questions and reports from Programmer trainee interviews. Prepare for your interview. Get hired. Love your job.