Thser will be screening round by hr and the Will have 3 to 4 rounds of interviews based on role and skillset.
Focus on programming: hashmap, string, and arrays.
Also, behavioral questions from HR and the hiring manager.
For an experienced person with 4-5 years in ETL testing.
The interviewer is good and they support but quite strict when they do not get the appropriate answer of there scenario based questions .
Interview questions [1]
Question 1
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;
I applied through a recruiter. I interviewed at Coforge (Hyderābād) in Apr 2024
Interview
Got a call from Coforge HR on being shortlisted from Naukri. First round of technical on API and UI Automation using REST Assured, Selenium with Java and Cucumber. Interview would be for 30-40 minutes
Interview questions [1]
Question 1
Questions on testing flow using REST Assured. Write a scenario in Cucumber for an API test. JMeter API Testing and Performance testing.