Agilisium Interview Questions and Answers

SQL, Python Coding intermediate questions

Intermediate coding questions

Q1. Salary Discussion
Ans. 
Discussing salary expectations is crucial for aligning compensation with skills and market standards.
• Research industry standards: Use websites like Glassdoor or Payscale to find average salaries for similar roles.

• Consider your experience: Highlight your years of experience and specific skills that add value to the company.

• Discuss total compensation: Include benefits, bonuses, and stock options in the salary discussion.

• ...read more
Answered by AI
Add your answer
Q2. Policy Discussion and other perks provided by the company
Add your answer

Basic Apti , ex train ,speed work

From Leetcode questions

Q1. Related about real time java questions
Add your answer

Q1. They ask about the skills we worked
Add your answer
Q2. In our project like java, selenium, Api
Add your answer

Q1. They asked about the skills
Add your answer

Q1. Ranking code in sql
Ans. 
Ranking code in SQL
• Use the RANK() function to assign a rank to each row based on a specified column

• Use the ORDER BY clause to determine the order of ranking

• Handle ties in ranking using the DENSE_RANK() function

• Use the ROW_NUMBER() function to assign a unique number to each row
Answered by AI
Add your answer
Q2. Read a file using python
Ans. 
To read a file using Python, use the open() function and specify the file path and mode.
• Use the open() function to open the file

• Specify the file path and mode (e.g., 'r' for reading)

• Read the contents of the file using the read() method

• Close the file using the close() method
Answered by AI
Add your answer
Q3. Reverse a array string using python
Ans. 
Reverses an array of strings using Python.
• Use the reverse() method to reverse the array in-place.

• Alternatively, use slicing with a step of -1 to create a new reversed array.

• Remember to convert the array to a list before reversing if necessary.
Answered by AI
Add your answer

Q1. It was a basic screening round as it was a virtual walk-in drive so was asked basic details about my work experience
Ans. 
I have extensive experience in data engineering, focusing on ETL processes, data warehousing, and big data technologies.
• Proficient in ETL tools like Apache NiFi and Talend for data integration.

• Experience with cloud platforms such as AWS and Azure for data storage solutions.

• Worked on data warehousing projects using Snowflake and Redshift.

• Implemented data pipelines using Apache Spark for real-time data processing.

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

Q1. What do you worked on AWS
Ans. 
I have extensive experience with various AWS services tailored for data engineering tasks.
• Amazon S3 for data storage and retrieval, enabling scalable data lakes.

• AWS Glue for ETL processes, automating data preparation and transformation.

• Amazon Redshift for data warehousing, allowing complex queries on large datasets.

• Amazon RDS for relational database management, ensuring high availability and scalability.

• AWS Lambda for ...read more
Answered by AI
Add your answer
Q2. SQL aggregate and window question
Add your answer
Q3. Coding In python
Add your answer

Q1. AWS S3 Questions
Add your answer
Q2. AWS lambda Questions
Add your answer
Q3. AWS Redshift Questions
Add your answer

Q1. Why left previous company
Ans. 
Seeking new challenges and growth opportunities
• Desire for new challenges and growth

• Looking for a more innovative environment

• Seeking better work-life balance
Answered by AI
Add your answer
Q2. Salary Discussion
Add your answer