Epsilon Technical Support Engineer Interview Questions and Answers

Q1. Python, sql, etl, cloud, web tool
Add your answer

Q1. Functional question and write some sql basic query
Add your answer

Q1. Basic question on project
Add your answer

Q1. Salary negotiation and check behaviour qiestion
Add your answer

Q1. Pivot columns in sql
Ans. 
Pivoting columns in SQL involves transforming rows into columns to display data in a different format.
• Use the PIVOT keyword in SQL to pivot columns

• Specify the columns to pivot on and the values to display in the new columns

• Aggregate functions like SUM, AVG, COUNT can be used with PIVOT

• Example: SELECT * FROM table_name PIVOT (SUM(value_column) FOR pivot_column IN ('value1', 'value2', 'value3'))
Answered by AI
Add your answer
Q2. Slow changing dimensions
Add your answer
Q3. Dynamic rankx top 3
Add your answer
Q4. Field parameters
Add your answer
Q5. Stored procedures
Add your answer

Q1. Explain oops concepts, difference b/w abstraction and interface,MVC architecture,stored procedure,joins
Ans. 
OOPs concepts, abstraction vs interface, MVC architecture, stored procedures, joins
• OOPs concepts include inheritance, polymorphism, encapsulation, and abstraction

• Abstraction is hiding the implementation details while interface is a contract that defines the methods that a class must implement

• MVC architecture separates the application into Model, View, and Controller components for better organization and maintenance

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

SQL queries, ddl,dml TCL commands, primary key and foreign key differences,what is composite key,hash table in c#,generics in c#.

Q1. Salary discussion,
Add your answer

It consited of apti as well as coding questions

Q1. Basic questions of coding were asked like arrays,strings
Add your answer

Q1. Introduce yourself
Add your answer
Q2. DS/Ago problem - dynamic programming
Add your answer

Q1. Check string is pallindrome or not
Ans. 
A palindrome is a string that reads the same forwards and backwards, like 'racecar' or 'level'.
• Definition: A palindrome is a word, phrase, or sequence that reads the same backward as forward. Examples include 'madam' and '12321'.

• Ignoring Spaces and Punctuation: When checking for palindromes, spaces and punctuation are often ignored. For instance, 'A man, a plan, a canal, Panama!' is a palindrome.

• Case Sensitivity: Palin...read more
Answered by AI
Add your answer
Q2. Bubble sort explanation
Add your answer

Q1. Basic about Javascript,HTML,CSS
Add your answer

Q1. Design a weather app
Ans. 
A weather app that provides accurate and up-to-date weather information.
• Include real-time weather updates

• Provide hourly and daily forecasts

• Include radar and satellite maps

• Allow users to set location and receive alerts for severe weather

• Include a widget for quick access to weather information
Answered by AI
Add your answer