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

Proud winner of ABECA 2024 - AmbitionBox Employee Choice Awards

zig zag pattern zig zag pattern

Filter interviews by

Cognizant Associate Data Engineer Interview Questions, Process, and Tips for Experienced

Updated 19 Oct 2021

Top Cognizant Associate Data Engineer Interview Questions and Answers for Experienced

View all 10 questions

Cognizant Associate Data Engineer Interview Experiences for Experienced

3 interviews found

Interview Questionnaire 

5 Questions

  • Q1. How to find 3rd Highest salary in Sql.
  • Q2. How to delete duplicate rows in Sql
  • Ans. 

    Deleting duplicate rows in SQL

    • Use the DISTINCT keyword in SELECT statement to retrieve unique rows

    • Use GROUP BY clause to group rows with same values and then use aggregate functions to select one row

    • Use the ROW_NUMBER() function to assign a unique number to each row and then delete the rows with duplicate numbers

  • Answered by AI
  • Q3. Datastge - How will you remove Header and trailer from Sequential data file
  • Ans. 

    To remove header and trailer from a sequential data file in Datastage.

    • Use Sequential File stage in Datastage.

    • Set the 'Skip Rows' property to the number of header rows to be skipped.

    • Set the 'Trailer Rows' property to the number of trailer rows to be skipped.

    • Use a Transformer stage to remove any remaining header or trailer rows.

    • Use the 'Remove' function in the Transformer stage to remove the rows.

  • Answered by AI
  • Q4. How would you kill any job in Datastage
  • Ans. 

    To kill a job in Datastage

    • Stop the job manually from the Director client

    • Terminate the job from the command line using the dsjob command

    • Kill the job process from the operating system level

    • Delete the job from the Datastage repository

  • Answered by AI
  • Q5. How to find process id in linux
  • Ans. 

    To find process id in Linux, use the command 'ps -aux | grep '

    • Open the terminal

    • Type 'ps -aux' to list all running processes

    • Use 'grep ' to filter the process you are looking for

    • The process id (PID) will be listed in the second column

Answered by AI

Interview Questionnaire 

6 Questions

  • Q1. Basics of HIVE AND SPARK
  • Q2. SQL QUERIES WITH WINDOW FUNCTION
  • Ans. 

    SQL queries with window functions

    • Window functions perform calculations across a set of rows that are related to the current row

    • Common window functions include ROW_NUMBER, RANK, DENSE_RANK, and NTILE

    • Window functions are used with the OVER() clause to define the window or subset of rows to perform the calculation on

  • Answered by AI
  • Q3. SORT BY ORDER BY CLUSTER BY DISTRIBUTE BY
  • Ans. 

    SORT BY, ORDER BY, CLUSTER BY, and DISTRIBUTE BY are SQL clauses used for data sorting and partitioning.

    • SORT BY is used to sort the result set in ascending or descending order based on one or more columns.

    • ORDER BY is used to sort the result set in ascending or descending order based on one or more columns. It is similar to SORT BY but can be used with other clauses like LIMIT and OFFSET.

    • CLUSTER BY is used to group data...

  • Answered by AI
  • Q4. SPARK OOM ISSUE
  • Q5. SMALL FILE PROBLEM
  • Ans. 

    Small file problem refers to the issue of having a large number of small files in a storage system.

    • Small files can cause inefficiencies in storage and processing.

    • Solutions include consolidating small files into larger ones or using a different storage system.

    • Examples include Hadoop's SequenceFile format and Amazon S3's object size optimization.

  • Answered by AI
  • Q6. RDS VA DF VS DS
  • Ans. 

    RDS, VA, DF, VS, and DS are all acronyms related to data engineering.

    • RDS stands for Relational Database Service, a managed database service by AWS.

    • VA stands for Virtual Assistant, a software program that can assist with tasks.

    • DF stands for Dataflow, a managed service by Google Cloud for data processing.

    • VS stands for Virtual Server, a server that runs on a virtual machine.

    • DS stands for Datastore, a NoSQL document databa

  • Answered by AI

Skills evaluated in this interview

Associate Data Engineer Interview Questions Asked at Other Companies for Experienced

asked in Cognizant
Q1. Datastge - How will you remove Header and trailer from Sequential ... read more
asked in Cognizant
Q2. How to delete duplicate rows in Sql
asked in Cognizant
Q3. How to find process id in linux
asked in Cognizant
Q4. Reading Data from a .log file and finding out each column with a ... read more
asked in Cognizant
Q5. How would you kill any job in Datastage

I applied via Recruitment Consultant and was interviewed before Jun 2020. There were 4 interview rounds.

Interview Questionnaire 

6 Questions

  • Q1. Reading Data from a .log file and finding out each column with a specific regex.
  • Ans. 

    Reading data from a .log file and extracting columns with a specific regex.

    • Use Python's built-in 're' module to define the regex pattern.

    • Open the .log file using Python's 'open' function.

    • Iterate through each line of the file and extract the desired columns using the regex pattern.

    • Store the extracted data in a data structure such as a list or dictionary.

  • Answered by AI
  • Q2. Asked to find count and profit from the data for last 4 years
  • Q3. Optimizations I can use
  • Ans. 

    Optimizations for data engineering

    • Use indexing to speed up queries

    • Partition data to improve query performance

    • Use caching to reduce data retrieval time

    • Optimize data storage format for faster processing

    • Use parallel processing to speed up data processing

    • Optimize network bandwidth usage

    • Use compression to reduce storage and network usage

  • Answered by AI
  • Q4. Python JSON reading
  • Ans. 

    Answering how to read JSON in Python.

    • Use the json module to load and parse JSON data

    • Use the json.loads() method to load JSON data from a string

    • Use the json.load() method to load JSON data from a file

    • Access JSON data using keys or indexes

    • Use the json.dumps() method to convert Python objects to JSON strings

  • Answered by AI
  • Q5. Array, List - Python scenarios
  • Q6. Pyspark configs
  • Ans. 

    Pyspark configs

    • Pyspark configs are used to configure the behavior of a Pyspark application.

    • They can be set using SparkConf object or spark-submit command.

    • Examples include setting the number of executors, memory allocation, and log level.

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - Very easy if you have prev work exp.

Skills evaluated in this interview

Interview questions from similar companies

I applied via Company Website and was interviewed before Oct 2021. There were 5 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 - Aptitude Test 

Basic Aptitude with some difficult questions

Round 3 - Coding Test 

3 set of coding question were asked 1 easy ,1 medium ,1 hard

Round 4 - One-on-one 

(1 Question)

  • Q1. This was personal technical interview asking all related to my cv and the one they are looking for
Round 5 - HR 

(1 Question)

  • Q1. Basic personality questions

Interview Preparation Tips

Interview preparation tips for other job seekers - Prepare everything basic and from the CV and you will be good to go.Research about the company a bit that will add cherry on top.

I applied via Campus Placement and was interviewed in Oct 2020. There were 3 interview rounds.

Interview Questionnaire 

4 Questions

  • Q1. What is difference between C and C++ programming ?
  • Ans. 

    C++ is an extension of C programming language with added features like object-oriented programming.

    • C++ supports object-oriented programming while C does not.

    • C++ has classes and objects while C does not.

    • C++ has function overloading and operator overloading while C does not.

    • C++ has exception handling while C does not.

    • C++ supports namespaces while C does not.

  • Answered by AI
  • Q2. What is difference between micro-processor and micro controller ? What is 555 IC ? (Because, I am form E&C field)
  • Ans. 

    Micro-processor and micro-controller differ in their architecture and usage. 555 IC is a timer IC used in electronic circuits.

    • Micro-processor is a CPU with minimal peripherals while micro-controller has CPU, memory, and peripherals on a single chip.

    • Micro-processor is used in applications that require high processing power while micro-controller is used in embedded systems.

    • 555 IC is a timer IC that can be used in variou...

  • Answered by AI
  • Q3. How C++ makes coding easy in comparison to C programming ?
  • Ans. 

    C++ provides object-oriented programming and better memory management than C.

    • C++ supports classes and objects which makes code modular and reusable.

    • C++ has better memory management with features like constructors and destructors.

    • C++ supports function overloading and operator overloading which makes code more readable.

    • C++ has a rich library of built-in functions and data types.

    • C++ supports exception handling which makes...

  • Answered by AI
  • Q4. Questions about project mentioned.

Interview Preparation Tips

Interview preparation tips for other job seekers - Learn all about the skills mentioned in your resume.
Be confident through your interview.
Learn the basics of your stream.
Don't be too friendly with the interviewer, maintain the discipline.
Learn in depth about the projects mentioned and about their advantages.

Skills evaluated in this interview

Interview Questionnaire 

1 Question

  • Q1. About company

Interview Questionnaire 

1 Question

  • Q1. TELL ME ABOUT UR SELF

Interview Preparation Tips

Interview preparation tips for other job seekers - ITS GOOD

Interview Questionnaire 

1 Question

  • Q1. How maintain your role?

Interview Preparation Tips

Interview preparation tips for other job seekers - Focus body language

I applied via Referral and was interviewed before Jun 2020. There were 3 interview rounds.

Interview Questionnaire 

1 Question

  • Q1. Technical questions.

Interview Preparation Tips

Interview preparation tips for other job seekers - Good job security but do not expect projects with latest technologies or development side.

If you are lucky you will get project with new technologies and you can learn.

I applied via Campus Placement and was interviewed in May 2021. There was 1 interview round.

Interview Questionnaire 

1 Question

  • Q1. What you see yourself after 10 years from now?

Interview Preparation Tips

Interview preparation tips for other job seekers - Be who you are don't panic in thinking what should you answer what comes in your mind first speak that out with full confidence.

Cognizant Interview FAQs

What are the top questions asked in Cognizant Associate Data Engineer interview for experienced candidates?

Some of the top questions asked at the Cognizant Associate Data Engineer interview for experienced candidates -

  1. Datastge - How will you remove Header and trailer from Sequential data f...read more
  2. How to delete duplicate rows in ...read more
  3. How to find process id in lin...read more

Tell us how to improve this page.

Interview Questions from Similar Companies

TCS Interview Questions
3.7
 • 10.7k Interviews
Accenture Interview Questions
3.8
 • 8.3k Interviews
Infosys Interview Questions
3.6
 • 7.7k Interviews
Wipro Interview Questions
3.7
 • 5.7k Interviews
Capgemini Interview Questions
3.7
 • 4.9k Interviews
HCLTech Interview Questions
3.5
 • 3.9k Interviews
Tech Mahindra Interview Questions
3.5
 • 3.9k Interviews
Genpact Interview Questions
3.8
 • 3.2k Interviews
IBM Interview Questions
4.0
 • 2.4k Interviews
DXC Technology Interview Questions
3.7
 • 805 Interviews
View all
Cognizant Associate Data Engineer Salary
based on 108 salaries
₹4.5 L/yr - ₹11.6 L/yr
10% less than the average Associate Data Engineer Salary in India
View more details

Cognizant Associate Data Engineer Reviews and Ratings

based on 6 reviews

2.9/5

Rating in categories

2.9

Skill development

2.9

Work-life balance

2.5

Salary

3.0

Job security

3.0

Company culture

2.6

Promotions

2.8

Work satisfaction

Explore 6 Reviews and Ratings
Associate
72.4k salaries
unlock blur

₹5.1 L/yr - ₹16 L/yr

Programmer Analyst
55.6k salaries
unlock blur

₹2.4 L/yr - ₹9.3 L/yr

Senior Associate
50.3k salaries
unlock blur

₹9 L/yr - ₹28.6 L/yr

Senior Processing Executive
29.1k salaries
unlock blur

₹1.8 L/yr - ₹9.2 L/yr

Technical Lead
17.7k salaries
unlock blur

₹6 L/yr - ₹25 L/yr

Explore more salaries
Compare Cognizant with

TCS

3.7
Compare

Infosys

3.6
Compare

Wipro

3.7
Compare

Accenture

3.8
Compare
Did you find this page helpful?
Yes No
write
Share an Interview