Coforge Test Analyst interview questions

1) Tell something about yourself? 2) How do you perform ETL process day by day? and about rate yourself in etl process 3) what is a fact table? 4) what is surrogate key and what are the differences between the surrogate key and primary key ? 5) Have you implemented any SCD rule in your organization ? 6) some SQL queries with full screen share and rating they asked for SQL : Q1. Write an SQL query to fetch the employees whose name begins with any two characters, followed by a text “hn” and ends with any sequence of characters. SELECT * FROM employees WHERE full_name LIKE '__hn%'; Q2. Write an SQL query to fetch records that are present in one table but not in another table. SELECT * FROM table1 t1 WHERE NOT EXISTS (SELECT 1 FROM table2 t2 WHERE t1.id = t2.id); Q3.Write an SQL query to fetch the employee’s full names and replace the space with ‘-’. SELECT REPLACE(full_name, ' ', '-') AS formatted_full_name FROM employees;