Recruitment still going on for the Job - JOB DETAILS
Candidate: Vamsi Krishna
Interview Date: 17 June 2025
Slot Time: 10:00 AM – 10:30 AM
Mode: Virtual (Microsoft Teams)
Location: Remote (Candidate in Guntur, Interviewer in Bangalore)
Role: Apprentice (ETL, Development Support)
Round 1: Technical + HR Combo Round
Interviewer Panel:
-
Priya M. – Senior Software Engineer (ETL Team, CGI Bangalore)
-
Rakesh T. – HR Executive – Fresher Campus Hiring, CGI India
1. Tell me about yourself.
Candidate Answer:
"Hi, I’m Vamsi Krishna, a recent B.Tech graduate in ECE from VVIT, Guntur. I’ve always been interested in how data flows through systems, which drew me to explore ETL pipelines and data tools during college. I’ve worked on a mini-project using SQL and basic data migration scripts. I’m passionate about tech and really excited to start my career at a reputed company like CGI, where I can learn and grow."
Feedback:
✅ Confident, relevant, fluent.
✅ Clear connection to ETL and willingness to learn.
Verdict: Good impression.
2. Explain what an ETL process is.
Candidate Answer:
"ETL stands for Extract, Transform, Load. It’s a data pipeline used to move data from multiple sources into a centralized system, like a data warehouse. Extract is about pulling the data, Transform involves cleaning, filtering, and reshaping it, and Load is when it’s stored in the final system."
Correct Answer: (Same)
Feedback:
✅ Clear and accurate.
✅ Used business terms.
Verdict: Strong understanding.
3. You’re assigned to a support team working night shifts for 3 months. Are you okay with that?
Candidate Answer:
"Yes, I’m absolutely fine with shifts. I understand that client support is crucial, and I’m prepared to work in any schedule if the project demands it."
Feedback:
✅ Direct and mature response.
Verdict: Green flag for flexibility.
4. Do you know any databases or SQL queries? Can you give an example?
Candidate Answer:
"Yes, I’ve worked with MySQL in college. I’ve written SELECT queries, JOINs, and subqueries. For example:
SELECT emp.name, dept.dept_name FROM emp JOIN dept ON emp.dept_id = dept.id;"
Correct Answer: (Same)
Feedback:
✅ Practical example given.
❌ Could’ve explained the output a bit better.
Verdict: Basic level – acceptable for fresher.
5. Tell me about a time when you worked in a team. What was your role?
Candidate Answer:
"In our final-year project, we were four members working on a smart irrigation system. I was in charge of writing the code that transmitted sensor data to a mobile app. We used Arduino and C++. I also coordinated the testing phase."
Feedback:
✅ Team spirit, technical + soft skill balance.
✅ Good example of ownership.
Verdict: Strong behavioral answer.
6. Where do you see yourself in 3 years?
Candidate Answer:
"I want to be a skilled software professional, ideally working in data-related roles or backend development. I also want to grow into roles that require system design and architectural thinking."
Feedback:
✅ Ambitious and aligned with CGI’s path.
Verdict: Good future-facing answer.
7. Any questions for us?
Candidate Answer:
"Yes, what does the typical training path look like for a fresher apprentice at CGI? And how soon do we get assigned to real projects?"
Feedback:
✅ Smart question.
✅ Shows genuine interest in learning, not just landing a job.
Verdict: Excellent closure.
Final Feedback
Technical Feedback (Priya M.):
-
Strong fundamentals in ETL and SQL for a fresher
-
Good communication and willingness to learn
-
Needs hands-on exposure but trainable
HR Feedback (Rakesh T.):
-
Excellent communication
-
Flexible with shifts and open to relocation
-
Fits well into CGI’s culture
Missed or Weak Areas (for improvement):
-
Didn’t mention any specific ETL tools (like Talend, Informatica) – could be added for bonus points
-
Could’ve elaborated SQL query output
-
No mention of Git or version control exposure