Upload Button Icon Add office photos

Filter interviews by

Accenture Datastage Developer Interview Questions and Answers

Updated 18 May 2021

1 interview found

Sort by: Popular

Datastage Developer Interview Questions

user image Anonymous

posted on 18 May 2021

I applied via Naukri.com and was interviewed in Nov 2020.

3 Interview Rounds

Interview Questions

  • Q1. Mostly scenario based questions according to domain i got insurance based questions Add Answer

Interview Preparation Tips

Interview preparation tips for other job seekers - Learn to answer scenario based and how you approach from all different technologies datastage Sql Unix

Interview questions from similar companies

Interview experience
3
 Average
Difficulty level
 -
Duration
 -
Result
 -

1 Interview Round

1

One-on-one Round (3 Questions)

  • Q1. Difference between join and lookup
  • Q2. Diffrence between fact table and dimension table
  • Q3. Sed command to display last before line

Skills evaluated in this interview

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

I applied via Naukri.com and was interviewed in Mar 2024.

1 Interview Round

1

Technical Round (2 Questions)

  • Q1. Data stage scenario
  • Q2. Difference between Data Stage and informatica

Interview Preparation Tips

Topics to prepare for HCL Group Datastage Developer interview:
  • Complete Data Stage

Skills evaluated in this interview

Interview experience
4
 Good
Difficulty level
 Moderate
Duration
 2-4 weeks
Result
Selected  Selected

I was interviewed before Aug 2022.

4 Interview Rounds

1

Resume Shortlist Round

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
2

Technical Round (2 Questions)

  • Q1. Basic questions about datastage Like difference between lookup,merge,join Questions with dataset and sequential stage. Then few questions asked on transformer s...read more
  • Q2. Remove duplicate using datastage
3

Technical Round (1 Question)

  • Q1. In second round most they focused on scenario based questions in both datastage and SQL.
4

HR Round (1 Question)

  • Q1. Salary and location discussion

Skills evaluated in this interview

Datastage Developer Interview Questions

IBM user image Neeraj Ramesh Deshbhratar

posted on 13 Nov 2021

I applied via Naukri.com and was interviewed in Oct 2021.

3 Interview Rounds

Interview Questions

  • Q1. Your total experience is 6+ in SQL and SSIS, but your relevant experience in Datastage is 3+, and already you are on a higher package as compared with 3 years D...read more View Answers (1)

Interview Preparation Tips

Interview preparation tips for other job seekers - I may have been working excessively on SQL and SSIS, but I started learning Datastage ETL tool as well. See, the point is how quick learner I am. There are people who are with 4+ in Datastage, but still I have to explain them the flow. Even when the assigned development is completed, I tune the jobs, remove unwanted columns, RCPs etc. I learned quickly and accelerated myself and that’s why my current employer gave me the opportunity to lead. I think everyone deserves a chance to prove themselves. I thought I’ll get a chance here as well but was unfortunate as they saw only those things what were on Resume, it’s better to drill down in the interviews rather than seeing the less experience. People with less knowledge as well get a good package, but if someone wants to learn then the recruiter should give a shot at least. It’s not the concern of package, I even was ready to negotiate as far as possible because I was getting a lifetime opportunity to work on a newer tech, but all in vain.

ETL Developer Interview Questions

TCS user image Anonymous

posted on 6 Dec 2024

Interview experience
5
 Excellent
Difficulty level
 Moderate
Duration
 Less than 2 weeks
Result
Selected  Selected

I applied via Naukri.com and was interviewed in Nov 2024.

2 Interview Rounds

1

Technical Round (4 Questions)

  • Q1. Lookup ,router,joiner
  • Q2. Different types of caches
  • Q3. Scd1 and scd2 implementation
  • Q4. Fact and dimensions tables and different data modelling
2

HR Round (1 Question)

  • Q1. Salary discuss and location discussion
Interview experience
5
 Excellent
Difficulty level
 Easy
Duration
 Less than 2 weeks
Result
 -

I applied via Approached by Company and was interviewed in Nov 2024.

1 Interview Round

1

Technical Round (3 Questions)

  • Q1. SQL Question on window functions to find the highest sale amount per day of the stores
  • Q2. Build an ETL Pipeline to read json files which are dropping at irregular times into storage. So how do you transform and match the schema etc.,
  • Q3. Write a pyspark code to join two tables and explain broadcastjoin() & what it does?

Informatica Developer Interview Questions

Capgemini user image Jayashree Shinde

posted on 6 Aug 2024

Interview experience
5
 Excellent
Difficulty level
 Moderate
Duration
 Less than 2 weeks
Result
 Not Selected

I applied via Naukri.com and was interviewed in Jul 2024.

1 Interview Round

1

Technical Round (5 Questions)

  • Q1. Analytical functions difference
  • Q2. Which transformation uses in scd2?
  • Q3. Unix basic, how to find particular file in directory?
  • Q4. Given 2 table A and B. Find count of left join, right join, inner join, full outer join?
  • Q5. Incremental load

Skills evaluated in this interview

Interview experience
5
 Excellent
Difficulty level
 -
Duration
 -
Result
 -

1 Interview Round

1

Technical Round (2 Questions)

  • Q1. What is dba, explain the architecture of dba
  • Q2. How you will maintain the database and what are the types of backup
Interview experience
5
 Excellent
Difficulty level
 -
Duration
 -
Result
 -

1 Interview Round

1

Technical Round (1 Question)

  • Q1. Basic of etl process, sql, unix

Accenture Interview FAQs

How to prepare for Accenture Datastage Developer interview?
Go through your CV in detail and study all the technologies mentioned in your CV. Prepare at least two technologies or languages in depth if you are appearing for a technical interview at Accenture. The most common topics and skills that interviewers at Accenture expect are Business Objects, Data Warehousing, Datastage, SQL and Shell Scripting.

Tell us how to improve this page.

People are getting interviews through

based on 1 Accenture interview
Job Portal
100%
Low Confidence
?
Low Confidence means the data is based on a small number of responses received from the candidates.

Interview Questions from Similar Companies

TCS Interview Questions
3.7
 • 10k Interviews
Infosys Interview Questions
3.7
 • 7.3k Interviews
Wipro Interview Questions
3.7
 • 5.4k Interviews
Cognizant Interview Questions
3.8
 • 5.4k Interviews
Capgemini Interview Questions
3.8
 • 4.7k Interviews
Tech Mahindra Interview Questions
3.6
 • 3.7k Interviews
HCLTech Interview Questions
3.6
 • 3.6k Interviews
Genpact Interview Questions
3.9
 • 2.9k Interviews
LTIMindtree Interview Questions
3.7
 • 2.4k Interviews
IBM Interview Questions
4.1
 • 2.3k Interviews
View all
Accenture Datastage Developer Salary
based on 49 salaries
₹4 L/yr - ₹7.2 L/yr
31% less than the average Datastage Developer Salary in India
View more details

Accenture Datastage Developer Reviews and Ratings

based on 1 review

5.0/5

Rating in categories

5.0

Skill development

1.0

Work-Life balance

4.0

Salary & Benefits

5.0

Job Security

5.0

Company culture

2.0

Promotions/Appraisal

3.0

Work Satisfaction

Explore 1 Review and Rating
Application Development Analyst
38.7k salaries
unlock blur

₹3 L/yr - ₹12 L/yr

Application Development - Senior Analyst
26.2k salaries
unlock blur

₹6.8 L/yr - ₹20.2 L/yr

Team Lead
23.9k salaries
unlock blur

₹7 L/yr - ₹25 L/yr

Senior Software Engineer
18.4k salaries
unlock blur

₹6 L/yr - ₹19 L/yr

Software Engineer
17.7k salaries
unlock blur

₹3.6 L/yr - ₹12.7 L/yr

Explore more salaries
Compare Accenture with

TCS

3.7
Compare

Cognizant

3.8
Compare

Capgemini

3.8
Compare

Infosys

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