IPAC AWS Engineer Interview Questions and Answers

Q1. It was hiring drive face to face interview
Add your answer
Q2. Project related indepth discussions
Add your answer
Q3. Medium level SQL and DSA
Add your answer
Q4. Sorting colors DSA problem
Ans. 
Sort an array of colors in a specific order
• Use a custom sorting function to sort the colors based on a predefined order

• Map each color to a numerical value and sort based on that value

• Consider using a hashmap to store the order of colors
Answered by AI
Add your answer
Q5. In depth spark optimization question
Add your answer

Q1. Wxaplinnyour project
Add your answer
Q2. How would you build a pipeline to connect http source and bring data in adls
Ans. 
Build a pipeline to connect http source and bring data in adls
• Set up a data ingestion tool like Apache NiFi or Azure Data Factory to pull data from the http source

• Transform the data as needed using tools like Apache Spark or Azure Databricks

• Store the data in Azure Data Lake Storage (ADLS) for further processing and analysis
Answered by AI
Add your answer
Q3. Dimension and fact tabel difference
Ans. 
Dimension tables store descriptive attributes while fact tables store quantitative data.
• Dimension tables contain attributes that describe the business entities, such as customer, product, or time.

• Fact tables contain quantitative data or metrics that are typically numeric and additive, such as sales revenue or quantity sold.

• Dimension tables are denormalized and have a one-to-many relationship with fact tables.

• Fact table...read more
Answered by AI
Add your answer
Q4. Write slq query to get employee having 2manager
Ans. 
Use a self join to find employees with 2 managers in SQL query.
• Use a self join on the employee table to join the table with itself.

• Count the number of distinct managers for each employee.

• Filter the results to only include employees with 2 managers.
Answered by AI
Add your answer
Q5. Get second highest salary usingSQL
Add your answer

2 coding questions asked meeting rooms ds algo

Q1. .net core framework, .net core MVC, Vue js , js , SQL
Add your answer

Q1. .net core question
Add your answer
Q2. .net mvc questions
Add your answer
Q3. Authentication in .net
Ans. 
Authentication in .NET involves verifying the identity of users accessing a system.
• Use ASP.NET Identity for user authentication and authorization

• Implement OAuth for secure authentication with third-party services

• Utilize JWT tokens for stateless authentication

• Implement multi-factor authentication for added security
Answered by AI
Add your answer
Q4. About your project architecture
Add your answer
Q5. Sql related questions
Add your answer
Q6. Entity framework
Add your answer

Q1. Technical interview related to ooo
Add your answer

Had multiple questions on Array and String overall the difficulty level was medium the interviewer was friendly and patient

Q1. Had Discussion on the projects I made it was related to mern stack so he asked me questions regarding that also asked questions on DBMS and OS
Add your answer

Q1. Simple Scenario based questions
Add your answer

Q1. React js questions like Dom manipulation, useCallback and useMemo these kind of questions
Add your answer
Q2. Create some dynamic buttons with a json data and whenever you click on that you need to maintain active and inactive states and also you need to show the content of the button based on the json data whenev...read more
Ans. 
Create dynamic buttons with JSON data, maintain active/inactive states, and show content on click
• Create buttons dynamically using JSON data

• Toggle between active and inactive states on click

• Display button content based on JSON data on click
Answered by AI
Add your answer

Q1. More advanced react based questions like test cases handling and redux state management techniques
Add your answer
Q2. Prop drilling concepts
Add your answer

Q1. More about your projects you have worked on and also front end technical basic questions
Add your answer

Q1. Why Lowe's only
Ans. 
Lowe's is a leading home improvement retailer with a strong focus on technology and innovation.
• Lowe's has a strong reputation for investing in technology and innovation within the home improvement industry.

• I am impressed by Lowe's commitment to digital transformation and their use of cutting-edge tools and technologies.

• I believe Lowe's offers a challenging and rewarding environment for software engineers to grow and de...read more
Answered by AI
Add your answer
Q2. What are your expectations here nd all
Ans. 
I expect a challenging work environment, opportunities for growth, and a supportive team.
• Challenging work that allows me to utilize my skills and learn new technologies

• Opportunities for career advancement and professional development

• A supportive team that fosters collaboration and growth

• Clear communication and expectations from management
Answered by AI
Add your answer

Q1. Array, Tree based questions
Add your answer

Q1. Managerial round with a dive into the projects
Add your answer