Surya Informatics Python Software Developer Interview Questions and Answers

Q1. Tell me about yourself
Add your answer
Q2. Project architecture
Add your answer
Q3. Sns vs SQS architecture
Ans. 
SNS is a pub/sub messaging service while SQS is a message queue service in AWS architecture.
• SNS allows for push notifications to multiple subscribers, while SQS is used for decoupling services and handling asynchronous tasks.

• SNS is used for real-time messaging and event-driven architecture, while SQS is used for reliable message processing and scaling.

• SNS supports multiple message delivery protocols like HTTP, HTTPS, E...read more
Answered by AI
Add your answer
Q4. S3 file parking and triggers
Add your answer
Q5. Explain Eventbridge
Ans. 
Eventbridge is a serverless event bus service provided by AWS for connecting applications using events.
• Eventbridge allows different AWS services, SaaS applications, and custom applications to communicate with each other through events.

• It simplifies the process of building event-driven architectures by decoupling producers and consumers of events.

• Eventbridge can be used to trigger automated workflows, connect different ...read more
Answered by AI
Add your answer

Q1. Basic information
Add your answer

Q1. Questions on python
Add your answer
Q2. PYTHON libraries
Add your answer

Q1. What is a one-line function?
Ans. 
A one-line function is a function written in a single line of code, typically used for simple operations.
• One-line functions are concise and easy to read, often used for simple tasks like mathematical operations or string manipulation.

• They are commonly used in lambda functions in Python.

• Example: lambda x: x**2
Answered by AI
Add your answer
Q2. What is polymorphism in OOps?
Ans. 
Polymorphism in OOPs refers to the ability of a single function or method to operate on different types of data.
• Polymorphism allows objects of different classes to be treated as objects of a common superclass.

• It enables a single interface to represent different data types.

• There are two types of polymorphism: compile-time (method overloading) and runtime (method overriding).

• Example: In Python, the '+' operator can be us...read more
Answered by AI
Add your answer
Q3. Remove duplicates from the table.
Ans. 
Use SQL query with DISTINCT keyword to remove duplicates from the table.
• Use SELECT DISTINCT column_name FROM table_name to retrieve unique values from a specific column.

• Use DELETE FROM table_name WHERE column_name IN (SELECT column_name FROM table_name GROUP BY column_name HAVING COUNT(*) > 1) to remove duplicates from the table.
Answered by AI
Add your answer
Q4. Join two tables?
Ans. 
Use SQL JOIN to combine rows from two tables based on a related column between them.
• Use JOIN keyword in SQL to combine rows from two tables based on a related column

• Types of JOINs include INNER JOIN, LEFT JOIN, RIGHT JOIN, and FULL JOIN

• Example: SELECT * FROM table1 JOIN table2 ON table1.column = table2.column
Answered by AI
Add your answer

Q1. Data pipeline of AWS services
Ans. 
AWS offers a variety of services for building data pipelines, including S3, Glue, EMR, and Redshift.
• AWS S3 can be used to store raw data before processing

• AWS Glue can be used for ETL (extract, transform, load) processes

• AWS EMR can be used for processing large amounts of data using Hadoop or Spark

• AWS Redshift can be used for data warehousing and analytics
Answered by AI
Add your answer
Q2. Basics in python
Add your answer
Q3. Basic coding snippets
Add your answer

Usual maths aptitude and some logical answering

Basic coding blocks like for loop, while loop etc and their working

Q1. Python project overview
Ans. 
Python project overview
• Describe the purpose and goals of the project

• Explain the technologies and tools used in the project

• Discuss the project's architecture and design

• Highlight any challenges faced and how they were overcome
Answered by AI
Add your answer
Q2. CI/CD related with AWS
Add your answer

Q1. Basics of python
Add your answer
Q2. Practice all the basic functions and datatypes
Add your answer