EagleDrift Technologies Senior Software Engineer Interview Questions, Process, and Tips

Introduction, SQL querries that I have worked on and Salary expectations

Q1. What all things you do in Abinitio in your day-day life?
Ans. 
I use Abinitio for ETL processes, data transformation, data profiling, and data quality checks in my day-to-day work.
• Designing and developing ETL processes using Abinitio graphs

• Performing data transformation and manipulation tasks

• Conducting data profiling to analyze data quality and consistency

• Implementing data quality checks and validations

• Troubleshooting and debugging Abinitio jobs

• Collaborating with stakeholders to g
Answered by AI
Add your answer
Q2. What is the difference between watcher and breakpoint?
Ans. 
Watcher is used to monitor changes in variables during runtime, while breakpoint is used to pause program execution at a specific line of code.
• Watcher is used to track the value of a variable or expression during program execution.

• Breakpoint is used to pause the program at a specific line of code to allow for debugging.

• Watchers are typically set up in debugging tools like IDEs, while breakpoints are set by the develope...read more
Answered by AI
Add your answer
Q3. Are you aware of Spark? Do you have any experience in Spark?
Ans. 
Yes, I am aware of Spark and have experience working with it.
• I have used Spark for processing large datasets in distributed computing environments.

• I am familiar with Spark's core concepts such as Resilient Distributed Datasets (RDDs) and transformations/actions.

• I have experience writing Spark applications using languages like Scala or Python.

• I have worked with Spark SQL for querying structured data and Spark Streaming
Answered by AI
Add your answer
Q4. After getting your files from source and loading into the Oracle DB. How you are doing Migration from on-premises to Cloud of all the Abinitio components and what all things you need to implement in DevOps...read more
Add your answer
Q5. What all components you have worked in Abinitio?
Ans. 
I have worked on various components in Abinitio including GDE, Co>Operating System, Conduct>It, and EME.
• Graphical Development Environment (GDE)

• Co>Operating System (Co>OS)

• Conduct>It

• Enterprise Metadata Environment (EME)
Answered by AI
Add your answer
Q6. What is the difference between Rollup and Scan?
Ans. 
Rollup is a summary operation that combines multiple values into a single value, while Scan is an incremental operation that applies a function to each element in a sequence.
• Rollup is used to aggregate data and reduce it to a single value, while Scan is used to apply a function to each element in a sequence.

• Rollup typically produces a single output value, while Scan produces a sequence of intermediate values.

• Example: I...read more
Answered by AI
Add your answer
Q7. Have you worked in Plan? How to pass a runtime parameter from Graph task 1 to Graph task 2 within a plan with the different timings?
Ans. 
Passing a runtime parameter from one Graph task to another within a Plan with different timings.
• Use Plan variables to store the runtime parameter in Graph task 1

• Set up a trigger in Graph task 2 to read the parameter from the Plan variables

• Ensure that the timings of the Graph tasks are properly synchronized
Answered by AI
Add your answer
Q8. Do you any experience in AWS? What all services you have worked in AWS?
Ans. 
Yes, I have experience in AWS. I have worked with services like EC2, S3, RDS, Lambda, and CloudFormation.
• Experience with EC2 for deploying and managing virtual servers

• Worked with S3 for storing and retrieving data

• Utilized RDS for managing relational databases

• Implemented serverless functions using Lambda

• Used CloudFormation for infrastructure as code
Answered by AI
Add your answer
Q9. Suppose you have a CSV file and you want to convert this to an Apache file and load this to S3 bucket. How you will do it?
Ans. 
To convert a CSV file to an Apache file and load it to an S3 bucket, use Apache NiFi for data transformation and AWS SDK for S3 upload.
• Use Apache NiFi to read the CSV file, transform it into Apache format, and write it to a local directory.

• Configure an Apache NiFi processor to upload the transformed file to an S3 bucket using AWS SDK.

• Set up appropriate permissions and credentials for the S3 bucket access.

• Monitor the Ap...read more
Answered by AI
Add your answer
Q10. How good are you in SQL? Suppose we have an employee and a department table. What is the SQL querry to fetch the list of managers from an employee table who are getting 2nd highest salary from each depart...read more
Ans. 
SQL query to fetch the list of managers with 2nd highest salary from each department
• Use a subquery to find the 2nd highest salary for each department

• Join the employee table with the subquery on department and salary

• Filter the results to only include managers
Answered by AI
Add your answer

Q1. What is the difference between a hard link and a symbolic link in Unix? How do you find out the system's IP address in Unix? What is the function of the chmod command in Unix? Explain the difference betwee...read more
Ans. 
Unix related questions for Senior Software Engineer interview
• A hard link is a direct link to the physical file on disk, while a symbolic link is a reference to the file by name.

• To find out the system's IP address in Unix, you can use commands like ifconfig or ip addr show.

• The chmod command in Unix is used to change the permissions of a file or directory.

• grep is used for searching text using regular expressions, while e...read more
Answered by AI
Add your answer
Q2. How do you find out the system's IP address in Unix?
Ans. 
To find out the system's IP address in Unix, you can use the 'ifconfig' command or the 'ip addr show' command.
• Use the 'ifconfig' command to display the IP address of all network interfaces on the system.

• Alternatively, you can use the 'ip addr show' command to show the IP address information of all network interfaces.

• You can also use tools like 'hostname -I' or 'ip route get 1.2.3.4' to find out the system's IP address.
Answered by AI
Add your answer
Q3. What is the difference between INNER JOIN and LEFT JOIN?
Ans. 
INNER JOIN returns only the rows that have matching values in both tables, while LEFT JOIN returns all rows from the left table and the matched rows from the right table.
• INNER JOIN is used to retrieve rows from both tables that have matching values based on the specified condition.

• LEFT JOIN is used to retrieve all rows from the left table, along with the matched rows from the right table. If there is no match, NULL val...read more
Answered by AI
Add your answer
Q4. What are indexes in SQL and why are they important?
Ans. 
Indexes in SQL are data structures that improve the speed of data retrieval operations by allowing quick access to specific rows in a table.
• Indexes are used to quickly locate rows in a table without having to search the entire table.

• They are important because they can significantly improve the performance of SELECT queries by reducing the time taken to retrieve data.

• Indexes can be created on one or more columns in a ta...read more
Answered by AI
Add your answer

Q1. Tell me about yourself. Why do you want to work with our company? What are your strengths and weaknesses? Where do you see yourself in 5 years? Can you describe a challenging situation you faced and how yo...read more
Ans. 
I am a highly experienced Senior Software Engineer with a passion for innovative technology and a track record of successful project delivery.
• I have over 10 years of experience in software development, specializing in Java and Python.

• I am particularly interested in your company because of its reputation for cutting-edge technology and collaborative work environment.

• My strengths include strong problem-solving skills, at...read more
Answered by AI
Add your answer

Q1. All technical questions
Add your answer

Q1. About my projects
Add your answer