CGI Group Talend Developer Interview Questions and Answers

Q1. Explore the your work experience in previous company?
Ans. 
I have 5 years of experience as a Talent Acquisition Specialist in a Fortune 500 company.
• Led recruitment efforts for various departments, including IT, finance, and marketing.

• Implemented innovative sourcing strategies to attract top talent.

• Conducted interviews, negotiated offers, and onboarded new hires.

• Collaborated with hiring managers to understand their needs and provide tailored recruitment solutions.
Answered by AI
Add your answer
Q2. Explain the roles and responsibilities
Ans. 
Talent Acquisition Specialists are responsible for sourcing, attracting, and hiring top talent for an organization.
• Developing and implementing recruitment strategies

• Sourcing candidates through various channels such as job boards, social media, and networking events

• Screening resumes and conducting interviews

• Collaborating with hiring managers to understand staffing needs

• Negotiating job offers and managing the onboarding
Answered by AI
Add your answer

Q1. Filter source data based on department id (assuming 1000+ departments are there) and store in unique files.
Ans. 
Filter source data by department id and store in unique files
• Use Talend components like tFilterRow to filter data based on department id

• Create a unique file for each department using tFileOutputDelimited component

• Loop through all department ids to process data for each department
Answered by AI
Add your answer
Q2. Various ways to optimize an SQL Query to improve query performance.
Ans. 
Optimizing SQL queries can improve query performance by using indexes, avoiding unnecessary joins, and optimizing the query structure.
• Use indexes on columns frequently used in WHERE clauses

• Avoid using SELECT * and only retrieve necessary columns

• Optimize joins by using INNER JOIN instead of OUTER JOIN when possible

• Use WHERE clause to filter data early in the query

• Avoid using functions in WHERE clauses as they can preven
Answered by AI
Add your answer

Q1. Tell me something about your self
Add your answer

General aptitude test

It is a ppt round where we need to create a ppt and present the topic

Q1. How you manage work and personal life
Add your answer

Java/C and .net it's depending on the requirement

Q1. About current project technical skill based questions
Add your answer

Q1. Hiring process, HR Management
Add your answer
Q2. Salary Negotiation
Add your answer

Q1. What you source from naukri
Ans. 
We source potential candidates for various job positions from naukri.com
• We search for candidates based on job requirements

• We filter candidates based on their experience and qualifications

• We reach out to potential candidates through naukri messaging system

• We keep track of candidate responses and schedule interviews accordingly
Answered by AI
Add your answer
Q2. Java android ios selenim and
Add your answer

Q1. What you like in company
Add your answer
Q2. Like to work 24 hours
Add your answer

Q1. Will you work weekend
Add your answer
Q2. Yes will work in weekend weekday
Add your answer