Upload Button Icon Add office photos

Filter interviews by

Slk Software Services ETL Tester Interview Questions and Answers

Updated 13 Jan 2023

Slk Software Services ETL Tester Interview Experiences

1 interview found

ETL Tester Interview Questions & Answers

user image Anonymous

posted on 11 Jan 2023

Interview experience
4
Good
Difficulty level
Easy
Process Duration
Less than 2 weeks
Result
Not Selected

I applied via Naukri.com and was interviewed in Dec 2022. There were 2 interview rounds.

Round 1 - Resume Shortlist 
Pro Tip by AmbitionBox:
Keep your resume crisp and to the point. A recruiter looks at your resume for an average of 6 seconds, make sure to leave the best impression.
View all tips
Round 2 - One-on-one 

(2 Questions)

  • Q1. DWH concepts, ETL concepts, JIRA tool,
  • Q2. Dwh concepts, ETL concepts, HPALM, informatica

Interview Preparation Tips

Interview preparation tips for other job seekers - I have an experience in ETL TEST ENGINEER, DWH testing

Interview questions from similar companies

Interview experience
4
Good
Difficulty level
Easy
Process Duration
Less than 2 weeks
Result
Not Selected

I applied via Naukri.com and was interviewed in Apr 2023. There were 3 interview rounds.

Round 1 - Resume Shortlist 
Pro Tip by AmbitionBox:
Keep your resume crisp and to the point. A recruiter looks at your resume for an average of 6 seconds, make sure to leave the best impression.
View all tips
Round 2 - Technical 

(1 Question)

  • Q1. L1 was scheduled and asked abt ETL basics, some sql queries related to string manipulation
Round 3 - Technical 

(1 Question)

  • Q1. After 1st round I was asked to submit resume again and BGV details. Submitted them and Waiting for round 2

Interview Preparation Tips

Interview preparation tips for other job seekers - L1 was good waiting for the result and L2

I applied via Naukri.com and was interviewed in Oct 2022. There were 2 interview rounds.

Round 1 - Resume Shortlist 
Pro Tip by AmbitionBox:
Don’t add your photo or details such as gender, age, and address in your resume. These details do not add any value.
View all tips
Round 2 - One-on-one 

(2 Questions)

  • Q1. Diff b/w where clause and having clause? diff b/w severity and priority
  • Ans. 

    Difference between where and having clause and severity and priority

    • Where clause is used to filter rows before grouping while having clause is used to filter groups after grouping

    • Severity is the degree of impact of a defect on the system while priority is the order in which defects should be fixed

    • Where clause is used with SELECT, UPDATE and DELETE statements while having clause is used with GROUP BY clause

    • Severity is u...

  • Answered by AI
  • Q2. Write query last hour hour transaction details through net banking r card
  • Ans. 

    Query for last hour transaction details through net banking or card

    • Use the transaction table to filter transactions by timestamp

    • Join with the net banking or card table to get additional details

    • Filter for transactions within the last hour using a WHERE clause

    • Order the results by timestamp to get the most recent transactions first

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - all the best .. be confidents .prepare well give the good

Skills evaluated in this interview

Interview experience
4
Good
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Resume Shortlist 
Pro Tip by AmbitionBox:
Properly align and format text in your resume. A recruiter will have to spend more time reading poorly aligned text, leading to high chances of rejection.
View all tips
Round 2 - HR 

(2 Questions)

  • Q1. What are your salary expectations
  • Q2. Make sure you are not giving exact number unless its necessary and quote bit extra than what you expect because there will be always a negotiation

Interview Preparation Tips

Interview preparation tips for other job seekers - Read about all DWH concepts , practice on SQL joins and sample test scenarios used for etl testing
Interview experience
5
Excellent
Difficulty level
-
Process Duration
-
Result
Not Selected
Round 1 - Resume Shortlist 
Pro Tip by AmbitionBox:
Double-check your resume for any spelling mistakes. The recruiter may consider spelling mistakes as careless behavior or poor communication skills.
View all tips
Round 2 - Aptitude Test 

Aptitude was 1st round, technical apti, then followed by tec nn iCal round

Round 3 - Technical 

(2 Questions)

  • Q1. Technical round was 2 nd, concepts related to testing Testing
  • Q2. Tsting related questions were asked in interview

Interview Preparation Tips

Interview preparation tips for other job seekers - Be prepared with basics of testing test cases defect reporting
Interview experience
3
Average
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Naukri.com and was interviewed before Jan 2023. There was 1 interview round.

Round 1 - One-on-one 

(1 Question)

  • Q1. Manual testing, API , Real-time scenario
Interview experience
4
Good
Difficulty level
Easy
Process Duration
Less than 2 weeks
Result
Not Selected

I applied via Naukri.com and was interviewed in Apr 2023. There were 3 interview rounds.

Round 1 - Resume Shortlist 
Pro Tip by AmbitionBox:
Do not use an unprofessional email address such as cool_boy@email.com. It shows a lack of professionalism by the candidate.
View all tips
Round 2 - Technical 

(1 Question)

  • Q1. L1 was scheduled and asked abt ETL basics, some sql queries related to string manipulation
Round 3 - Technical 

(1 Question)

  • Q1. After 1st round I was asked to submit resume again and BGV details. Submitted them and Waiting for round 2

Interview Preparation Tips

Interview preparation tips for other job seekers - L1 was good waiting for the result and L2
Interview experience
3
Average
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Job Portal and was interviewed in Jun 2024. There was 1 interview round.

Round 1 - Aptitude Test 

20 minutes --basic questions

Interview experience
4
Good
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Resume Shortlist 
Pro Tip by AmbitionBox:
Be truthful in your resume. It is very easy to catch false or lies during the interview by asking basic questions.
View all tips
Round 2 - HR 

(2 Questions)

  • Q1. What are your salary expectations
  • Q2. Make sure you are not giving exact number unless its necessary and quote bit extra than what you expect because there will be always a negotiation

Interview Preparation Tips

Interview preparation tips for other job seekers - Read about all DWH concepts , practice on SQL joins and sample test scenarios used for etl testing

I applied via Naukri.com and was interviewed in Apr 2021. There was 1 interview round.

Interview Questionnaire 

1 Question

  • Q1. Assertion in Jmeter. what protocol used in jmeter 3. what is hit per second. 4.why after some number hit/sec become constant 5. what is sync and async testing. 6. what is standard deviation. 7. how u handl...
  • Ans. 

    Answers to questions related to Performance Testing using JMeter

    • Assertion in JMeter is used to validate the response of a request

    • JMeter supports various protocols like HTTP, FTP, JDBC, etc.

    • Hits per second is the number of requests sent to the server in a second

    • Hits per second may become constant due to server limitations or network issues

    • Sync testing involves waiting for a response before sending the next request, whil...

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - be confident what you know. the question are belong to practical experience . here no theoretical knowledge will work.

Skills evaluated in this interview

Slk Software Services Interview FAQs

How many rounds are there in Slk Software Services ETL Tester interview?
Slk Software Services interview process usually has 2 rounds. The most common rounds in the Slk Software Services interview process are Resume Shortlist and One-on-one Round.
What are the top questions asked in Slk Software Services ETL Tester interview?

Some of the top questions asked at the Slk Software Services ETL Tester interview -

  1. Dwh concepts, ETL concepts, HPALM, informat...read more
  2. DWH concepts, ETL concepts, JIRA to...read more

Tell us how to improve this page.

People are getting interviews through

based on 1 Slk Software Services interview
Job Portal
100%
Low Confidence
?
Low Confidence means the data is based on a small number of responses received from the candidates.
Slk Software Services ETL Tester Salary
based on 19 salaries
₹3.8 L/yr - ₹8 L/yr
21% less than the average ETL Tester Salary in India
View more details

Slk Software Services ETL Tester Reviews and Ratings

based on 1 review

5.0/5

Rating in categories

5.0

Skill development

5.0

Work-Life balance

4.0

Salary & Benefits

5.0

Job Security

4.0

Company culture

5.0

Promotions/Appraisal

5.0

Work Satisfaction

Explore 1 Review and Rating
Software Engineer
1k salaries
unlock blur

₹2.4 L/yr - ₹10.5 L/yr

Senior Software Engineer
717 salaries
unlock blur

₹5.7 L/yr - ₹23 L/yr

Test Engineer
357 salaries
unlock blur

₹2 L/yr - ₹9.7 L/yr

Softwaretest Engineer
302 salaries
unlock blur

₹3 L/yr - ₹10 L/yr

Associate Software Engineer
255 salaries
unlock blur

₹2.7 L/yr - ₹5.5 L/yr

Explore more salaries
Compare Slk Software Services with

Persistent Systems

3.5
Compare

TCS

3.7
Compare

Infosys

3.7
Compare

Wipro

3.7
Compare

Calculate your in-hand salary

Confused about how your in-hand salary is calculated? Enter your annual salary (CTC) and get your in-hand salary
Did you find this page helpful?
Yes No
write
Share an Interview