Filter interviews by
I applied via Naukri.com and was interviewed in Jun 2021. There was 1 interview round.
Finding a file name with the word 'Virus' in UNIX directory.
Use the 'grep' command to search for the word 'Virus' in the directory.
Use the '-w' option to match the complete word 'Virus'.
Use the '-l' option to print only the file names that contain the word 'Virus'.
SCD Type 2 in Informatica can be achieved using multiple transformations.
Use a Source Qualifier transformation to read data from the source.
Use an Expression transformation to derive new columns or modify existing ones.
Use a Lookup transformation to look up data in a reference table.
Use a Router transformation to route data to different targets based on conditions.
Use a Filter transformation to filter out unwanted data...
Improving aggregator performance and understanding incremental aggregation.
Optimize database queries and indexing
Reduce data processing time by parallelizing tasks
Use caching to reduce redundant data retrieval
Incremental aggregation involves updating only new or changed data instead of processing all data again
Example: Updating a daily sales report with only new sales data instead of recalculating the entire report
Hash join is a type of join used in database management systems. Pragma exception is used to handle exceptions in PL/SQL.
Hash join is used to join large tables efficiently by creating a hash table of one table and scanning the other table.
Pragma exception is used to handle exceptions in PL/SQL by specifying the action to be taken when an exception occurs.
Examples of actions that can be specified include raising an erro...
Procedures do not return values while functions return values.
Procedures are used to perform an action while functions are used to calculate and return a value.
Functions have a return type while procedures do not.
Functions can be used in expressions while procedures cannot.
Functions can have input parameters while procedures can have both input and output parameters.
Lookup will fail if the memory is not sufficient to handle the increased record count.
Lookup transformation caches the lookup table in memory
If the memory is not sufficient, the lookup will fail
Increasing the cache size or using persistent cache can help avoid failure
Top trending discussions
posted on 4 May 2019
I applied via Naukri.com and was interviewed in Oct 2018. There were 3 interview rounds.
I applied via Company Website and was interviewed before Dec 2019. There were 3 interview rounds.
posted on 14 Sep 2021
I applied via Campus Placement and was interviewed in Mar 2021. There were 4 interview rounds.
Joins in SQL are used to combine data from two or more tables based on a related column.
Inner join returns only the matching rows from both tables
Left join returns all rows from the left table and matching rows from the right table
Right join returns all rows from the right table and matching rows from the left table
Full outer join returns all rows from both tables, with NULL values for non-matching rows
Cross join retur
Given an array of integers, find a contiguous subarray with a given sum.
Use a sliding window approach to iterate through the array and keep track of the current sum.
If the current sum exceeds the given sum, move the window's left endpoint forward.
If the current sum is less than the given sum, move the window's right endpoint forward.
If the current sum equals the given sum, return the subarray.
Time complexity: O(n), Spa
I appeared for an interview before Apr 2021.
Round duration - 60 minutes
Round difficulty - Easy
Technical interview round with questions on DSA and DBMS mainly.
Given an array ARR
consisting of N
integers, determine the sum of the subarray with the maximum sum, including the possibility of an empty subarray.
A subarray is a...
Find the sum of the subarray with the maximum sum in a given array.
Iterate through the array and keep track of the current sum and maximum sum.
Update the maximum sum if the current sum becomes greater.
Handle cases where the array has all negative numbers or empty subarray.
Example: For input [-2, 1, -3, 4, -1], the maximum sum subarray is [4] with sum 4.
Given a positive integer N
, your task is to identify all prime numbers less than or equal to N
.
A prime number is a natural number greater than 1 that has no po...
Identify all prime numbers less than or equal to a given positive integer N.
Iterate from 2 to N and check if each number is prime
Use the Sieve of Eratosthenes algorithm for efficient prime number identification
Optimize by only checking numbers up to square root of N for divisibility
Joins in databases are used to combine rows from two or more tables based on a related column between them.
Joins are used to retrieve data from multiple tables based on a related column.
Common types of joins include INNER JOIN, LEFT JOIN, RIGHT JOIN, and FULL JOIN.
INNER JOIN returns rows when there is at least one match in both tables.
LEFT JOIN returns all rows from the left table and the matched rows from the right ta...
Round duration - 30 minutes
Round difficulty - Easy
Typical HR round with behavioral problems.
Tip 1 : Must do Previously asked Interview as well as Online Test Questions.
Tip 2 : Go through all the previous interview experiences from Codestudio and Leetcode.
Tip 3 : Do at-least 2 good projects and you must know every bit of them.
Tip 1 : Have at-least 2 good projects explained in short with all important points covered.
Tip 2 : Every skill must be mentioned.
Tip 3 : Focus on skills, projects and experiences more.
posted on 30 May 2022
I applied via Recruitment Consulltant and was interviewed before May 2021. There were 5 interview rounds.
Hackerrank Test
The aptitude test was of moderate level.
It checked on the concepts of oops
I will prioritize tasks, communicate effectively with team members, and utilize time management techniques to meet deadlines.
Prioritize tasks based on importance and urgency
Break down tasks into smaller manageable chunks
Communicate effectively with team members to coordinate efforts
Utilize time management techniques such as Pomodoro technique or Agile methodologies
Identify and eliminate any potential roadblocks or bott...
posted on 13 Jan 2021
I applied via Referral and was interviewed before Jan 2020. There was 1 interview round.
We are using a variety of technologies, including some of the latest ones.
We are using React for our front-end development.
We are also using Node.js for our back-end development.
We are using Docker for containerization.
We are using Kubernetes for orchestration.
We are using AWS for cloud hosting.
We are constantly evaluating new technologies to see if they can improve our development process.
It depends on the specific requirements and constraints of the project.
Consider the project's goals and objectives
Evaluate the available technologies and their capabilities
Assess the project's budget and timeline
Consult with stakeholders and experts in the field
Examples: React vs Angular, MySQL vs MongoDB, Java vs Python
posted on 15 Feb 2022
I applied via Referral and was interviewed before Feb 2021. There were 3 interview rounds.
Interview questions for Software Engineer position
Project explanation should include details on the project's purpose, scope, and technologies used
SDLC (Software Development Life Cycle) and STLC (Software Testing Life Cycle) are methodologies used in software development and testing respectively
Smoke testing is a type of testing that checks if the basic functionalities of the software are working fine, while Sanity tes...
posted on 28 May 2022
I applied via Recruitment Consulltant and was interviewed in Oct 2021. There were 3 interview rounds.
Some of the top questions asked at the CAMSDATA Technologies India Software Engineer interview -
based on 3 reviews
Rating in categories
Software Engineer
23
salaries
| ₹2.4 L/yr - ₹12 L/yr |
Information Technology Recruiter
14
salaries
| ₹1.1 L/yr - ₹5 L/yr |
Softwaretest Engineer
12
salaries
| ₹4.5 L/yr - ₹12 L/yr |
Senior IT Recruiter
10
salaries
| ₹3.3 L/yr - ₹6.6 L/yr |
Senior Software Engineer
8
salaries
| ₹11 L/yr - ₹27 L/yr |
Accel Frontline
Northcorp Software
Elentec Power India (EPI) Pvt. Ltd.
HyScaler