Add office photos
i
Cognizant
CompareProud winner of ABECA 2024 - AmbitionBox Employee Choice Awards
Filter interviews by
Cognizant Datastage Developer Interview Questions and Answers
Cognizant Datastage Developer Interview Experiences
3 interviews found
Nishok Parama
Selected
I was interviewed before Aug 2022.
(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.
- 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
(1 Question)
- Q1. In second round most they focused on scenario based questions in both datastage and SQL.
(1 Question)
- Q1. Salary and location discussion
Skills evaluated in this interview
Anonymous
Selected
I applied via Recruitment Consulltant and was interviewed before Feb 2023. There was 1 interview round.
(1 Question)
- Q1. Explain transformer stage
- Ans.
Transformer stage is a Datastage stage used for data transformation and manipulation.
Transformer stage is used to perform complex data transformations and manipulations.
It allows users to define custom logic using graphical mapping.
It supports various functions and operators for data manipulation.
Transformer stage can be used to filter, aggregate, join, and sort data.
It can also be used to perform calculations, convers...
Skills evaluated in this interview
Interview Questionnaire
2 Questions
- Q1. Tell me about your work experience
- Q2. It's answer change according to projects you worked on
What people are saying about Cognizant
Datastage Developer Jobs at Cognizant
Interview questions from similar companies
(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...
- 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
- 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
Skills evaluated in this interview
I applied via Naukri.com and was interviewed in Mar 2024. There was 1 interview round.
(2 Questions)
- Q1. Data stage scenario
- 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...
Interview Preparation Tips
- Complete Data Stage
Skills evaluated in this interview
Datastage Developer Interview Questions & Answers
IBM
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...
Interview Preparation Tips
Skills evaluated in this interview
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
Interview Preparation Tips
Selected
I applied via Naukri.com and was interviewed in Nov 2024. There were 2 interview rounds.
(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
(1 Question)
- Q1. Salary discuss and location discussion
I applied via Approached by Company and was interviewed in Nov 2024. There was 1 interview 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?
Jayashree Shinde
I applied via Naukri.com and was interviewed in Jul 2024. There was 1 interview round.
(5 Questions)
- Q1. Analytical functions difference
- Ans.
Analytical functions are used to perform calculations across a set of rows related to the current row.
Analytical functions operate on a group of rows and return a single result for each row
They can be used to calculate running totals, moving averages, rank, percentiles, etc.
Examples include ROW_NUMBER(), RANK(), SUM() OVER(), AVG() OVER()
- Q2. Which transformation uses in scd2?
- Ans.
The Slowly Changing Dimension Type 2 (SCD2) transformation is used for handling historical data changes in a data warehouse.
SCD2 transformation is used to track historical changes in dimension tables.
It maintains multiple versions of a record by adding new rows with updated information and end-dating the previous record.
Commonly used in scenarios where historical data needs to be preserved and queried.
Example: When a c...
- 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?
- Ans.
To find the count of different types of joins between two tables A and B.
Left join: Includes all records from table A and matching records from table B.
Right join: Includes all records from table B and matching records from table A.
Inner join: Includes only the matching records from both tables.
Full outer join: Includes all records when there is a match in either table A or table B.
- Q5. Incremental load
Skills evaluated in this interview
Cognizant Interview FAQs
Tell us how to improve this page.
Cognizant Interviews By Designations
- Cognizant Programmer Analyst Interview Questions
- Cognizant Programmer Analyst Trainee Interview Questions
- Cognizant Associate Interview Questions
- Cognizant Senior Associate Interview Questions
- Cognizant Processing Executive Interview Questions
- Cognizant Software Engineer Interview Questions
- Cognizant Senior Processing Executive Interview Questions
- Cognizant Software Developer Interview Questions
- Show more
Interview Questions for Popular Designations
- Oracle Database Administrator Interview Questions
- ETL Developer Interview Questions
- Database Developer Interview Questions
- SQL Database Administrator Interview Questions
- MS SQL DBA Interview Questions
- Informatica Developer Interview Questions
- Lead Data Engineer Interview Questions
- Data Architect Interview Questions
- Show more
Cognizant Datastage Developer Interview Process
based on 2 interviews
Interview experience
Interview Questions from Similar Companies
Fast track your campus placements
Cognizant Datastage Developer Reviews and Ratings
based on 1 review
Rating in categories
|
Associate
72.4k
salaries
|  ₹5.1 L/yr - ₹16 L/yr |
|
Programmer Analyst
55.5k
salaries
| ₹2.4 L/yr - ₹9.8 L/yr |
|
Senior Associate
48.4k
salaries
| ₹9 L/yr - ₹27.2 L/yr |
|
Senior Processing Executive
28.7k
salaries
| ₹1.8 L/yr - ₹9 L/yr |
|
Technical Lead
17.6k
salaries
| ₹5.9 L/yr - ₹24.5 L/yr |
TCS
Infosys
Wipro
Accenture
- Home >
- Interviews >
- Cognizant Interview Questions >
- Cognizant Datastage Developer Interview Questions
