Spektra Systems Associate Consultant Interview Questions and Answers

Q1. Explain about your project and the stack
Add your answer
Q2. Explain about the oops concepts
Ans. 
Object-oriented programming concepts that focus on data encapsulation, inheritance, polymorphism, and abstraction.
• Encapsulation: Bundling data and methods that operate on the data into a single unit (class).

• Inheritance: Ability of a class to inherit properties and behavior from another class.

• Polymorphism: Ability to present the same interface for different data types.

• Abstraction: Hiding the complex implementation detai...read more
Answered by AI
Add your answer

Basics of maths,logical,technical

Q1. Write a code to find the prime number
Ans. 
Code to find prime numbers
• Iterate through numbers from 2 to n

• Check if number is divisible by any number from 2 to its square root

• If not divisible, it is a prime number
Answered by AI
Add your answer
Q2. SQL questions about select all employees in a dpt
Add your answer

Try on reasoning,basics of maths,oops,dsa etc...

Q1. What is firewall? Firewall types?VPN?
Add your answer

Q1. Mysql query for 3rd highest salary
Ans. 
Use a subquery to find the third highest salary from the employees table in MySQL.
• Use a subquery to select distinct salaries from the employees table.

• Order the salaries in descending order and use LIMIT to get the third highest salary.

• Example: SELECT DISTINCT salary FROM employees ORDER BY salary DESC LIMIT 2, 1;
Answered by AI
Add your answer
Q2. What are the steps to connect to a database?
Ans. 
Steps to connect to a database involve specifying the database type, providing credentials, and establishing a connection.
• Specify the type of database you want to connect to (e.g. MySQL, PostgreSQL, MongoDB).

• Provide the necessary credentials such as username and password.

• Establish a connection using a programming language or tool like JDBC, ODBC, or ORM frameworks.
Answered by AI
Add your answer

Q1. About different joins in SQL
Add your answer
Q2. 1)About previous projects done in detail 2) Regarding any certification like dp-203 or spark certification 3) spark architecture 4) about delta table
Add your answer
Q3. Some questions about adf pipelines scenario based
Add your answer
Q4. Spark actions and transformation
Add your answer

Genpact company established in year 1997 in the city of new york. 1250000 peoples across world wide service 30 countries..

Q1. What security policy benefits is in this company
Ans. 
Security job work at office work at home and travel for job .policy health insurance gud terms and conditions to the company For job guidelines for freshers
Answered by Sandra shirisha
Add your answer
Q2. What is hybrid adìvce in job or work
Ans. 
Hybrid advice in job or work refers to a combination of traditional and modern approaches to problem-solving or decision-making.
• Hybrid advice involves using both traditional methods and modern technologies to address challenges in the workplace.

• It combines the wisdom and experience of older employees with the innovative ideas and tools of younger generations.

• Examples include using a mix of in-person meetings and virtua...read more
Answered by AI
View 1 more answer
Q3. What help us working in company
Ans. 
Community opportunity learning skill development training skills teams work success...
Answered by Sandra shirisha
Add your answer
Q4. Company were at located some of them area names
Add your answer
Q5. Explain company benefits to work and culture in genpact
Ans. 
Genpact offers competitive benefits and a positive work culture for its employees.
• Genpact provides comprehensive health insurance coverage for employees and their families.

• Employees have access to professional development opportunities and training programs.

• The company promotes a diverse and inclusive work environment.

• Genpact offers flexible work arrangements, such as remote work options.

• Employees can participate in va
Answered by AI
Add your answer

Q1. Oops, java , collections basic questions asked
Add your answer

Q1. Can you please introduce yourself
Ans. 
I am a recent graduate with a degree in Business Administration and a passion for problem-solving and teamwork.
• Recent graduate with a degree in Business Administration

• Passionate about problem-solving and teamwork
Answered by AI
Add your answer
Q2. What do you mean by Subrogration
Ans. 
Subrogation is the process by which an insurance company seeks reimbursement from the party at fault for a claim it has already paid out.
• Subrogation allows insurance companies to recover costs from responsible parties.

• It is commonly used in cases where a third party is liable for damages or injuries covered by an insurance policy.

• For example, if your car is damaged in an accident caused by another driver, your insuranc...read more
Answered by AI
Add your answer

Q1. Why are you looking for change
Ans. 
Seeking new challenges and opportunities for growth in a dynamic environment.
• Looking to expand my skill set and knowledge in a different industry

• Seeking a more collaborative work culture

• Interested in taking on more responsibility and leadership roles

• Wanting to work on more innovative projects

• Desire for a better work-life balance
Answered by AI
Add your answer
Q2. How is your current CTC
Ans. 
My current CTC is competitive for my level of experience and qualifications.
• My current CTC is in line with industry standards for my role

• I have received regular salary increments based on my performance

• I am open to discussing compensation as part of the interview process
Answered by AI
Add your answer