Jump to content

ETL interview questions


Recommended Posts

Posted
3 minutes ago, Sarvapindi said:

Performance tuning...error handling....common qns em adgar ekkuva....aa tool lo etla chestav anedi important

I know performance tuning on reports 😊

  • Replies 38
  • Created
  • Last Reply

Top Posters In This Topic

  • Sarvapindi

    10

  • vendettaa

    8

  • mantis

    7

  • ARYA

    4

Popular Days

Top Posters In This Topic

Posted
1 minute ago, ARYA said:

arey e lowda lo etl ni lite teskondi...

anna, training antha ayyaka itta antav enti

Posted
1 minute ago, vendettaa said:

This are very important questions kada

denikina ive common...everyone want ferformance....no error 

Posted
Just now, mantis said:

I know performance tuning on reports 😊

ade cheppu.. ok thank u...antar..

Posted

What are performance tuning  techniques you have used so far for spark jobs?

Posted
Just now, Sarvapindi said:

ade cheppu.. ok thank u...antar..

ETL performance tuning ante....views,indexes create cheyadam laantivi untaaya

Posted
2 minutes ago, tacobell fan said:

anna, training antha ayyaka itta antav enti

cheap ga ye trainer dorikite aa trainer tho training ippinhad mana @TOM_BHAYYA anna :( 

Posted

1) How to handle the delta's or change data capture (CDC)

2) How to insert/update into table

3) Depends on datamart, SDC2 aithe how to maintain record history.

4) How to calculate dates for a record (start and end dates) if a start date is only given based on natural key

5) How to group by SUM or Cummulative summary for a record 

 

Depends on the ETL tool it will be more specific. Also expect questions on Unix Scripting, SQL, Repository, Code migration, Release Process, Ticketing, Issue tracking, Testing. ETL doesn't necessarily mean they will stick to tool related questions.

Posted
Just now, mantis said:

ETL performance tuning ante....views,indexes create cheyadam laantivi untaaya

basics evad adgatle va iyyal repu...deep dive ee..

Posted
4 minutes ago, vendettaa said:

This are very important questions kada

interviewer JNTU lecturer anukunnava vanty...

nee saduvu sallagunda...

asalu nuvvu fingering cheyani tech ledu anukunta kada..

inthaki are you working in air force...

Posted
Just now, ARYA said:

cheap ga ye trainer dorikite aa trainer tho training ippinhad mana @TOM_BHAYYA anna :( 

call set ayyaka hand istadu antava

Posted

Etl is more of scenario type...valla current prj situation batti adugutar qns..

Posted
Just now, tacobell fan said:

1) How to handle the delta's or change data capture (CDC)

2) How to insert/update into table

3) Depends on datamart, SDC2 aithe how to maintain record history.

4) How to calculate dates for a record (start and end dates) if a start date is only given based on natural key

5) How to group by SUM or Cummulative summary for a record 

 

Depends on the ETL tool it will be more specific. Also expect question on Unix, SQL, Repository, Code migration, Release Process, Ticketing, Issue tracking, Testing. ETL doesn't necessarily mean they will stick to tool related questions.

Thankyou andi 

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...