Capgemini Talend Developer Interview

hello can we talk

now okay you're available right take

another uh 15 to 30 minutes that be

okay okay okay can you please uh explain

me about your you know current and

previous project and the companies which

you have worked so far and the roles

main roles and responsibilities which

you are doing on daily basis

[Music]

what experence

in four years four years okay that's

good so is is that all into Open studio

or you all work on on

[Music]

uh

comp

[Music]

different and

[Music]

[Music]

can

pleas your voice is very

Fofo yeah your voice is very speak

little bit

[Music]

lader I can hear you but uh it's very

low voice is very

low my voice is very low

yes now

[Music]

it's thank you

much and water

we are

loading1 table table tol we

okay uh thank you uh

okay with some teic question can you

tell me what is the difference between

that itate to flow and slow to itate

something

[Music]

um here we are

[Music]

talking s to

okay

okay ch

framework

how what are the components use and what

are the different functionalities

performed

in yeah I am just asking you to explain

me about your atalan framework framework

which you are using in your current

project so how framework is designed how

does it look like and what is the main

function of the

we are

[Music]

using

to

um anding processes

all right can you explain me about uh

how did you do the error handling in a

[Music]

challenge the table

[Music]

[Music]

of information

available we are using

L this way we are using this component

we can talk

any can

comp

[Music]

comp okay so have you imped in your

prev uh call

okay M because there is a point in your

TV studing that strong knowledge of data

warehouse

M

diable reason I was asking you like you

know what are the different usds and how

did you implement that in

[Music]

comp okay can you explain what are

the yeah that is one way yeah without

how would you do that

levid

[Music]

[Music]

from

I

and information

to that column

is so like we all right all right thank

you uh can you tell me the differences

between s and Cuma and which one is the

best for

you C

table

[Music]

this mhm okay okay

[Music]

uh can

you tell me what are the different ways

to Def the context variables

[Music]

inable and

[Music]

one more one more

thinger the

table

init

[Music]

[Music]

weable datab

we can add the

level okay okay okay I have a

scenario uh okay in s totally uh there

are 100

points okay and uh the target is

database sour is uh let's assume F3 is a

s

in S3 you have totally 100

files and in Target files you have only

one single table where you need to load

all the standard files into that one

single table so how many JS would you

des and what are the components you use

and what is the best way to design the

Jack can you

explain all the files are same structure

or different

uh let us assume the scenario one is

[Music]

CH variable no uh your your course is

your uh the files are not

yeah the SCE is

S3

S3

[Music]

uh uh have you worked on S3 before uh

floud integration you say when you say

FL integration you must have worked

on3

right uh yes

[Music]

[Music]

basically you

use list when when the SCE is your free

you just go for CS2

comp and you use the Z component and

when the sour is CS2 you just use

[Music]

comp Global variable you define the

global variable and then what would you

do

[Music]

after

[Music]

comp yeah that is fine hand

so how we load all of them how

we

[Music]

after what

I okay okay

then component uh

to tet component

[Music]

okay

con okay now scenario two the file names

are different 100 file F all 100 files

are having different say file 01 file 02

file 0 and so on file 100 so how would

you

handle yeah can you hear me

hello let me move to the next question

uh this is a important question B you s

experien and having around 4 years

experience the house so the inting

question here is what are the

systems performance of

the I would like to hear at least 8 to

10 tell me different techniques and

different ways like you know how how

will you improve the performance

of let's Che all the scenarios which are

the scenarios we have

theform uh just tell me at least uh 8 to

10 points then I will be happy to take

this forward take your time think and

tell me what are the

those I will performance of yeah per

performance optimization

technique how improve the performance of

what are the different things we can do

in t work

[Music]

uh uh

remove okay good

[Music]

[Music]

starty to four

five whatever number you want okay

[Music]

mfect

[Music]

comp yeah there it is multi and in

Enterprise it is par

okay uh

[Music]

then good that's that's good point

yeah very good super good come on yeah

you have

45 already I would like

[Music]

to okay okay

[Music]

okay all right whatever

you I am satisfied I'm

ComEd now let me move on to the next

question hello yes can

how is

it

okay uh did you work

with

yes okay what is the PNC orcc in

[Music]

ch

okay can you send email

[Music]

okay want to

do just want to

do all right so how can we run

theob okay I'm done with the par

Administration question let me uh move

on let me move on to the

DAT so Hing w

pleas okay okay uh can

you are you

good no okay okay um okay so what is the

difference between part and group

Del to delou

no how can you use group

[Music]

statement

M what is the difference between

[Music]

[Music]

okay all right uh done with the

questions do you have any questions for

me no question I need few DET just be

online I will ask you just ask you few

questions uh and then with the technical

questions no worries I just need some

details your personal details I ask to

be online for minut do you have any

experience in the T B

can you to

[Music]

yourself okay how

[Music]

what is your Rel experience in the

[Music]

SQ experience

okay any experience in the unit

12

[Music]

yes to

okay

okay uh do you have any other

SKS informa

and

okay okay