Wipro Abinitio Developer Interview Questions and Answers

Q1. Tell about previous projects.
Ans. 
I have worked on various projects involving data integration, ETL processes, and data warehousing using Abinitio.
• Developed ETL processes to extract, transform, and load data from multiple sources into a data warehouse.

• Implemented complex data transformations and business logic using Abinitio graphs and components.

• Worked on performance tuning and optimization of Abinitio graphs to improve processing times.

• Collaborated w...read more
Answered by AI
Add your answer
Q2. Have you worked on procedures?
Ans. 
Yes, I have worked on procedures in Abinitio development.
• I have experience creating and implementing procedures in Abinitio to automate data processing tasks.

• I have written complex procedures using Abinitio's graphical interface or scripting language.

• I have optimized procedures for performance and efficiency.

• I have debugged and troubleshooted procedures to ensure they function correctly.

• I have documented procedures for
Answered by AI
Add your answer

Q1. Ab initio scenario, SQL ,Unix
Add your answer

Q1. What is difference between output index and output indexes in component, Reformat?
Ans. 
Output index is a single index while output indexes is an array of indexes in Reformat component.
• Output index refers to a single output field in Reformat component.

• Output indexes refer to multiple output fields in Reformat component.

• Output index is specified using a single integer value.

• Output indexes are specified using an array of integer values.
Answered by AI
Add your answer
Q2. How to convert a column into a row?
Ans. 
Use UNPIVOT operator in SQL to convert a column into a row.
• Use UNPIVOT operator in SQL to convert a column into a row

• Syntax: SELECT * FROM (SELECT [column_name] FROM [table_name]) AS [alias_name] UNPIVOT ([new_column_name] FOR [old_column_name] IN ([column_name])) AS [alias_name]

• Example: SELECT * FROM (SELECT col1, col2, col3 FROM table1) AS t UNPIVOT (val FOR col IN (col1, col2, col3)) AS u

• Transpose function in Excel
Answered by AI
Add your answer
Q3. Difference between partitioning and bucketing in SQL?
Ans. 
Partitioning divides a table into smaller parts while bucketing groups data based on a hash function.
• Partitioning is used to improve query performance by reducing the amount of data that needs to be scanned.

• Bucketing is used to evenly distribute data across nodes in a cluster.

• Partitioning is done based on a column or set of columns, while bucketing is done based on a hash function.

• Partitioning is commonly used in datab...read more
Answered by AI
Add your answer

Q1. What are your salary expectations?
Ans. 
I would like to discuss my salary expectations in person during the negotiation phase.
• Express willingness to discuss salary expectations during negotiation phase

• Avoid giving a specific number without understanding the full scope of the role and responsibilities

• Highlight the importance of considering factors such as experience, skills, and market value
Answered by AI
Add your answer
Q2. Share details of your previous job.
Ans. 
I worked as an Abinitio Developer in my previous job.
• Developed and maintained Abinitio graphs for data integration and transformation.

• Collaborated with cross-functional teams to gather requirements and design solutions.

• Optimized performance of Abinitio graphs by tuning parameters and implementing best practices.

• Troubleshot and resolved issues related to data processing and ETL workflows.

• Participated in code reviews and...read more
Answered by AI
Add your answer
Q3. Tell me about yourself.
Ans. 
I am an experienced Abinitio Developer with a strong background in data integration and ETL processes.
• I have been working in the field of Abinitio development for the past 5 years.

• I have expertise in designing and implementing complex data integration solutions using Abinitio.

• I am proficient in various Abinitio components such as GDE, Co>Operating System, and EME.

• I have experience in working with different databases an...read more
Answered by AI
Add your answer

Round duration - 120 Minutes
Round difficulty - Easy

Q1. 
Check Word Presence in String
Given a string S and a list wordList containing N distinct words, determine if each word in wordList is present in S. Return a boolean array where the value at index 'i' indi...read more
Ans. Brute Force
• This is an iterative approach.
• Make a boolean vector ‘result’ of size ‘N’. Initially, all the elements of this vector should be ‘False’.
• Run a loop where ‘i’ ranges from 0 to ‘N-1’  and for each word ‘Wi‘ present at ‘ith’ index of ‘wordList’, we will check whether ‘Wi‘ is a substring of string ‘S’ or not. This can be done as follow-:
           1.  If the length of ‘Wi’ is great...read more
Answered Anonymously
View 1 more answer

Round duration - 20 Minutes
Round difficulty - Easy

Q1. Design and technical
Add your answer

Q1. Role and culture fit
Add your answer

Permutations and combinations,ratio and proportion

Crypto currency

Q1. Array,pointer, function
Add your answer