Upload Button Icon Add office photos
Engaged Employer

i

This company page is being actively managed by Cognizant Team. If you also belong to the team, you can get access from here

Cognizant Verified Tick

Compare button icon Compare button icon Compare
3.8

based on 47.2k Reviews

Proud winner of ABECA 2024 - AmbitionBox Employee Choice Awards

zig zag pattern zig zag pattern

Filter interviews by

Cognizant Datastage Developer Interview Questions and Answers

Updated 2 Feb 2024

3 interviews found

Sort by: Popular

Datastage Developer Interview Questions

user image Nishok Parama

posted on 2 Aug 2023

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

user image Anonymous

posted on 2 Feb 2024

Interview experience
4
 Good
Difficulty level
 -
Duration
 4-6 weeks
Result
Selected  Selected

I applied via Recruitment Consulltant and was interviewed before Feb 2023.

1 Interview Round

1

Technical Round (1 Question)

  • Q1. Explain transformer stage

Skills evaluated in this interview

Datastage Developer Interview Questions

user image Anonymous

posted on 28 Jul 2021

Interview Questions

  • Q1. Tell me about your work experience Add Answer
  • Q2. It's answer change according to projects you worked on Add Answer

Datastage Developer Jobs at Cognizant

View all

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

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.

Skills evaluated in this interview

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

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

Cognizant Interview FAQs

How many rounds are there in Cognizant Datastage Developer interview?
Cognizant interview process usually has 2-3 rounds. The most common rounds in the Cognizant interview process are Technical, Resume Shortlist and HR.
How to prepare for Cognizant 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 Cognizant. The most common topics and skills that interviewers at Cognizant expect are Datastage, Web Development, Teradata and Datastage ETL.
What are the top questions asked in Cognizant Datastage Developer interview?

Some of the top questions asked at the Cognizant Datastage Developer interview -

  1. Remove duplicate using datast...read more
  2. Explain transformer st...read more
  3. Basic questions about datastage Like difference between lookup,merge,join Quest...read more

Tell us how to improve this page.

Interview Questions from Similar Companies

TCS Interview Questions
3.7
 • 10.1k Interviews
Accenture Interview Questions
3.9
 • 7.8k Interviews
Infosys Interview Questions
3.7
 • 7.4k Interviews
Wipro Interview Questions
3.7
 • 5.5k 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.9
 • 2.7k Interviews
IBM Interview Questions
4.1
 • 2.3k Interviews
View all
Cognizant Datastage Developer Salary
based on 97 salaries
₹4.2 L/yr - ₹13.9 L/yr
10% more than the average Datastage Developer Salary in India
View more details

Cognizant Datastage Developer Reviews and Ratings

based on 1 review

5.0/5

Rating in categories

4.0

Skill development

4.0

Work-Life balance

4.0

Salary & Benefits

4.0

Job Security

4.0

Company culture

5.0

Promotions/Appraisal

4.0

Work Satisfaction

Explore 1 Review and Rating
Datastage Developer

Chennai

5-10 Yrs

Not Disclosed

Explore more jobs
Associate
72.8k salaries
unlock blur

₹5.1 L/yr - ₹16 L/yr

Programmer Analyst
54.1k salaries
unlock blur

₹2.4 L/yr - ₹9.7 L/yr

Senior Associate
48.2k salaries
unlock blur

₹8.9 L/yr - ₹27 L/yr

Senior Processing Executive
28.4k salaries
unlock blur

₹1.8 L/yr - ₹9 L/yr

Technical Lead
17.5k salaries
unlock blur

₹5.9 L/yr - ₹24 L/yr

Explore more salaries
Compare Cognizant with

TCS

3.7
Compare

Infosys

3.7
Compare

Wipro

3.7
Compare

Accenture

3.9
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