Wipro Interview Questions, Process, and Tips

Q1. Architecture of spark
Ans. 
Spark is a distributed computing framework that provides an interface for programming entire clusters with implicit data parallelism and fault tolerance.
• Spark is built around the concept of Resilient Distributed Datasets (RDDs) which are immutable distributed collections of objects.

• It supports various programming languages like Java, Scala, Python, and R.

• Spark provides high-level APIs like Spark SQL for structured data...read more
Answered by AI
Add your answer
Q2. Methods to optimizing spark jobs
Ans. 
Optimizing Spark jobs involves tuning configurations, partitioning data, caching, and using efficient transformations.
• Tune Spark configurations for memory, cores, and parallelism

• Partition data to distribute workload evenly

• Cache intermediate results to avoid recomputation

• Use efficient transformations like map, filter, and reduce

• Avoid shuffling data unnecessarily
Answered by AI
Add your answer
Q3. Write SQL to find the second highest sal of emp in each dep
Ans. 
SQL query to find the second highest salary of employees in each department
• Use a subquery to rank the salaries within each department

• Filter the results to only include the second highest salary for each department

• Join the result with the employee table to get additional information if needed
Answered by AI
Add your answer
Q4. Write SQL to find the users who purchased 3 consecutive month in a year
Ans. 
SQL query to find users who purchased 3 consecutive months in a year
• Use a self join on the table to compare purchase months for each user

• Group by user and year, then filter for counts of 3 consecutive months

• Example: SELECT user_id FROM purchases p1 JOIN purchases p2 ON p1.user_id = p2.user_id WHERE p1.month = p2.month - 1 AND p2.month = p1.month + 1 GROUP BY p1.user_id, YEAR(p1.purchase_date) HAVING COUNT(DISTINCT MONT
Answered by AI
Add your answer
Q5. Working of kafka with spark streaming
Ans. 
Kafka is used as a message broker to ingest data into Spark Streaming for real-time processing.
• Kafka acts as a buffer between data producers and Spark Streaming to handle high throughput of data

• Spark Streaming can consume data from Kafka topics in micro-batches for real-time processing

• Kafka provides fault-tolerance and scalability for streaming data processing in Spark
Answered by AI
Add your answer
Q6. Fibonacci series
Add your answer

Q1. Spark Architecture
Add your answer
Q2. Scala Tail recursion
Add your answer

Mind reading. Knowledge about the job description. Knowledge on management, knowledge on compliance. People management

Q1. About EHS. Programs management,
Add your answer
Q2. Compliance details, applicable laws, applicable permits, water treatment
Add your answer

Q1. Tell me about your self?
Ans. 
I am a recent MBA graduate with a strong background in finance and marketing. I am a quick learner and a team player.
• Recent MBA graduate

• Specialization in finance and marketing

• Strong analytical and problem-solving skills

• Team player with excellent communication skills
Answered by AI
Add your answer
Q2. Tell me something about your college days
Ans. 
I had a memorable time in college, participating in various extracurricular activities and making lifelong friends.
• Participated in college fests and won prizes in dance competitions

• Was part of the college basketball team and played in inter-college tournaments

• Organized cultural events and fundraisers for social causes

• Made friends from diverse backgrounds and learned to work in teams effectively
Answered by AI
Add your answer
Q3. Tell me about daily routine?
Ans. 
My daily routine involves balancing work, personal activities, and self-care.
• I start my day with a morning workout or meditation to energize myself.

• I then have breakfast and plan out my tasks for the day.

• During work hours, I focus on completing assignments and attending meetings.

• In the evening, I unwind by spending time with family or pursuing hobbies.

• Before bed, I reflect on the day and plan for the next one.

• I make su...read more
Answered by AI
Add your answer
Q4. What is finance?
Ans. 
Finance is the management of money and investments.
• Finance involves managing money, investments, and other financial assets.

• It includes activities such as budgeting, investing, and analyzing financial data.

• Finance helps individuals and organizations make informed financial decisions.

• Examples of finance include banking, investing in stocks, and financial planning.
Answered by AI
Add your answer

Give me any Assignment I will submit it

Q1. What do you mean accounts payable process
Ans. 
The accounts payable process refers to the procedures and systems in place for managing and paying a company's outstanding invoices and bills.
• Accounts payable process involves receiving invoices from vendors or suppliers.

• It includes verifying the accuracy of the invoices and ensuring they match purchase orders or contracts.

• The process also involves obtaining approval for payment and processing the payment to the vendor...read more
Answered by AI
Add your answer
Q2. How many types of POs
Ans. 
There are two main types of POs: Standard Purchase Orders and Blanket Purchase Orders.
• Standard Purchase Orders are used for one-time purchases of goods or services.

• Blanket Purchase Orders are used for recurring purchases over a period of time or for a specific amount.

• POs can also be classified based on the nature of the purchase, such as capital POs for long-term investments or expense POs for day-to-day expenses.
Answered by AI
Add your answer
Q3. Accrual concept with example
Ans. 
Accrual concept recognizes revenues and expenses when they are incurred, regardless of when cash is exchanged.
• Accrual concept matches revenues with expenses in the period they occur

• It ensures financial statements reflect the true financial position of a company

• Example: A company records revenue when it earns it, even if the customer has not yet paid
Answered by AI
Add your answer
Q4. Entries when invoice created
Ans. 
Entries are typically made when an invoice is created to record the transaction.
• Entries include recording the sale, updating accounts receivable, and updating inventory levels.

• Accrual accounting principles dictate that revenue should be recognized when earned, not necessarily when cash is received.

• Examples of entries include debiting accounts receivable and crediting sales revenue when an invoice is created.

• Entries als...read more
Answered by AI
Add your answer
Q5. Credit memo meaning with example
Ans. 
A credit memo is a document issued by a seller to a buyer, reducing the amount owed by the buyer for goods or services.
• Credit memo is used to correct errors in invoicing or to provide a refund to the buyer

• It typically includes details such as the reason for issuing the credit, the amount being credited, and the original invoice number

• Example: A company issues a credit memo to a customer for overcharging them on a previ
Answered by AI
Add your answer

30 mins of online aptitude test. 30 Questions , no negative marking.

Q1. Question related to Domain
Add your answer
Q2. Quetion related to tools
Add your answer

Q1. Case study - presuure situation
Add your answer
Q2. Personlity Test
Add your answer

Q1. General discussion - Presonality and Expexlctation
Add your answer
Q2. Salary Discussion
Add your answer