Infomerica 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

GD was conducted with a group of 20 at a time on a general topic.

It was a test on MCQ's on programming ,reasoning and aptitude

Q1. Questions on resume and basic skill test
Add your answer

Q1. Technical questions related to coding
Add your answer

Scenario based questions

Q1. Salary discussions
Add your answer

Q1. Tell me about yourself and also previous company roles and responsibilities.
Ans. 
I am an experienced software engineer with expertise in developing and maintaining complex software systems.
• Worked as a Senior Software Engineer at XYZ Company for 5 years

• Developed and maintained software systems for clients in various industries

• Led a team of developers in designing and implementing software solutions

• Collaborated with cross-functional teams to ensure project success

• Continuously improved software develo...read more
Answered by AI
Add your answer
Q2. What are your Azure skills?
Ans. 
I have extensive experience in Azure cloud computing and have worked on various services such as Azure Functions, Azure App Service, Azure Storage, and Azure SQL Database.
• Proficient in deploying and managing applications on Azure

• Experience in designing and implementing Azure solutions

• Familiarity with Azure DevOps for CI/CD pipelines

• Expertise in Azure Functions for serverless computing

• Knowledge of Azure App Service for ...read more
Answered by AI
Add your answer

Q1. From the Azure perspective, what are the tasks you have handled in previous project?
Add your answer
Q2. About the previous project and its flow.
Add your answer

Q1. What are your salary expectations?
Ans. 
I am open to discussing a salary that is commensurate with my experience and the responsibilities of the role.
• I am looking for a fair and competitive salary based on industry standards and my qualifications.

• I am willing to negotiate and consider other benefits such as healthcare, retirement plans, and vacation time.

• I am also interested in opportunities for growth and advancement within the company.

• Based on my research,...read more
Answered by AI
Add your answer
Q2. What is your family background?
Ans. 
My family background is diverse and multicultural.
• My parents are from different countries and cultures.

• I grew up speaking multiple languages at home.

• My family values education and hard work.

• We enjoy learning about different cultures and trying new foods.

• Family is very important to us and we stay connected despite living in different parts of the world.
Answered by AI
Add your answer
Q3. Share details of your previous job.
Ans. 
I worked as a Senior Software Engineer at XYZ Corp.
• Developed and maintained software applications using Java and Python

• Collaborated with cross-functional teams to deliver projects on time

• Implemented agile methodologies to improve project management

• Mentored junior developers and conducted code reviews

• Contributed to the development of company-wide coding standards
Answered by AI
Add your answer
Q4. Why are you looking for a change?
Add your answer
Q5. Where do you see yourself in 5 years?
Add your answer
Q6. What are your strengths and weaknesses?
Ans. 
My strengths include problem-solving, teamwork, and adaptability. My weakness is public speaking.
• Strengths: Problem-solving - I enjoy finding solutions to complex problems. Teamwork - I work well with others and value collaboration. Adaptability - I am able to quickly adapt to new situations and technologies.

• Weakness: Public speaking - I get nervous when speaking in front of large groups, but I am actively working to i
Answered by AI
Add your answer
Q7. Tell me about yourself.
Ans. 
I am a senior software engineer with over 10 years of experience in developing and implementing software solutions.
• Proficient in multiple programming languages including Java, Python, and C++

• Experienced in developing web applications using frameworks such as Spring and Django

• Skilled in database design and management using SQL and NoSQL databases

• Strong understanding of software development methodologies such as Agile an...read more
Answered by AI
Add your answer

Q1. Previous company experience on the Azure technology. and what are the challenges faced while working in the project?
Add your answer