AmbitionBox
Interview Questions
- Reviews
- Salaries
- Interview Questions
- About Company
- Benefits
- Jobs
- Office Photos
- Community
Add office photos
i
Infomerica
Compare
Filter interviews by
Infomerica Principal Software Engineer Interview Questions and Answers
Infomerica Principal Software Engineer Interview Experiences
2 interviews found
Uday Kiran
Selected
I applied via Naukri.com and was interviewed in Mar 2023. There were 3 interview rounds.
(4 Questions)
- Q1. Python, pySpark and SQL
- Ans. Python basics spark jobs and pyspark basics sql intermeidate skills
- 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
- 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.
- 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...
(1 Question)
- Q1. Salary Negotiations and past experience
Interview Preparation Tips
- SQL
- Python
- pyspark
- data engineering
- Azure
Skills evaluated in this interview
Selected
I applied via Approached by Company and was interviewed before Jun 2023. There were 3 interview rounds.
(1 Question)
- Q1. Technical questions related to coding
Scenario based questions
(1 Question)
- Q1. Salary discussions
Top trending discussions
Interview questions from similar companies
Software Engineer Interview Questions & Answers
Thinkitive Technologies
Anonymous
posted on 4 May 2019
I applied via Naukri.com and was interviewed in Oct 2018. There were 3 interview rounds.
Interview Questionnaire
3 Questions
- Q1. Asked me to draw spring mvc architecture and about collection framework.
- Q2. Asked me to write the logic for pattern.
- Q3. Asked me on core java.
Interview Preparation Tips
Skills: Communication
Duration: <1 week
Randeep Singh
I applied via Company Website and was interviewed before Dec 2019. There were 3 interview rounds.
Interview Questionnaire
1 Question
- Q1. Regarding OOPS, wordpress and laravel.
Interview Preparation Tips
Software Engineer Interview Questions & Answers
Thinkitive Technologies
Anonymous
posted on 5 Oct 2023
Selected
I applied via Company Website and was interviewed before Oct 2022. There were 5 interview rounds.
Duration is around 1 hour
(1 Question)
- Q1. 1. Basic programming concepts 2. OOP concepts and basic problem solving skills
(1 Question)
- Q1. Programming question
(1 Question)
- Q1. 1. Basic questions
Software Engineer Interview Questions & Answers
Thinkitive Technologies
Anonymous
posted on 2 Jul 2024
(2 Questions)
- Q1. Second largest number in an array
- Ans.
Find the second largest number in an array of strings.
Convert the strings to numbers for comparison.
Sort the array in descending order.
Return the second element in the sorted array.
- Q2. Pairs with given sum
- Ans.
Find pairs in an array that sum up to a given target value.
Use a hash set to store the difference between the target value and each element in the array.
Iterate through the array and check if the current element's complement exists in the hash set.
Return the pairs that sum up to the target value.
Skills evaluated in this interview
Software Engineer Interview Questions & Answers
Thinkitive Technologies
Anonymous
posted on 2 Aug 2024
Selected
I applied via Approached by Company and was interviewed before Aug 2023. There was 1 interview round.
(2 Questions)
- Q1. OOPS based questions
- Q2. Basic language based questions
Software Engineer Interview Questions & Answers
Thinkitive Technologies
Aditya Gupta
posted on 13 Aug 2024
Selected
I applied via Referral and was interviewed in Jul 2024. There was 1 interview round.
(2 Questions)
- Q1. What is single page application
- Ans.
Single page application is a web application that loads a single HTML page and dynamically updates the content as the user interacts with the app.
SPA uses AJAX and HTML5 to create fluid and responsive user experience.
It eliminates the need for page reloading during use, making it faster and more efficient.
Examples include Gmail, Facebook, and Google Maps.
- Q2. What is state management
- Ans.
State management is the process of managing the state of an application, including data flow, user interface updates, and user interactions.
State management involves storing and updating the state of an application to ensure data consistency.
It helps in managing user interface updates based on changes in the application state.
State management is crucial for handling user interactions and maintaining a seamless user exp...
Skills evaluated in this interview
Software Developer Interview Questions & Answers
Hummingbird Web Solutions
Anonymous
posted on 12 Sep 2023
Selected
I applied via Naukri.com and was interviewed before Sep 2022. There were 3 interview rounds.
(2 Questions)
- Q1. Basic JS questions
- Q2. String Concat through function
Advanced JS, PHP related questions
Interview Preparation Tips
(1 Question)
- Q1. Tell me about yourself
Infomerica Interview FAQs
Tell us how to improve this page.
Infomerica Interviews By Designations
Interview Questions for Popular Designations
- Principal Engineer Interview Questions
- Principal Consultant Interview Questions
- Principal Interview Questions
- Associate Principal Engineer Interview Questions
- Principal Architect Interview Questions
- Senior Principal Engineer Interview Questions
- School Principal Interview Questions
- Senior Principal Consultant Interview Questions
- Show more
Infomerica Principal Software Engineer Interview Process
based on 3 interviews
Interview experience
Interview Questions from Similar Companies
Infomerica Principal Software Engineer Reviews and Ratings
based on 7 reviews
Rating in categories
|
Senior Software Engineer
53
salaries
|  ₹10 L/yr - ₹23 L/yr |
|
Software Engineer
52
salaries
| ₹3.9 L/yr - ₹15.4 L/yr |
|
Associate Software Engineer
18
salaries
| ₹2.6 L/yr - ₹6 L/yr |
|
Principal Software Engineer
16
salaries
| ₹15 L/yr - ₹35 L/yr |
|
QA Engineer
16
salaries
| ₹3 L/yr - ₹9 L/yr |
Accel Frontline
Northcorp Software
Elentec Power India (EPI) Pvt. Ltd.
HyScaler
- Home >
- Interviews >
- Infomerica Interview Questions >
- Infomerica Principal Software Engineer Interview Questions
