IBM Data Engineer Interview Questions, Process, and Tips

Q1. 1) Project Architecture 2) Complex job handles in project 3) Types of lookup 4) SCD -2 implementation in datastage 5) sql - analytical functions,scenario based question 6) Unix - SED/GREP command
Ans. 
The interview questions cover project architecture, complex job handling, lookup types, SCD-2 implementation, SQL analytical functions, and Unix commands.
• Project architecture involves designing the overall structure of a data project.

• Complex job handling refers to managing intricate data processing tasks within a project.

• Lookup types include exact match, range match, and fuzzy match.

• SCD-2 implementation in DataStage in...read more
Answered by AI
Add your answer

Q1. Past project discussion
Add your answer

General behavioral questions

Q1. Technical Interview on previous experience. No coding.
Add your answer

Q1. Questions related to ETL, SCD -2, Scheduling
Add your answer
Q2. How would you implement SCD TYPE 2 IN INFORMATICA?
Ans. 
Implementing SCD Type 2 in Informatica involves using Slowly Changing Dimension transformations and mapping variables.
• Use Slowly Changing Dimension (SCD) transformations in Informatica to track historical changes in data.

• Create mapping variables to keep track of effective start and end dates for each record.

• Use Update Strategy transformations to handle inserts, updates, and deletes in the target table.

• Implement Type 2 ...read more
Answered by AI
Add your answer
Q3. Questions related to Control-M Scheduler and various scheduling processes
Add your answer

Q1. Work related discussions and Salary discussions
Add your answer
Q2. What kind of projects did you work in your previous organization?
Add your answer

Q1. Difference between Colease and repartition in pyspark
Ans. 
coalesce and repartition are both used to control the number of partitions in a PySpark DataFrame.
• coalesce reduces the number of partitions by combining them, while repartition shuffles the data to create new partitions

• coalesce is a narrow transformation and does not trigger a full shuffle, while repartition is a wide transformation and triggers a shuffle

• coalesce is useful when reducing the number of partitions, while ...read more
Answered by AI
Add your answer

Q1. Informatica ETL Question
Add your answer

Q1. PDM ROUND interview final
Add your answer

General aptitude questions

Coding round in java

Q1. Oops concepts in java
Ans. 
Oops concepts in Java refer to Object-Oriented Programming principles like Inheritance, Encapsulation, Polymorphism, and Abstraction.
• Inheritance: Allows a class to inherit properties and behavior from another class.

• Encapsulation: Bundling data and methods that operate on the data into a single unit.

• Polymorphism: Ability of a method to do different things based on the object it is acting upon.

• Abstraction: Hiding the imp...read more
Answered by AI
Add your answer
Q2. Function overloading and overriding
Add your answer