Infomerica Principal Software Engineer Interview Questions and Answers

Q1. Python, pySpark and SQL
Ans. Python basics spark jobs and pyspark basics sql intermeidate skills
Answered by Uday Kiran
Add your answer
Q2. Write data to external table
Ans. 
To write data to an external table
• Use SQL INSERT INTO statement to insert data into the external table

• Make sure to specify the table name and column names in the INSERT INTO statement

• Ensure that the data being inserted matches the data types of the columns in the external table
Answered by AI
Add your answer
Q3. Window functions in sql
Ans. 
Window functions in SQL are used to perform calculations across a set of table rows related to the current row.
• Window functions are used to calculate values based on a set of rows related to the current row

• They can be used with aggregate functions like SUM, AVG, etc.

• Common window functions include ROW_NUMBER, RANK, DENSE_RANK, LAG, LEAD, etc.
Answered by AI
Add your answer
Q4. Joins and merge in sql and python
Ans. 
Joins and merges are used to combine data from multiple tables in SQL and Python.
• Joins in SQL are used to combine rows from two or more tables based on a related column between them.

• Types of joins in SQL include INNER JOIN, LEFT JOIN, RIGHT JOIN, and FULL JOIN.

• Merging in Python is done using the pandas library, where two DataFrames are combined based on a common column.

• Example: SQL - SELECT * FROM table1 INNER JOIN tab...read more
Answered by AI
Add your answer

Q1. Salary Negotiations and past experience
Add your answer

Q1. Technical questions related to coding
Add your answer

Scenario based questions

Q1. Salary discussions
Add your answer