SIPCHEM Interview Questions and Answers

English, Quant & Reasoning- 3 section, each section 15 que, Total 45 minutes & 45 questions, cut off for each section

Q1. Java What is JVM,JRE,JDK? what is the difference between class and instance variable in java? what is string Pool? write a code in java(prefer a good standard question) Web development if you have inter...read more
Ans. 
To build a web application, I would use a combination of front-end technologies like HTML, CSS, and JavaScript, along with back-end technologies like Node.js and MongoDB.
• Use HTML for structuring the content of the web pages

• Use CSS for styling the web pages and making them visually appealing

• Use JavaScript for adding interactivity to the web pages and handling user input

• Use Node.js for server-side scripting and handling ...read more
Answered by AI
Add your answer
Q2. If you have azure certification what is azure, what is Azure Blob Storage, What is ARM, what is horizontal Scaling?
Ans. 
Azure is a cloud computing platform by Microsoft. Azure Blob Storage is a service for storing large amounts of unstructured data. ARM stands for Azure Resource Manager, used for managing resources in Azure. Horizontal scaling is increasing the number of instances of a service to distribute load.
• Azure is a cloud computing platform by Microsoft

• Azure Blob Storage is a service for storing large amounts of unstructured data

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

Q1. Why cse? explain a project (they might ask about a project in your resume)
Add your answer
Q2. How you solved the problems that you have faced while working on projects?
Ans. 
I approach problems by breaking them down into smaller parts, analyzing root causes, seeking input from team members, and implementing solutions systematically.
• Identify the root cause of the problem

• Break down the problem into smaller parts

• Seek input from team members for different perspectives

• Implement solutions systematically

• Learn from the experience to prevent similar issues in the future
Answered by AI
Add your answer

Q1. Introduction Family Background Do you have any placement/internship offers in your hand? if so, why Ericsson At last, they will tell you about stipend, role
Ans. 
Yes, I have internship offers from Ericsson due to their reputation for innovation and cutting-edge technology.
• I have received internship offers from Ericsson because of their reputation for innovation and cutting-edge technology.

• I am excited about the opportunity to work with a global leader in telecommunications.

• I believe that interning at Ericsson will provide me with valuable experience and skills that will benefit
Answered by AI
Add your answer

Data Analysis and Automation Testing.

Team work and communication

Q1. Work culture and promotion!!?
Add your answer
Q2. Better Income and study!?
Add your answer
Q3. Work freedom!??
Add your answer

Q1. Face to face communication?
Add your answer
Q2. Discussion?
Add your answer

Q1. What is the Singleton pattern ? in how many ways can this pattern be broken ?
Ans. 
Singleton pattern ensures a class has only one instance and provides a global point of access to it.
• Singleton pattern can be implemented by making the constructor private and providing a static method to access the instance.

• The pattern can be broken by using reflection to access the private constructor and create multiple instances.

• Another way to break the Singleton pattern is by using multiple class loaders in Java.

• Th...read more
Answered by AI
Add your answer
Q2. What is the internal implementation of hashmap? Let's assume that you want to store duplicate keys in the hashmap, how can we achieve the same in hashmap ?
Ans. 
HashMap internally uses an array of linked lists to store key-value pairs. To store duplicate keys, we can use a custom implementation of HashMap.
• HashMap internally uses an array of linked lists to handle collisions.

• To store duplicate keys, we can create a custom HashMap implementation that allows multiple values for the same key.

• One approach is to use a HashMap with values as lists, where each key can have multiple va
Answered by AI
Add your answer

Q1. What microservices patterns are you aware ? let's assume that there is a microservice based architecture and service A is calling service B which in turn service C. If service b fails, how will you manage ...read more
Ans. 
Use compensating transactions and distributed tracing for managing transaction and logging in case of service B failure.
• Implement compensating transactions to rollback changes made by service B in case of failure.

• Use distributed tracing to track the flow of requests and identify where the failure occurred.

• Implement retry mechanisms to handle transient failures in service B.

• Use circuit breakers to prevent cascading fail...read more
Answered by AI
Add your answer
Q2. System Design question : Design a booking wesite for.eg: bookin.com ?
Add your answer

The aptitude test lasts 30 minutes and focuses on topics relevant to data engineering, including Spark, SQL, Azure, and PySpark.

The coding test is a one-hour examination on PySpark.

Q1. What is the difference between Cache() and Persist()?
Add your answer
Q2. What does the purpose of the Spark Submit command in Apache Spark?
Add your answer
Q3. What are window functions in SQL?
Add your answer

Q1. Could you provide more details about the daily responsibilities associated with this role?
Add your answer
Q2. How would you describe your work culture?
Add your answer

Q1. How important an honest person for the organisation's real growth?
Add your answer
Q2. Should there be retirement if the person is fit?
Add your answer
Q3. Should not there be the pension for an honest employee after atleast 5years of one's job with the organisation?
Add your answer

3 coding que easy,med and hard

Q1. Os related que What is kernel , OS types ,what happens after booting computr ,etc
Add your answer
Q2. Creat a array and print all elements , which database used for pdf storing sql or nosql
Add your answer

Q1. OOps related que abstraction , inheritance , code it
Add your answer
Q2. Middel element of linked list
Add your answer

Q1. What challenges u faced in engineering?
Add your answer
Q2. Situational based questions
Add your answer

Q1. Why u choose to work deustch bank ?
Add your answer
Q2. Project related quw
Add your answer

Q1. What are the aml and kyc requirements?
Ans. 
AML and KYC requirements are regulations that financial institutions must follow to prevent money laundering and verify the identity of their customers.
• AML (Anti-Money Laundering) requirements involve monitoring transactions, reporting suspicious activities, and conducting customer due diligence.

• KYC (Know Your Customer) requirements involve verifying the identity of customers, assessing their risk level, and maintainin...read more
Answered by AI
View 1 more answer
Q2. Why should we hire you, briefly describe a scenario where you would showcase a different skill or talent compared with your fellow employees?
Ans. 
I have a strong attention to detail and analytical skills that set me apart from my colleagues.
• I have a proven track record of accurately identifying and resolving discrepancies in KYC documentation.

• I excel at conducting thorough research and analysis to ensure compliance with regulations.

• My ability to effectively communicate complex information to stakeholders sets me apart in team collaborations.
Answered by AI
Add your answer
Q3. Strength and weakness?
Ans. 
Strength: attention to detail, Weakness: perfectionism
• Strength: Ability to meticulously review documents and identify discrepancies

• Strength: Strong analytical skills to detect potential risks or fraudulent activities

• Weakness: Striving for perfection may lead to spending too much time on a task

• Weakness: Difficulty in delegating tasks due to desire for everything to be done perfectly
Answered by AI
Add your answer
Q4. Project and achievements?
Ans. 
Implemented a new KYC process resulting in 30% reduction in onboarding time and 20% decrease in errors.
• Led a team to revamp KYC procedures and systems

• Introduced automation tools to streamline verification process

• Trained staff on updated KYC regulations and best practices
Answered by AI
Add your answer
Q5. Are you a team player? What do you do when you don’t get along with certain colleagues? How do you manage conflict resolution?
Ans. 
Yes, I am a team player. I believe in open communication and collaboration. When conflicts arise, I address them directly and seek resolution.
• I believe in open communication and collaboration within the team.

• I address conflicts directly and seek resolution through constructive conversations.

• I focus on finding common ground and working towards a solution that benefits the team as a whole.
Answered by AI
Add your answer
Q6. Provide a situation where you might have failed previously? What has that experience taught you?
Ans. 
I failed to meet a deadline due to poor time management.
• Underestimated the time needed for a project

• Did not prioritize tasks effectively

• Learned to create a detailed schedule and set realistic deadlines
Answered by AI
Add your answer

General English grammar knowledge and some calculations

Q1. CTC and expected salary details?
Add your answer
Q2. No you cannot negotiate and end up taking what they give you!
Add your answer
Q3. No relocation time, do it during weekends
Add your answer
Q4. No target compensation or other benefits
Add your answer
Q5. If ur employed through agency or consultancy you will be always a contingent and treated less than permanent employees
Add your answer
Q6. 12 hours a day, 6 days a week, no social or life balance
Add your answer

Q1. What are SAP tools to migrate SAP systems from on-premise to cloud?
Ans. 
SAP tools for migrating SAP systems from on-premise to cloud include SAP Advanced Data Migration, SAP Cloud Platform Migration Service, and SAP Transformation Navigator.
• SAP Advanced Data Migration: tool for migrating data from on-premise systems to cloud

• SAP Cloud Platform Migration Service: helps in migrating applications and workloads to the cloud

• SAP Transformation Navigator: tool for planning and executing system mig
Answered by AI
Add your answer
Q2. When you use export/import method form migration, what files will be created during export?
Ans. 
During export using export/import method for migration, files like data files, control files, and log files will be created.
• Data files containing the actual data being exported

• Control files containing information about the export process

• Log files recording the activities and errors during the export

• Examples: .dmp, .ctl, .log files
Answered by AI
Add your answer
Q3. How does parallel export/import work ?
Ans. 
Parallel export/import allows multiple processes to export/import data simultaneously for faster migration/conversion.
• Parallel export/import splits the data into multiple parts and processes them concurrently.

• It helps in reducing the overall time taken for data migration/conversion.

• Parallel export/import requires careful planning to avoid conflicts and ensure data consistency.

• Examples include using SAP tools like R3loa...read more
Answered by AI
Add your answer
Q4. If you are using DMO to migrate a SAP system with sql DB on windows to HANA DB on linux, how the SUM will run? As there is a different SUM for windows and linux, will it use 2 different SUM in this case?
Ans. 
SUM will use a single SUM tool for the migration from SQL DB on Windows to HANA DB on Linux.
• SUM tool is platform-independent and can be used for migrations between different operating systems.

• The SUM tool will handle the conversion process seamlessly without the need for separate tools for Windows and Linux.

• The migration process will involve steps to convert the database from SQL to HANA while also transitioning the op
Answered by AI
Add your answer
Q5. Can EHP 5 run on oracle 19C ?
Ans. 
No, EHP 5 cannot run on Oracle 19C.
• EHP 5 is not certified to run on Oracle 19C.

• Compatibility issues may arise if trying to run EHP 5 on Oracle 19C.

• It is recommended to check SAP's official compatibility matrix for supported configurations.
Answered by AI
Add your answer
Q6. What are technical differences in SPDD and SPAU?
Ans. 
SPDD is for modifying dictionary objects, SPAU is for modifying repository objects.
• SPDD is used for modifying dictionary objects like tables, views, and data elements.

• SPAU is used for modifying repository objects like programs, function modules, and screens.

• SPDD changes are transportable across systems, SPAU changes are not transportable.

• SPDD changes are typically related to data dictionary objects, SPAU changes are re...read more
Answered by AI
Add your answer
Q7. Can we skip SPDD in preprocessing? If yes, what will happen? If no, what stops us from skipping it?
Ans. 
Skipping SPDD in preprocessing is not recommended as it can lead to inconsistencies in the system.
• No, SPDD should not be skipped in preprocessing as it is a crucial step in handling modifications to the ABAP Dictionary objects during an upgrade or migration.

• Skipping SPDD can result in inconsistencies between the data dictionary and the ABAP programs, leading to runtime errors and system issues.

• SPDD is responsible for a...read more
Answered by AI
Add your answer
Q8. Why is SPDD need to be performed before execution phase and SPAU after execution?
Ans. 
SPDD is performed before execution phase to adjust dictionary objects, while SPAU is performed after execution to adjust repository objects.
• SPDD is performed before execution phase to adjust dictionary objects to the new release of SAP system.

• SPAU is performed after execution to adjust repository objects like programs, function modules, screens, etc.

• SPDD helps in adjusting the data dictionary objects to the new release...read more
Answered by AI
Add your answer
Q9. Can we perform SPAU before execution?
Ans. 
Yes, SPAU can be performed before execution.
• SPAU can be performed to adjust modifications before executing a system upgrade or migration.

• It allows for resolving any inconsistencies in custom objects before the actual upgrade.

• Performing SPAU beforehand can help streamline the upgrade process and reduce downtime.

• It is recommended to review and adjust modifications using SPAU prior to the upgrade to ensure a smooth transi
Answered by AI
Add your answer
Q10. Which process of SWPM will be used for export/import?
Ans. 
The export/import process in SWPM is performed using the R3load tool.
• R3load tool is used for exporting and importing data during system migrations/conversions.

• Export/import process involves extracting data from source system and loading it into target system.

• R3load tool is part of Software Provisioning Manager (SWPM) toolset.

• Export/import process is crucial for transferring SAP system data between systems.
Answered by AI
Add your answer
Q11. What processes will be used for shipping the files in case of parallel export/import?
Ans. 
Files can be shipped in parallel export/import using tools like Rsync, SCP, FTP, or cloud storage services.
• Use tools like Rsync for efficient file transfer

• SCP (Secure Copy Protocol) can be used for secure file transfer

• FTP (File Transfer Protocol) is another option for transferring files

• Utilize cloud storage services like AWS S3 or Google Cloud Storage for large file transfers
Answered by AI
Add your answer
Q12. Can we restore backup of HANA 1.0 on HANA 2.0 ?
Ans. 
No, backup of HANA 1.0 cannot be restored on HANA 2.0 due to compatibility issues.
• Backup of HANA 1.0 is not compatible with HANA 2.0 due to differences in architecture and features.

• Data structures and formats may have changed between the two versions, leading to potential data corruption if restored.

• It is recommended to perform a system copy or migration instead of trying to restore a backup from HANA 1.0 to HANA 2.0.
Answered by AI
Add your answer
Q13. Why do we need shadow instance?
Ans. 
Shadow instances are used for testing and validation purposes before making changes to the production system.
• Shadow instances allow for testing system changes without impacting the production environment.

• They are used to validate migration or conversion processes before applying them to the live system.

• Helps in identifying any potential issues or errors that may arise during the actual migration/conversion.

• Provides a s...read more
Answered by AI
Add your answer
Q14. How is shadow instance created and where is it created? How much extra space it will require and what tables will it be stored in?
Ans. 
Shadow instance is created for system copy or migration, requires extra space, stored in database tables.
• Shadow instance is created using software tools like SAP SWPM (Software Provisioning Manager) during system copy or migration.

• It is created on the same server as the original instance, but with a different SID (System ID).

• Extra space required for shadow instance depends on the size of the original instance and the d...read more
Answered by AI
Add your answer
Q15. In case of oracle, it creates an additional tablespace during upgrade. How does it work in SAP HANA and Sybase?
Ans. 
SAP HANA and Sybase do not create additional tablespaces during upgrade like Oracle.
• SAP HANA and Sybase do not follow the same approach as Oracle in creating additional tablespaces during upgrade.

• In SAP HANA, data is stored in memory and does not require separate tablespaces like Oracle.

• Sybase also does not create additional tablespaces during upgrade, as it follows a different database structure.

• Both SAP HANA and Syba...read more
Answered by AI
Add your answer
Q16. Is it possible to upgrade without creating Shadow instance?
Ans. 
Yes, it is possible to upgrade without creating a Shadow instance.
• Upgrade can be performed directly on the existing instance without the need for a Shadow instance.

• This approach may save time and resources by avoiding the creation of a separate instance for the upgrade process.

• However, it is important to carefully plan and execute the upgrade to minimize risks and ensure a successful outcome.
Answered by AI
Add your answer
Q17. What is HANA Topology?
Ans. 
HANA Topology refers to the layout and configuration of SAP HANA systems and components.
• HANA Topology includes the distribution of HANA instances across multiple hosts.

• It also involves the configuration of high availability and disaster recovery setups.

• Different HANA Topologies include single host, multi-host, scale-out, and distributed systems.

• Topology decisions impact performance, scalability, and availability of the
Answered by AI
Add your answer
Q18. How to setup SSO for SAP and HANA ?
Ans. 
Setting up SSO for SAP and HANA involves configuring trust between systems and enabling authentication mechanisms.
• Configure trust between SAP and HANA systems

• Enable SAML (Security Assertion Markup Language) for authentication

• Implement Single Sign-On (SSO) using SAML tokens

• Use SAP Cloud Identity or other identity providers for SSO setup
Answered by AI
Add your answer
Q19. As I do not have experience in OS/DB migration, any conceptual knowledge of heterogeneous migration ?
Add your answer
Q20. Conceptual knowledge of SAP S/4HANA conversion?
Ans. 
SAP S/4HANA conversion involves migrating from SAP ERP to the next-generation S/4HANA platform.
• Understanding the differences between SAP ERP and S/4HANA

• Assessing system landscape and data readiness for conversion

• Executing the migration process with minimal downtime

• Validating and testing the converted system for functionality and performance

• Training end-users on the new S/4HANA system
Answered by AI
Add your answer
Q21. Basics of SAP BTP.
Add your answer

Q1. Behavioral assessment
Add your answer

Logical, react, SQL related questions

Q1. Interviewed by Business Head. Mostly behavioral questions and some past experience related
Add your answer

Q1. Interview by VP. Frontend general technical questions
Add your answer

Q1. Interviewed by Director. Competency based Leadership interview
Add your answer

Q1. Yet to recieve the final status whether selected or rejected. HR asked payslip and other docs and shared the same.
Add your answer
Q2. HRs are very friendly and quickly respond to your queries.
Add your answer