Wipro Interview Questions, Process, and Tips for Experienced

Q1. How Terraform works in background end to end?
Ans. 
Terraform automates infrastructure provisioning by defining configuration in code.
• Terraform reads configuration files written in HashiCorp Configuration Language (HCL)

• It creates an execution plan to determine what actions are necessary to achieve the desired state

• Terraform then executes the plan to build the infrastructure

• It tracks the state of the infrastructure and can make changes as needed

• Terraform supports various
Answered by AI
Add your answer
Q2. How Argo Cd bested architecture should establish for multiple env with less efforts?
Ans. 
Establishing a scalable Argo CD architecture for multiple environments with minimal effort.
• Utilize Argo CD Applications to manage configurations for different environments

• Leverage Argo CD Projects to group related applications and manage access control

• Implement GitOps principles to automate deployment workflows and ensure consistency

• Use Helm charts to define application dependencies and simplify deployment configuratio
Answered by AI
Add your answer
Q3. How terraform Metaarguments works in multiple scenario scenarios
Ans. 
Terraform Metaarguments are used to modify the behavior of resources in different scenarios.
• Metaarguments can be used to control how Terraform handles resources, such as count, depends_on, lifecycle, provider, etc.

• They can be used to define dependencies between resources, manage resource creation and deletion, and specify resource behavior.

• Metaarguments can be used in various scenarios like defining resource dependenci...read more
Answered by AI
Add your answer

Q1. How terraform works for Multiple env without workspace using composite modules?
Ans. 
Terraform can manage multiple environments without using workspaces by utilizing composite modules.
• Use composite modules to define reusable components that can be shared across multiple environments.

• Leverage variables and input parameters to customize the behavior of the composite modules for each environment.

• Organize the infrastructure code in a modular and scalable way to easily manage multiple environments.

• Avoid usi...read more
Answered by AI
Add your answer
Q2. How to write composite terraform module and pass their values to other modules.
Ans. 
Creating composite Terraform modules and passing values to other modules.
• Create a main module that calls other modules

• Define input variables in the main module and pass them to the child modules

• Use output variables in the child modules to return values to the main module

• Example: main.tf calls moduleA and moduleB, passing variables and using outputs
Answered by AI
Add your answer

Q1. How you handle team if you multiple pressure ?
Ans. 
I prioritize tasks, delegate effectively, communicate openly, and provide support to ensure team members are not overwhelmed.
• Prioritize tasks based on urgency and impact

• Delegate tasks to team members based on their strengths and workload

• Communicate openly about the pressure and work together to find solutions

• Provide support and resources to help team members manage their workload effectively
Answered by AI
Add your answer
Q2. How you will support your team in case your are on vacation in case of critical situation and how you could avoid
Ans. 
I will ensure proper documentation, cross-training, and on-call rotation to support the team during critical situations when I am on vacation.
• Create detailed documentation for common issues and resolutions

• Implement cross-training sessions to ensure team members can cover for each other

• Establish an on-call rotation schedule with clear escalation paths

• Regularly review and update runbooks and procedures

• Utilize monitoring ...read more
Answered by AI
Add your answer

Q1. Can you provide an overview of your background, including your past experiences and daily activities, as well as the tools you use in your routine?
Ans. 
I have a background in data analysis with experience in using tools like Python, SQL, and Tableau.
• I have a degree in Statistics and have worked as a Data Analyst for 3 years.

• My daily activities include cleaning and analyzing data, creating visualizations, and presenting insights to stakeholders.

• I use Python for data manipulation and analysis, SQL for querying databases, and Tableau for creating interactive dashboards.

• I...read more
Answered by AI
Add your answer
Q2. What are the concepts of advanced Excel and Power BI projects, and how are they utilized within a company or for clients?
Ans. 
Advanced Excel and Power BI are tools used for data analysis and visualization in companies and for clients.
• Advanced Excel allows for complex data manipulation, analysis, and visualization using features like pivot tables, macros, and VBA programming.

• Power BI is a business analytics tool that provides interactive visualizations and business intelligence capabilities, connecting to various data sources.

• These tools are u...read more
Answered by AI
Add your answer

Q1. Can you explain your project experience related to Advanced Excel and Power BI?
Ans. 
I have extensive experience in using Advanced Excel and Power BI for data analysis projects.
• Created complex formulas and macros in Excel to automate data processing tasks

• Designed interactive dashboards in Power BI to visualize and analyze data trends

• Integrated data from multiple sources into Power BI for comprehensive analysis

• Used Power Query and Power Pivot in Excel to manipulate and analyze large datasets

• Provided dat...read more
Answered by AI
Add your answer
Q2. What are the concepts of credit and operations, particularly in relation to Know Your Customer (KYC) procedures and the privacy of client data?
Ans. 
Credit and operations concepts in relation to KYC procedures and client data privacy.
• Credit refers to the extension of money or resources to a client based on their financial history and ability to repay.

• Operations involve the day-to-day processes and procedures within a financial institution to ensure smooth functioning.

• KYC procedures are used to verify the identity of clients to prevent fraud and money laundering.

• Pri...read more
Answered by AI
Add your answer

Program for duplicate removal and sorting

Q1. Technical in detail
Add your answer

Q1. SQL Question on window functions to find the highest sale amount per day of the stores
Add your answer
Q2. Build an ETL Pipeline to read json files which are dropping at irregular times into storage. So how do you transform and match the schema etc.,
Add your answer
Q3. Write a pyspark code to join two tables and explain broadcastjoin() & what it does?
Add your answer

Q1. Java 8 features
Add your answer
Q2. Garbage collector changes in java 11
Ans. 
Java 11 introduced a new garbage collector called Epsilon.
• Java 11 introduced a new experimental garbage collector called Epsilon, which is a no-op garbage collector.

• Epsilon is designed for applications that do not require garbage collection, essentially turning off the garbage collector.

• This can be useful for performance testing or short-lived applications where the overhead of garbage collection is not needed.
Answered by AI
Add your answer
Q3. SOLID principles
Add your answer
Q4. Kafka basics like topic, partition, consumer group
Add your answer

Q1. Microservices 12 factor methodology
Add your answer
Q2. API gateway concepts, service discovery
Add your answer
Q3. Microservices side car pattern
Add your answer

Q1. Package expectation
Add your answer
Q2. Notice period negotiation
Add your answer

Q1. Introduction and about experiance
Add your answer
Q2. About work managment in organization
Add your answer

Q1. Introducing oneself, discussing experiences, and other
Add your answer
Q2. Regarding the workplace culture and organization
Add your answer