Interview Questions

  • Reviews
  • Salaries
  • Interview Questions
  • About Company
  • Benefits
  • Jobs
  • Office Photos
+ Contribute
notification
notification
Login
Upload Button Icon Add office photos
Employer? Claim Account for FREE

Accenture

Compare button icon Compare button icon Compare
3.9

based on 53.5k Reviews

Proud winner of ABECA 2024 - AmbitionBox Employee Choice Awards

zig zag pattern zig zag pattern

Filter interviews by

Accenture Datastage Developer Interview Questions and Answers

Updated 18 May 2021

Accenture Datastage Developer Interview Experiences

1 interview found

Datastage Developer Interview Questions & Answers

user image Anonymous

posted on 18 May 2021

I applied via Naukri.com and was interviewed in Nov 2020. There were 3 interview rounds.

Interview Questionnaire 

1 Question

  • Q1. Mostly scenario based questions according to domain i got insurance based questions
    • Add your 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

Datastage Developer Interview Questions & Answers

HCLTech user image Anonymous

posted on 24 Jul 2024

Interview experience
3
Average
Difficulty level
-
Process Duration
-
Result
-
Round 1 - One-on-one 

(3 Questions)

  • Q1. Difference between join and lookup
  • Ans. 

    Join is used to combine rows from two or more tables based on a related column, while lookup is used to retrieve data from a reference table based on a matching key.

    • Join combines rows from multiple tables based on a related column

    • Lookup retrieves data from a reference table based on a matching key

    • Join can result in duplicate rows if there are multiple matches, while lookup returns only the first matching row

    • Join is use...

    • Answered by AI
    Add your answer
  • Q2. Diffrence between fact table and dimension table
  • Ans. 

    Fact table contains quantitative data and measures, while dimension table contains descriptive attributes.

    • Fact table contains numerical data that can be aggregated (e.g. sales revenue, quantity sold)

    • Dimension table contains descriptive attributes for analysis (e.g. product name, customer details)

    • Fact table is typically normalized, while dimension table is denormalized for faster queries

    • Fact table is usually larger in s

    • Answered by AI
    Add your answer
  • Q3. Sed command to display last before line
  • Ans. 

    Use sed command to display the line before a specific pattern

    • Use 'sed -n '/pattern/{g;1!p;};h' file.txt' to display the line before the pattern

    • Replace 'pattern' with the specific pattern you are looking for

    • This command will display the line before the pattern in the file

    • Answered by AI
    Add your answer

Skills evaluated in this interview

Datastage Developer Interview Questions & Answers

HCL Group user image Anonymous

posted on 24 Apr 2024

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

I applied via Naukri.com and was interviewed in Mar 2024. There was 1 interview round.

Round 1 - Technical 

(2 Questions)

  • Q1. Data stage scenario
    • Add your answer
  • Q2. Difference between Data Stage and informatica
  • Ans. 

    Data Stage is an ETL tool by IBM, while Informatica is a popular ETL tool by Informatica Corporation.

    • Data Stage is developed by IBM, while Informatica is developed by Informatica Corporation.

    • Data Stage is known for its parallel processing capabilities, while Informatica is known for its ease of use and flexibility.

    • Data Stage has a graphical interface for designing jobs, while Informatica uses a more traditional workflo...

    • Answered by AI
    Add your answer

Interview Preparation Tips

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

Skills evaluated in this interview

Datastage Developer Interview Questions & Answers

Cognizant user image Nishok Parama

posted on 2 Aug 2023

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

I was interviewed before Aug 2022.

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 

(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 stage.
    • Add your answer
  • Q2. Remove duplicate using datastage
  • Ans. 

    Use Datastage to remove duplicates from a dataset

    • Use a Remove Duplicates stage in Datastage to eliminate duplicate records

    • Configure the Remove Duplicates stage to identify and remove duplicates based on specific key columns

    • Ensure that the dataset is sorted properly before applying the Remove Duplicates stage

    • Answered by AI
    Add your answer
Round 3 - Technical 

(1 Question)

  • Q1. In second round most they focused on scenario based questions in both datastage and SQL.
    • Add your answer
Round 4 - HR 

(1 Question)

  • Q1. Salary and location discussion
    • Add your answer

Skills evaluated in this interview

Datastage Developer Interview Questions & Answers

IBM user image Neeraj Ramesh Deshbhratar

posted on 13 Nov 2021

I applied via Naukri.com and was interviewed in Oct 2021. There were 3 interview rounds.

Interview Questionnaire 

1 Question

  • 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 Datastage developer, we might tak a pause here...
  • Ans. 

    My experience in SQL and SSIS has prepared me well for Datastage development. I am confident in my ability to quickly learn and excel in this role.

    • My experience in SQL and SSIS has given me a strong foundation in data integration and ETL processes.

    • I have already demonstrated my ability to learn quickly and adapt to new technologies, as evidenced by my success in my current role.

    • I am eager to expand my skillset and take...

    • Answered by AI
    Add your answer

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.

Skills evaluated in this interview

SQL Database Administrator Interview Questions & Answers

NTT Data user image Anonymous

posted on 11 Nov 2024

Interview experience
3
Average
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Technical 

(2 Questions)

  • Q1. Architecture of sql
  • Ans. 

    SQL architecture refers to the structure and components of a SQL database system.

    • SQL architecture includes components like storage engine, query processor, and buffer manager.

    • The storage engine manages data storage and retrieval, while the query processor processes SQL queries.

    • The buffer manager handles caching and memory management to optimize performance.

    • Examples of SQL architectures include MySQL, Oracle, and SQL Se

    • Answered by AI
    Add your answer
  • Q2. Recovery models
    • Add your answer

Skills evaluated in this interview

MS SQL DBA Interview Questions & Answers

Atos user image Anonymous

posted on 29 Mar 2023

Interview experience
4
Good
Difficulty level
-
Process Duration
-
Result
-
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 - Aptitude Test 

Asked question from basic aptitude topics

Round 3 - Technical 

(1 Question)

  • Q1. Asked question coding languages like c, python, java, SQL
    • Add your answer
Round 4 - HR 

(1 Question)

  • Q1. Discussed about terms and policies of company. Also work profile
    • Add your answer

Interview Preparation Tips

Interview preparation tips for other job seekers - I joined this company as fresher. For fresher if you are having basic aptitude and technical knowledge then it is easy to crack interview

Oracle Database Administrator Interview Questions & Answers

Tech Mahindra user image Anonymous

posted on 14 Jun 2022

Round 1 - Technical 

(1 Question)

  • Q1. Focus on mainly on the process
    • Add your answer
Round 2 - Technical 

(1 Question)

  • Q1. Focus on Bussines flow and skills set
    • Add your answer

Interview Preparation Tips

Interview preparation tips for other job seekers - Focus on more process and skill set
Technical discussion is to deep and good one

SQL Database Administrator Interview Questions & Answers

DXC Technology user image Saikiran Katukuri

posted on 11 Sep 2021

I applied via Naukri.com and was interviewed in Aug 2021. There were 3 interview rounds.

Interview Questionnaire 

1 Question

  • Q1. General questions
    • Add your answer

Interview Preparation Tips

Interview preparation tips for other job seekers - Went well with the interviewer

Informatica Developer Interview Questions & Answers

Capgemini user image Anonymous

posted on 31 Aug 2021

I was interviewed in Mar 2021.

Interview Questionnaire 

3 Questions

  • Q1. Scd type 1 implement
    • Add your answer
  • Q2. Informatica performance tuning
    • Add your answer
  • Q3. Top 3 sql query
    • Add your answer

Interview Preparation Tips

Interview preparation tips for other job seekers - Informatica developer
More about working at Accenture
golden leaf award

#5 Best Mega Company - 2022

golden leaf awardgolden leaf award

#1 Best Mega IT/ITES Company - 2022

golden leaf awardgolden leaf award

#11 Best Mega Company - 2021

golden leaf awardgolden leaf award

#3 Best Mega IT/ITES Company - 2021

golden leaf award

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.

Accenture Interviews By Designations

Interview Questions for Popular Designations

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
 • 10.3k Interviews
Infosys Interview Questions
3.7
 • 7.5k Interviews
Wipro Interview Questions
3.7
 • 5.5k Interviews
Cognizant Interview Questions
3.8
 • 5.5k Interviews
Capgemini Interview Questions
3.8
 • 4.8k Interviews
Tech Mahindra Interview Questions
3.6
 • 3.8k Interviews
HCLTech Interview Questions
3.5
 • 3.7k Interviews
Genpact Interview Questions
3.9
 • 3k Interviews
LTIMindtree Interview Questions
3.8
 • 2.9k Interviews
IBM Interview Questions
4.1
 • 2.4k Interviews
View all

Fast track your campus placements

Indian Institute of Management (IIM), Lucknow Placement Questions
60 Interviews
National Institute of Technology (NIT), Warangal Placement Questions
26 Interviews
KIIT University, Bhuvaneshwar Placement Questions
24 Interviews
Indian School of Business (ISB), Hyderabad Placement Questions
13 Interviews
Vellore Institute of Technology (VIT) Placement Questions
10 Interviews
Krishna Institute of Engineering and Technology, Ghaziabad Placement Questions
7 Interviews
Pimpri Chinchwad College of Engineering, Pimpri Placement Questions
7 Interviews
View all
Accenture Datastage Developer Salary
based on 50 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
Accenture Salaries in India
Application Development Analyst
38.9k 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
24.1k salaries
unlock blur

₹7 L/yr - ₹25.3 L/yr

Senior Software Engineer
18.4k salaries
unlock blur

₹6 L/yr - ₹19 L/yr

Software Engineer
17.6k salaries
unlock blur

₹3.6 L/yr - ₹12.8 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