I applied through a recruiter. The process took 1 day. I interviewed at LTM Limited (Sat home) in Nov 2024
Interview
Screening: HR called and asked about current project, past assignments, technologies & tools worked upon etc
Technical Round:
30 mins
Questions were easy and related to ETL Testing, SQL and relational databases. I answered all questions correctly.
Interview questions [1]
Question 1
ETL Scenario based questions
Describe data warehousing, and it's components.
OLTP, OLAP, SCD, Normalisation, Denormalisation
Basic SQL queries including outer joins, pattern matching etc
