AmbitionBox
Interview Questions
- Reviews
- Salaries
- Interview Questions
- About Company
- Benefits
- Jobs
- Office Photos
- Community
Add office photos
Filter interviews by
Infocus Technologies Interview Questions and Answers
14 Interview questions
Basic SQL concepts include data types, queries, joins, and normalization essential for database management.
Data Types: SQL supports various data types like INT, VARCHAR, DATE. Example: CREATE TABLE users (id INT, name VARCHAR(100));
Queries: SQL uses SELECT statements to retrieve data. Example: SELECT * FROM users WHERE id = 1;
Joins: Combining rows from two or more tables based on related columns. Example: SELECT u...
Indexing in SQL improves query performance by allowing faster data retrieval from tables.
Indexes are special data structures that store a small portion of the table's data for quick access.
They can be created on one or more columns of a table, e.g., CREATE INDEX idx_name ON table_name(column_name);
Indexes can significantly speed up SELECT queries but may slow down INSERT, UPDATE, and DELETE operations.
There are di...
Data warehousing is the process of collecting, storing, and managing large volumes of data for analysis and reporting.
Centralized repository for data from multiple sources.
Supports business intelligence activities like reporting and analysis.
Uses ETL (Extract, Transform, Load) processes to prepare data.
Examples include Amazon Redshift and Google BigQuery.
Data is structured for efficient querying and analysis.
Asset depreciation is the reduction in value of an asset over time, while retirement refers to the disposal of an asset.
Depreciation accounts for wear and tear on assets, e.g., machinery losing value over years.
Common methods of depreciation include straight-line and declining balance.
Retirement of assets occurs when they are sold, scrapped, or no longer in use.
Example of retirement: A company sells an old vehicle...
The P2P process in SAP refers to the Procure-to-Pay cycle, encompassing procurement and payment activities.
Initiation of Purchase Requisition: A department identifies a need and creates a purchase requisition.
Purchase Order Creation: The purchase requisition is converted into a purchase order (PO) for the vendor.
Goods Receipt: Upon delivery, the goods are received and recorded in the system.
Invoice Verification: T...
Experienced SAP MM consultant with expertise in procurement, inventory management, and vendor evaluation processes.
Implemented SAP MM module in a manufacturing company, streamlining procurement processes.
Conducted training sessions for end-users on inventory management best practices.
Configured material master data to improve accuracy in stock levels and reporting.
Collaborated with cross-functional teams to enhanc...
Indexing is a database optimization technique that improves data retrieval speed and efficiency.
1. Types of Indexes: B-Tree Index, Hash Index, Bitmap Index, and Full-Text Index.
2. B-Tree Index: Most common type, suitable for range queries. Example: Index on a 'date' column for quick retrieval of records within a date range.
3. Hash Index: Used for equality comparisons. Example: Index on a 'user_id' column for fast ...
Use SQL to delete older records, retaining only the most recent entry based on a timestamp or ID.
Identify the table and the column that determines the latest record, e.g., 'created_at' or 'id'.
Use a subquery to find the latest record, e.g., SELECT MAX(created_at) FROM records.
Delete records that do not match the latest record, e.g., DELETE FROM records WHERE created_at < (SELECT MAX(created_at) FROM records).
En...
Field selection in material master can be maintained in multiple ways.
Field selection can be maintained using transaction code OMS9.
Field selection can be maintained using material type configuration.
Field selection can be maintained using screen layout configuration.
Field selection can be maintained using user exit or BADI implementations.
LSMW is a tool used to migrate data from legacy systems to SAP systems.
LSMW stands for Legacy System Migration Workbench
It is used to migrate data from non-SAP systems to SAP systems
LSMW uses batch input, direct input, BAPI, and IDoc methods for data migration
Steps to set up LSMW include creating a project, defining object attributes, mapping fields, converting data, and executing the migration
Infocus Technologies Interview Experiences
17 interviews found
Anonymous
Selected
I appeared for an interview in May 2025, where I was asked the following questions.
- Q1. SQL questions on different modules
- Q2. What are some of the basic concepts of SQL that were covered in the interview?
- Ans.
Basic SQL concepts include data types, queries, joins, and normalization essential for database management.
Data Types: SQL supports various data types like INT, VARCHAR, DATE. Example: CREATE TABLE users (id INT, name VARCHAR(100));
Queries: SQL uses SELECT statements to retrieve data. Example: SELECT * FROM users WHERE id = 1;
Joins: Combining rows from two or more tables based on related columns. Example: SELECT users....
Omkar Kasar
I appeared for an interview in May 2025, where I was asked the following questions.
- Q1. Gradient discent algo.
- Q2. Clusturing algorithms
Selected
I appeared for an interview in Feb 2025.
(1 Question)
- Q1. What is p2p process in sap.
- Ans.
The P2P process in SAP refers to the Procure-to-Pay cycle, encompassing procurement and payment activities.
Initiation of Purchase Requisition: A department identifies a need and creates a purchase requisition.
Purchase Order Creation: The purchase requisition is converted into a purchase order (PO) for the vendor.
Goods Receipt: Upon delivery, the goods are received and recorded in the system.
Invoice Verification: The ve...
(1 Question)
- Q1. What is asset depreciation and retirement of assets.
- Ans.
Asset depreciation is the reduction in value of an asset over time, while retirement refers to the disposal of an asset.
Depreciation accounts for wear and tear on assets, e.g., machinery losing value over years.
Common methods of depreciation include straight-line and declining balance.
Retirement of assets occurs when they are sold, scrapped, or no longer in use.
Example of retirement: A company sells an old vehicle afte...
Interview Preparation Tips
Selected
I applied via Naukri.com and was interviewed in Feb 2024. There were 2 interview rounds.
(2 Questions)
- Q1. Find unique records & Difference between union & union all & joins
- Q2. What is Indexing & it's types.
- Ans.
Indexing is a database optimization technique that improves data retrieval speed and efficiency.
1. Types of Indexes: B-Tree Index, Hash Index, Bitmap Index, and Full-Text Index.
2. B-Tree Index: Most common type, suitable for range queries. Example: Index on a 'date' column for quick retrieval of records within a date range.
3. Hash Index: Used for equality comparisons. Example: Index on a 'user_id' column for fast looku...
(2 Questions)
- Q1. Delete all the previous records and keep only latest one
- Ans.
Use SQL to delete older records, retaining only the most recent entry based on a timestamp or ID.
Identify the table and the column that determines the latest record, e.g., 'created_at' or 'id'.
Use a subquery to find the latest record, e.g., SELECT MAX(created_at) FROM records.
Delete records that do not match the latest record, e.g., DELETE FROM records WHERE created_at < (SELECT MAX(created_at) FROM records).
Ensure ...
- Q2. Window function.
Interview Preparation Tips
Chandrakant Kandoi
(5 Questions)
- Q1. Experience related to SAP
- Ans.
Experienced SAP MM consultant with expertise in procurement, inventory management, and vendor evaluation processes.
Implemented SAP MM module in a manufacturing company, streamlining procurement processes.
Conducted training sessions for end-users on inventory management best practices.
Configured material master data to improve accuracy in stock levels and reporting.
Collaborated with cross-functional teams to enhance ven...
- Q2. Tell me something about yourself
- Ans.
I am a dedicated SAP MM Functional Consultant with 5 years of experience in implementing and optimizing supply chain processes.
5 years of experience in SAP MM implementation and optimization
Strong knowledge of supply chain processes
Skilled in analyzing business requirements and translating them into SAP solutions
Experience in conducting training sessions for end users
Certified in SAP MM module
- Q3. Qualification highest extra courses
- Q4. Expectations of salary negotiable
- Ans.
Yes, salary expectations are negotiable based on experience, skills, and market rates.
Salary negotiation is common in job offers, especially for specialized roles like SAP MM Functional Consultant.
Factors influencing negotiation include years of experience, certifications, industry demand, and company budget.
Research market rates and compare with your skills and experience to determine a reasonable salary range for neg...
- Q5. Technical questions related to sap
(2 Questions)
- Q1. How to set up LSMW
- Ans.
LSMW is a tool used to migrate data from legacy systems to SAP systems.
LSMW stands for Legacy System Migration Workbench
It is used to migrate data from non-SAP systems to SAP systems
LSMW uses batch input, direct input, BAPI, and IDoc methods for data migration
Steps to set up LSMW include creating a project, defining object attributes, mapping fields, converting data, and executing the migration
- Q2. How many ways we can maintain field selection in material master?
- Ans.
Field selection in material master can be maintained in multiple ways.
Field selection can be maintained using transaction code OMS9.
Field selection can be maintained using material type configuration.
Field selection can be maintained using screen layout configuration.
Field selection can be maintained using user exit or BADI implementations.
Skills evaluated in this interview
(1 Question)
- Q1. As per resume interviewer asking technical questions
Interview Preparation Tips
Shubham Shinde
Selected
I appeared for an interview before Apr 2024, where I was asked the following questions.
- Q1. What's Data warehousing?
- Ans.
Data warehousing is the process of collecting, storing, and managing large volumes of data for analysis and reporting.
Centralized repository for data from multiple sources.
Supports business intelligence activities like reporting and analysis.
Uses ETL (Extract, Transform, Load) processes to prepare data.
Examples include Amazon Redshift and Google BigQuery.
Data is structured for efficient querying and analysis.
- Q2. Explain indexing in sql.
- Ans.
Indexing in SQL improves query performance by allowing faster data retrieval from tables.
Indexes are special data structures that store a small portion of the table's data for quick access.
They can be created on one or more columns of a table, e.g., CREATE INDEX idx_name ON table_name(column_name);
Indexes can significantly speed up SELECT queries but may slow down INSERT, UPDATE, and DELETE operations.
There are differe...
Vishal Dedavat
Selected
I appeared for an interview before Mar 2024.
(2 Questions)
- Q1. Sql basic question s
- Q2. Window function questions.
(2 Questions)
- Q1. Window function questions
- Q2. Having groupby questions
Selected
I appeared for an interview before Jun 2024, where I was asked the following questions.
- Q1. Tell me about yourself
- Q2. Year of experience
- Ans.
I have over 5 years of experience in Java development, focusing on building scalable applications and optimizing performance.
Developed multiple web applications using Spring Boot and Hibernate.
Implemented RESTful APIs for seamless integration with front-end applications.
Worked on performance tuning and optimization of existing Java applications.
Collaborated with cross-functional teams to deliver projects on time.
Top trending discussions
Infocus Technologies Interview FAQs
The duration of Infocus Technologies interview process can vary, but typically it takes about less than 2 weeks to complete.
Tell us how to improve this page.
Infocus Technologies Interviews By Designations
- Infocus Technologies Java Developer Interview Questions
- Infocus Technologies SAP Basis Consultant Interview Questions
- Infocus Technologies SAP MM Consultant Interview Questions
- Infocus Technologies SQL Developer Trainee Interview Questions
- Infocus Technologies SAP MM Functional Consultant Interview Questions
- Infocus Technologies Male Staff Nurse Interview Questions
- Infocus Technologies ETL Developer Interview Questions
- Infocus Technologies SAP Fico Consultant Interview Questions
- Show more
Interview Questions for Popular Designations
Overall Interview Experience Rating
based on 19 interview experiences
Difficulty level
Duration
Interview Questions from Similar Companies
Infocus Technologies Reviews and Ratings
based on 220 reviews
Rating in categories
6-8 Yrs
Not Disclosed
5-7 Yrs
₹ 3.8-4.1 LPA
7-9 Yrs
Not Disclosed
|
SAP Abap Consultant
24
salaries
|  ₹3.3 L/yr - ₹7.8 L/yr |
|
SAP Fico Consultant
22
salaries
| ₹4.8 L/yr - ₹8.9 L/yr |
|
Java Developer
22
salaries
| ₹2.8 L/yr - ₹4 L/yr |
|
SAP SD Consultant
20
salaries
| ₹4 L/yr - ₹10 L/yr |
|
SQL Developer
19
salaries
| ₹2.2 L/yr - ₹7.6 L/yr |
Primus Global Technologies
TriGeo Technologies
Plada Infotech Services
Anlage Infotech
- Home >
- Interviews >
- Infocus Technologies Interview Questions
