Infogain Interview Questions and Answers

Q1. Write a spark code to implement SCD type2.
Ans. 
Implementing SCD type2 in Spark code
• Use DataFrame operations to handle SCD type2 changes

• Create a new column to track historical changes

• Use window functions to identify the latest record for each key

• Update existing records with end dates and insert new records with start dates
Answered by AI
Add your answer
Q2. Difference between cache and persist.
Ans. 
Cache stores data temporarily for faster access, while persist saves data permanently.
• Cache is temporary storage used to store frequently accessed data for faster retrieval.

• Persist saves data permanently, typically to a disk or database.

• Cache is often used in web applications to store frequently accessed data like images or scripts.

• Persist is commonly used to store user data or application settings that need to be reta
Answered by AI
Add your answer

1. Palindrome
2. convert dictionary to data frame using pandas

Q1. Explain GCP dataflow
Ans. 
GCP Dataflow is a fully managed service for processing and analyzing streaming and batch data.
• GCP Dataflow allows for parallel processing of data in real-time or batch mode

• It automatically optimizes and scales the processing resources based on the workload

• Dataflow pipelines can be written in Java, Python, or Apache Beam SDK

• It integrates with other GCP services like BigQuery, Pub/Sub, and Datastore
Answered by AI
Add your answer
Q2. What is materialised view
Ans. 
A materialized view is a database object that contains the results of a query and is stored as a table for faster access.
• Materialized views store the results of a query and can be refreshed periodically.

• They are used to improve query performance by pre-computing and storing the results.

• Materialized views are especially useful for complex queries that involve aggregations or joins.

• They can be refreshed manually or autom...read more
Answered by AI
Add your answer

Q1. Normalisation ??????
Add your answer
Q2. Deadlock????????????????????
Add your answer

Q1. Related to market research
Add your answer

Q1. People management
Add your answer

Q1. Explain the pipeline process in Jenkins
Ans. 
Pipeline process in Jenkins automates the software delivery process.
• Pipeline is defined as code in a Jenkinsfile

• It consists of stages, steps, and post actions

• Each stage can have multiple steps like build, test, deploy

• Pipeline can be triggered manually or automatically based on events
Answered by AI
Add your answer
Q2. Which deployment strategy have you used?
Ans. 
I have used blue-green deployment strategy in previous projects.
• Blue-green deployment involves running two identical production environments, with one active and one inactive.

• Switching between the two environments allows for zero downtime deployments and easy rollback in case of issues.

• I have implemented blue-green deployment using tools like Kubernetes and Jenkins in past projects.
Answered by AI
View 3 more answers

Q1. Explain migration process of Github to Azure Repos.
Ans. 
Migration process of Github to Azure Repos involves exporting repositories from Github and importing them into Azure Repos.
• Export repositories from Github using tools like Git or Github API

• Prepare repositories for migration by cleaning up and resolving any dependencies

• Import repositories into Azure Repos using tools like Azure DevOps Services or Git commands

• Update any references or configurations to point to the new Az...read more
Answered by AI
Add your answer
Q2. In docker, how will the containers communicate?
Ans. 
Containers in Docker can communicate through networking using bridge networks, overlay networks, or user-defined networks.
• Containers can communicate with each other using IP addresses and port numbers.

• Docker provides default bridge networks for communication between containers on the same host.

• Overlay networks allow communication between containers across multiple hosts.

• User-defined networks can be created for custom c...read more
Answered by AI
Add your answer

Q1. What are all the devops tools you have used in your application deployment?
Ans. 
I have experience with a variety of devops tools including Jenkins, Docker, Kubernetes, Ansible, and Terraform.
• Jenkins

• Docker

• Kubernetes

• Ansible

• Terraform
Answered by AI
Add your answer
Q2. What is snapshot in Maven?
Ans. 
Snapshot in Maven is a version of a project that is still in development and not yet released.
• Snapshots are versions of a project that are still in development and not yet released.

• They are identified by the suffix '-SNAPSHOT' in the version number.

• Snapshots can be deployed to a Maven repository for sharing with other developers for testing purposes.

• They are not intended for production use as they are subject to freque
Answered by AI
Add your answer

Q1. What is the size of you team and what was your role?
Add your answer

Q1. Why did you leave your previous company?
Add your answer
Q2. Why do you choose to work in our company?
Add your answer

Q1. 1) details Tesgng related questions 2) how you trigger failed test cases 3) how you maintain reports
Add your answer

1) remove special character from given string
2) get string length or print each character without using inbuilt method

Q1. 1) salary discuss
Add your answer