Add office photos
Filter interviews by
Sigma Esolution Senior Developer Interview Questions and Answers for Experienced
Sigma Esolution Senior Developer Interview Experiences for Experienced
1 interview found
I applied via Referral and was interviewed before Jun 2020. There were 3 interview rounds.
Interview Questionnaire
1 Question
- Q1. Questions from PHP, its frameworks & subsidiary technologies like jquery, ajax etc.
Interview Preparation Tips
Don't hassle at all. With a very peaceful mind, attend your interview. Although you are fluent in your language, but answering hassle free, gives us time also to choose correct words.
If HR offers you to ask questions , do ask HR about:-
1. Salary Revisions/ Promotions
2. Single Project Operations/ Multi project operations
3. How frequent need to go Over Time/ or on to work on weekends
4. Casual Leaves
5. A Technical Supervisor who knows your field.
6. Encouragement to learn new Technologies.
Top trending discussions
Interview questions from similar companies
(1 Question)
- Q1. Techical interview on itsm process
Selected
I applied via LinkedIn and was interviewed in Jul 2023. There were 2 interview rounds.
(2 Questions)
- Q1. Core Java concepts, Collections framework
- Q2. Concurrency, threads, stream and coding questions on streams
Senior Developer Interview Questions & Answers
Hexaware Technologies
Anonymous
posted on 27 Apr 2024
Selected
I applied via Company Website and was interviewed in Oct 2023. There was 1 interview round.
Write code on bot scenarios
Senior Developer Interview Questions & Answers
Virtusa Consulting Services
Anonymous
posted on 7 May 2022
I applied via Referral and was interviewed in Apr 2022. There were 3 interview rounds.
(2 Questions)
- Q1. Questions on Salesforce admin and development
- Q2. Lwc and aura questions
(1 Question)
- Q1. Describe your projects
Interview Preparation Tips
- Salesforce
- Salesforce CRM
I applied via Naukri.com and was interviewed before Dec 2019. There were 3 interview rounds.
Interview Questionnaire
8 Questions
- Q1. 1. What is ETL and DWH?
- Ans.
ETL stands for Extract, Transform, Load and DWH stands for Data Warehouse.
ETL is a process of extracting data from various sources, transforming it into a format suitable for analysis, and loading it into a target system.
DWH is a system used for storing and managing data from various sources for business intelligence purposes.
ETL is a crucial step in populating a DWH with data.
ETL involves data extraction, data transfo...
- Q2. 2.How to differentiate outer and inner joins with sample data?
- Ans.
Outer join returns all records from one table and matching records from another, while inner join returns only matching records.
Outer join uses the (+) symbol in Oracle and LEFT/RIGHT OUTER JOIN in SQL Server
Inner join uses INNER JOIN keyword in SQL
Sample data: Table A has 5 records, Table B has 3 records, Outer join returns 8 records while Inner join returns 3 records
- Q3. 3.How to implement SCDs and different between them?
- Ans.
SCDs are used to track changes in data over time. There are three types: Type 1, Type 2, and Type 3.
Type 1 SCDs overwrite old data with new data.
Type 2 SCDs add a new row for each change, with a start and end date.
Type 3 SCDs add columns to the existing row to track changes.
SCDs are commonly used in data warehousing and business intelligence.
The choice of SCD type depends on the specific use case and data requirements.
- Q4. 4. How to delete duplicate rows based on key in a table?
- Ans.
To delete duplicate rows based on key in a table, use the DELETE statement with a subquery.
Identify the key column(s) that define the uniqueness of a row
Use the GROUP BY clause to group the rows by the key column(s)
Use the HAVING clause to filter out the groups that have more than one row
Use the subquery to select the duplicate rows to be deleted
Use the DELETE statement with the subquery to delete the duplicate rows
- Q5. 5. What are the differences between fact and dimension?
- Ans.
Fact and dimension are two types of data in a data warehouse.
Fact is a measurable event that can be analyzed, while dimension provides context to the fact.
Fact is quantitative, while dimension is qualitative.
Fact is stored in a fact table, while dimension is stored in a dimension table.
Examples of fact include sales, revenue, and profit, while examples of dimension include time, location, and product.
Fact and dimension...
- Q6. 6.Can you join different fact tables ?
- Ans.
Yes, fact tables can be joined together in a data warehouse to combine related information.
Fact tables contain quantitative data and are typically joined using common dimensions.
Joining fact tables allows for more comprehensive analysis and reporting.
For example, joining a sales fact table with a customer fact table can provide insights on customer behavior and purchasing patterns.
- Q7. 7.What do you understand by degenerate dimension?
- Ans.
Degenerate dimension refers to a dimension with only one value.
A degenerate dimension is a dimension table with only one column and one row.
It is used to join fact tables with different granularity levels.
For example, a time dimension with only one value can be used to join a sales fact table with daily granularity and a returns fact table with hourly granularity.
- Q8. 8.Difference between OLTP and OLAP systems.
- Ans.
OLTP is a transactional system for day-to-day operations, while OLAP is analytical system for decision-making.
OLTP deals with real-time data processing, while OLAP deals with historical data analysis.
OLTP is optimized for write operations, while OLAP is optimized for read operations.
OLTP is used for operational tasks like order processing, while OLAP is used for strategic tasks like sales forecasting.
OLTP databases are...
Interview Preparation Tips
Skills evaluated in this interview
I applied via Naukri.com
(4 Questions)
- Q1. Javascipt question
- Q2. Promises, filter, map, What is single page , mulitple page application, opened google page by search for one product in that using console filter it only for sony products only
- Q3. What is DOM, what is the use of that
- Ans.
DOM stands for Document Object Model, it is a programming interface for web documents. It represents the structure of a document as a tree of objects.
DOM is used to interact with HTML and XML documents in a structured way
It allows developers to manipulate the content, structure, and style of a website dynamically
DOM provides methods and properties to access and modify elements on a web page
Example: document.getElementB...
- Q4. What is the output if u type document in console
- Ans.
The output will display the document object in the console.
Typing 'document' in the console will return the document object, which represents the current HTML document.
The document object provides access to the content and structure of the webpage, allowing manipulation of elements and properties.
Interview Preparation Tips
Skills evaluated in this interview
I applied via Approached by Company and was interviewed in May 2024. There was 1 interview round.
(2 Questions)
- Q1. How is GIL and how python handle multi threading
- Ans.
GIL stands for Global Interpreter Lock in Python, which limits execution of multiple threads at once.
GIL is a mutex that protects access to Python objects, preventing multiple threads from executing Python bytecodes at once.
Due to GIL, Python threads are not suitable for CPU-bound tasks but are still useful for I/O-bound tasks.
To handle multi-threading in Python, one can use multiprocessing module or asynchronous progr...
- Q2. Explain How React works under the hood.
- Ans.
React uses a virtual DOM to efficiently update the actual DOM based on changes in state or props.
React creates a virtual DOM representation of the actual DOM.
When state or props change, React compares the virtual DOM with the actual DOM to determine the minimal set of changes needed.
React then updates the actual DOM efficiently to reflect the changes.
Interview Preparation Tips
Skills evaluated in this interview
Selected
I applied via Company Website and was interviewed in Apr 2024. There were 3 interview rounds.
(4 Questions)
- Q1. Programmer database
- Q2. I want to join for the purpose of web developer (python developer)
- Q3. Yes I am a programmer, in python base programming.
- Q4. I have good skilling for one HTML,CSS,JAVASCRIPT,JQUERY,MYSQL,DJANGO,PYTHON THANK YOU 🙏🏼
I have created my some project
(2 Questions)
- Q1. I have some web design
- Q2. I am showing my project
Interview Preparation Tips
- Programming
- Development
- Python developer
- Web Designing
In person , asked two questions, 1 about linked list and other about array
(2 Questions)
- Q1. System design problem related to Uber
- Q2. Asked about micro services and design patterns
Interview Preparation Tips
Tell us how to improve this page.
Interview Questions for Popular Designations
- Front end Developer Interview Questions
- Web Developer Interview Questions
- Backend Developer Interview Questions
- Software Developer Intern Interview Questions
- Junior Software Developer Interview Questions
- PHP Developer Interview Questions
- Full Stack Software Developer Interview Questions
- Software Developer Interview Questions
- Show more
Senior Developer Interview Questions from Similar Companies
|
Software Developer
4
salaries
|  ₹2.2 L/yr - ₹4.1 L/yr |
|
Network Engineer
4
salaries
| ₹1.2 L/yr - ₹3.6 L/yr |
|
Business Development Manager
3
salaries
| ₹4.5 L/yr - ₹7 L/yr |
|
Project Coordinator
3
salaries
| ₹4.3 L/yr - ₹4.7 L/yr |
|
Assistant Manager- HR
3
salaries
| ₹2.2 L/yr - ₹2.9 L/yr |
TCS
Infosys
Wipro
HCLTech
- Home >
- Interviews >
- Sigma Esolution Interview Questions >
- Sigma Esolution Senior Developer Interview Questions for Experienced
