Filter interviews by
SQL query order of execution determines the sequence in which different parts of a query are processed.
SQL query is parsed and checked for syntax errors
Query optimizer creates an execution plan
Data is retrieved from tables based on the execution plan
Filters and joins are applied to the retrieved data
Aggregations and calculations are performed on the filtered data
Null data values in joins can be handled using COALESCE function or LEFT JOIN with IS NULL condition.
Use COALESCE function to replace null values with a specified default value
Use LEFT JOIN with IS NULL condition to include rows with null values in the result set
Consider using CASE statements to handle null values based on specific conditions
Top trending discussions
posted on 27 Aug 2024
I applied via Referral and was interviewed before Aug 2023. There was 1 interview round.
Asked to write Selenium code to launch flipkart and handle the popup that shows up and asked to write code to reverse an entire string later asked reverse each word in that string without reversing the relative order of that string
I applied via Referral and was interviewed in Jan 2024. There were 3 interview rounds.
3 SQL questions of basic, intermediate and advance level respectively.
I applied via Naukri.com and was interviewed before Oct 2022. There were 4 interview rounds.
It was a 30 minutes round questions on Python, SQL, Pyspark - scenario based question to write the code.
Dynamic file ingestion in ADF involves using parameters to dynamically load files into Azure Data Factory.
Use parameters to specify the file path and name dynamically
Utilize expressions to dynamically generate file paths
Implement dynamic mapping data flows to handle different file structures
Aggregation in Databricks refers to the process of combining and summarizing data in a Spark environment.
Aggregation functions like sum, count, avg, min, max can be used in Databricks to summarize data.
Grouping data based on certain columns and then applying aggregation functions is a common practice.
Aggregation can be performed on large datasets efficiently using Databricks' distributed computing capabilities.
I applied via Referral and was interviewed before Dec 2023. There were 3 interview rounds.
Synthetic events in React are custom events created by developers to handle specific interactions.
Synthetic events are created using the SyntheticEvent object provided by React.
Developers can use synthetic events to handle user interactions like clicks, key presses, etc.
Synthetic events have the same interface as native browser events but are normalized across different browsers.
Forms in React can be created using controlled components, state management, and event handling.
Use controlled components to manage form data through state
Handle form submission using event handlers like onSubmit
Utilize form elements like input, textarea, and select to collect user input
Create a simple react web app using npm
I am drawn to your company's reputation for innovative solutions and collaborative work environment.
Impressed by company's track record of successful projects
Excited about the opportunity to work with a talented team
Interested in contributing to cutting-edge solutions
Appreciate the focus on collaboration and teamwork
In the next 5 years, I see myself advancing in my career as a consultant, taking on more challenging projects and expanding my expertise.
Continuing to build strong relationships with clients and colleagues
Seeking opportunities for professional development and training
Exploring new industries and sectors to broaden my experience
Working towards leadership roles within the consulting firm
I was interviewed before Feb 2024.
Normal coding test..not much dsa
I applied via LinkedIn and was interviewed before Mar 2023. There were 2 interview rounds.
Yes, I have experience using AWS Lambda for serverless computing.
I have developed serverless applications using AWS Lambda functions.
I have integrated AWS Lambda with other AWS services like API Gateway, S3, and DynamoDB.
I have experience writing Lambda functions in languages like Node.js, Python, and Java.
I have used AWS SAM (Serverless Application Model) to deploy and manage Lambda functions.
Write a program to check given no is prime number or not
posted on 31 Aug 2015
I am a software engineer with 5 years of experience in developing web applications using Java and JavaScript.
I have a Bachelor's degree in Computer Science.
I am proficient in Spring Framework and AngularJS.
I have worked on projects involving RESTful APIs and microservices architecture.
I am a quick learner and enjoy working in a team environment.
I am impressed with the company's innovative approach and commitment to excellence.
I have researched the company and its products extensively and am excited about the potential for growth and development.
I am impressed with the company's reputation for innovation and cutting-edge technology.
I believe that the company's commitment to excellence aligns with my own values and goals.
I am excited about the opportunity to wo...
My future plans include continuous learning, honing my skills, and contributing to the growth of the company.
I plan to attend relevant conferences and workshops to stay updated with the latest technologies.
I want to work on challenging projects that will help me improve my skills.
I aim to become a valuable asset to the company by contributing to its growth and success.
I plan to mentor and guide junior developers to hel
posted on 10 Mar 2015
based on 1 interview
Interview experience
Software Engineer
99
salaries
| ₹0 L/yr - ₹0 L/yr |
Senior Product Specialist
73
salaries
| ₹0 L/yr - ₹0 L/yr |
Senior Software Engineer
71
salaries
| ₹0 L/yr - ₹0 L/yr |
Product Support Consultant
38
salaries
| ₹0 L/yr - ₹0 L/yr |
Senior Implementation Consultant
36
salaries
| ₹0 L/yr - ₹0 L/yr |
Tekwissen
Damco Solutions
In Time Tec Visionsoft
smartData Enterprises