Add office photos
i
Capgemini
CompareProud winner of ABECA 2024 - AmbitionBox Employee Choice Awards
Filter interviews by
Capgemini Talend Developer Interview Questions and Answers
Capgemini Talend Developer Interview Experiences
1 interview found
(9 Questions)
- Q1. Context variables,scds,tjava tjavarow,tjavaflex
- Q2. Pass variables from child to parent and then parent to child,how to process files with dynamic schema,
- Ans.
To pass variables from child to parent and vice versa, use context variables. For dynamic schema, use Talend's tSchemaDynamic component.
Use context variables to pass variables between child and parent jobs
For dynamic schema, use Talend's tSchemaDynamic component
tSchemaDynamic allows for dynamic schema creation based on input data
Use tFileInputDelimited component to read files with dynamic schema
- Q3. Restartability,matchmodels and lookup models in tmap,taggregate row and taggregate sorted row,tmap and tjoin
- Q4. Out of 100 records from source only 50 has loaded to target what is your approach,how to debug our job, incremental load
- Ans.
Approach to debug Talend job with 50% data loading to target out of 100 records from source
Check the log files for any errors or warnings
Verify the source and target connections
Check if any filters or transformations are causing the issue
Check if the job is designed for incremental load and if the correct parameters are set
Check if there are any data quality issues in the source data
Check if there are any network or sy
- Q5. For every successful loading of 10file to target 10 mails has to be generated how?
- Ans.
To generate 10 mails for every successful loading of 10 files to target.
Create a job that loads 10 files to target
Add a component to generate mails after successful loading
Configure the mail component to send 10 mails
Use a loop to repeat the process for every 10 files loaded
- Q6. Tfilterrow,tflowtoiterate and titeratetoflow, performance tuning techniques,bulk components,memory components
- Q7. Duplicate rows query in SQL, second highest salary in SQL,write query for giving discount on certain products and add additional column for discounted item in run time,union and unionall
- Q8. Primary key, foreign key,unique key, partitioning and pivoting,views,materliased views,stored procedures triggers
- Q9. Dimensions,tyeps of dimensions,facts and types of facts,data Mart,datalake,factless fact ,grain of fact,starschema and snowflake schemA
Interview Preparation Tips
Skills evaluated in this interview
Talend Developer Jobs at Capgemini
Interview questions from similar companies
Selected
I applied via Company Website and was interviewed before Apr 2022. There were 3 interview rounds.
(1 Question)
- Q1. About Talend and previous projects explanation
(1 Question)
- Q1. Regarding package
Interview Preparation Tips
I applied via Recruitment Consulltant and was interviewed in Dec 2024. There was 1 interview round.
(2 Questions)
- Q1. Explore the your work experience in previous company?
- Q2. Explain the roles and responsibilities
Interview Preparation Tips
(2 Questions)
- 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
- 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
Skills evaluated in this interview
Associate Talent Acquisition Interview Questions & Answers
Infosys
Vinee Mishra
posted on 27 Dec 2024
Selected
I applied via Through WhatsApp and was interviewed in Jun 2024. There was 1 interview round.
(2 Questions)
- Q1. Related to Recruitment
- Q2. Excel questions
Talent Acquisition Executive Interview Questions & Answers
Wipro
P Bala Naga Chandra Shekar
posted on 17 Jun 2024
I applied via Campus Placement
General aptitude test
It is a ppt round where we need to create a ppt and present the topic
(1 Question)
- Q1. How you manage work and personal life
I applied via Company Website and was interviewed in Feb 2024. There was 1 interview round.
(1 Question)
- Q1. What will be your team strength.
Interview Preparation Tips
Selected
I applied via campus placement at Cummins College of Engineering for Women, Pune and was interviewed before Jun 2023. There was 1 interview round.
(2 Questions)
- Q1. Hiring process, HR Management
- Q2. Salary Negotiation
I applied via Naukri.com and was interviewed in Apr 2022. There were 2 interview rounds.
(1 Question)
- Q1. How do achieve rank login in talend
- Ans.
To achieve rank login in Talend, you can use the tRank component.
Use the tRank component in Talend to achieve rank login.
Configure the tRank component to specify the input data and the column to rank on.
The tRank component will assign a rank to each row based on the specified column.
You can then use the ranked data for further processing or analysis.
Interview Preparation Tips
Skills evaluated in this interview
I applied via Naukri.com and was interviewed in Mar 2021. There were 3 interview rounds.
Interview Questionnaire
2 Questions
- Q1. Have you got any experience in sourcing, scheduling?
- Ans.
Yes, I have experience in sourcing and scheduling.
I have sourced candidates through various channels such as job boards, social media, and employee referrals.
I have scheduled interviews and coordinated with hiring managers and candidates to ensure a smooth process.
I have also managed candidate pipelines and provided regular updates to stakeholders.
For example, in my previous role, I sourced and scheduled over 50 candid...
- Q2. Hand on experience on domain i had?
Interview Preparation Tips
Capgemini Interview FAQs
Some of the top questions asked at the Capgemini Talend Developer interview -
Tell us how to improve this page.
Capgemini Interviews By Designations
- Capgemini Analyst Interview Questions
- Capgemini Consultant Interview Questions
- Capgemini Software Engineer Interview Questions
- Capgemini Senior Consultant Interview Questions
- Capgemini Associate Consultant Interview Questions
- Capgemini Senior Analyst Interview Questions
- Capgemini Software Developer Interview Questions
- Capgemini Senior Software Engineer Interview Questions
- Show more
Interview Questions for Popular Designations
- Talent Acquisition Specialist Interview Questions
- Talent Acquisition Executive Interview Questions
- ETL Talend Developer Interview Questions
- Associate Talent Acquisition Interview Questions
- Manager Talent Acquisition Interview Questions
- Senior Talent Acquisition Specialist Interview Questions
- Talent Acquisition Consultant Interview Questions
- Software Engineer Interview Questions
- Show more
Interview Questions from Similar Companies
Fast track your campus placements
Capgemini Talend Developer Reviews and Ratings
based on 5 reviews
Rating in categories
|
Consultant
55.3k
salaries
|  ₹5.2 L/yr - ₹18 L/yr |
|
Associate Consultant
52.1k
salaries
| ₹2.9 L/yr - ₹11.8 L/yr |
|
Senior Consultant
46k
salaries
| ₹7.4 L/yr - ₹24 L/yr |
|
Senior Analyst
20.5k
salaries
| ₹2 L/yr - ₹7.5 L/yr |
|
Senior Software Engineer
19.9k
salaries
| ₹3.5 L/yr - ₹12.5 L/yr |
Wipro
Accenture
Cognizant
TCS
Calculate your in-hand salary
- Home >
- Interviews >
- Capgemini Interview Questions >
- Capgemini Talend Developer Interview Questions
