EagleDrift Technologies Interview Questions and Answers

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...read more
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 ...read more
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
Ans. 
Migrating Ab Initio components from on-premises to Cloud involves careful planning and DevOps integration.
• Assess current Ab Initio components and dependencies before migration.

• Use cloud services like AWS or Azure for hosting the Oracle DB.

• Implement CI/CD pipelines for automated deployment of Ab Initio jobs.

• Utilize containerization (e.g., Docker) for consistent environments.

• Monitor performance and optimize resource allo...read more
Answered by AI
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. Roles and responsibility
Add your answer
Q2. About experience
Add your answer

Q1. All technical questions
Add your answer

Q1. About my projects
Ans. 
I led a team to develop a scalable e-commerce platform using microservices architecture and cloud technologies.
• Implemented a microservices architecture to enhance scalability and maintainability.

• Utilized AWS services like Lambda and S3 for serverless computing and storage.

• Integrated payment gateways such as Stripe for secure transactions.

• Developed a responsive front-end using React, improving user experience.

• Conducted ...read more
Answered by AI
Add your answer

Q1. Difference Between DDL & DMl Command?
Ans. 
DDL defines database structure; DML manipulates data within that structure.
• DDL (Data Definition Language) includes commands like CREATE, ALTER, and DROP.

• Example of DDL: CREATE TABLE Employees (ID INT, Name VARCHAR(100));

• DML (Data Manipulation Language) includes commands like SELECT, INSERT, UPDATE, and DELETE.

• Example of DML: INSERT INTO Employees (ID, Name) VALUES (1, 'John Doe');

• DDL affects the schema, while DML affec...read more
Answered by AI
Add your answer
Q2. Do you know about Constraints in Sql
Ans. 
Constraints in SQL are rules applied to columns to enforce data integrity and validity.
• PRIMARY KEY: Uniquely identifies each row in a table. Example: `CREATE TABLE Users (UserID INT PRIMARY KEY);`

• FOREIGN KEY: Ensures referential integrity between tables. Example: `CREATE TABLE Orders (OrderID INT, UserID INT, FOREIGN KEY (UserID) REFERENCES Users(UserID));`

• UNIQUE: Ensures all values in a column are distinct. Example: `...read more
Answered by AI
Add your answer