Upload Button Icon Add office photos

Filter interviews by

CAMSDATA Technologies India Software Engineer Interview Questions, Process, and Tips

Updated 14 Jul 2021

CAMSDATA Technologies India Software Engineer Interview Experiences

1 interview found

I applied via Naukri.com and was interviewed in Jun 2021. There was 1 interview round.

Interview Questionnaire 

7 Questions

  • Q1. How to get a file name which has one string called "Virus" as complete word in one directory by UNIX ?
  • Ans. 

    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'.

  • Answered by AI
  • Q2. How to achieve SCD Type 2 in informatica, mention all the transformations used ?
  • Ans. 

    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...

  • Answered by AI
  • Q3. How to improve performance of aggregator ? and what is Incremental aggregation ?
  • Ans. 

    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

  • Answered by AI
  • Q4. What is Hash join and pragma exception in PL SQL
  • Ans. 

    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...

  • Answered by AI
  • Q5. What is the difference in Procedure and Function ?
  • Ans. 

    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.

  • Answered by AI
  • Q6. Suppose lookup is getting 10k records normally in all days suddenly records count will be updated to 100 million then how lookup works ? Does lookup fail session , running session or succeed session.
  • Ans. 

    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

  • Answered by AI
  • Q7. We have 1 source qualifier and 3 targets and we want to load 2nd target first then 3rd secondly then 1st target thirdly, how to achieve it in Informatica ?

Interview Preparation Tips

Interview preparation tips for other job seekers - CamsData is a consultancy firm and provides staff to its clients like Amdocs, IMImobie.

Skills evaluated in this interview

Interview questions from similar companies

I applied via Naukri.com and was interviewed in Oct 2018. There were 3 interview rounds.

Interview Questionnaire 

3 Questions

  • Q1. Asked me to draw spring mvc architecture and about collection framework.
  • Q2. Asked me to write the logic for pattern.
  • Q3. Asked me on core java.

Interview Preparation Tips

General Tips: be thorough with the core java and good to have knowledge on spring mvc
Skills: Communication
Duration: <1 week

I applied via Company Website and was interviewed before Dec 2019. There were 3 interview rounds.

Interview Questionnaire 

1 Question

  • Q1. Regarding OOPS, wordpress and laravel.

Interview Preparation Tips

Interview preparation tips for other job seekers - It was good and I am still working here.

I applied via Campus Placement and was interviewed in Mar 2021. There were 4 interview rounds.

Interview Questionnaire 

3 Questions

  • Q1. What are Joins in SQL? Briefly explain difference between all types of joins
  • Ans. 

    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

  • Answered by AI
  • Q2. Find a sub array with a given sum
  • Ans. 

    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

  • Answered by AI
  • Q3. Questions related to Projects mentioned in CV

Interview Preparation Tips

Interview preparation tips for other job seekers - My interview advice would be to remain honest throughout the interview. The interviewer checks the problem solving abilities by your approach of solving it. Ask if there are any doubts.

Skills evaluated in this interview

I appeared for an interview before Apr 2021.

Round 1 - Video Call 

(3 Questions)

Round duration - 60 minutes
Round difficulty - Easy

Technical interview round with questions on DSA and DBMS mainly.

  • Q1. 

    Maximum Sum Subarray Problem Statement

    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...

  • Ans. 

    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.

  • Answered by AI
  • Q2. 

    Prime Numbers Identification

    Given a positive integer N, your task is to identify all prime numbers less than or equal to N.

    Explanation:

    A prime number is a natural number greater than 1 that has no po...

  • Ans. 

    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

  • Answered by AI
  • Q3. What are Joins in the context of databases?
  • Ans. 

    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...

  • Answered by AI
Round 2 - HR 

Round duration - 30 minutes
Round difficulty - Easy

Typical HR round with behavioral problems.

Interview Preparation Tips

Eligibility criteriaAbove 7 CGPABigStep Technologies interview preparation:Topics to prepare for the interview - Data Structures, Algorithms, DBMS, SQL, Aptitude, OOPSTime required to prepare for the interview - 4 monthsInterview preparation tips for other job seekers

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.

Application resume tips for other job seekers

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.

Final outcome of the interviewSelected

Skills evaluated in this interview

I applied via Recruitment Consulltant and was interviewed before May 2021. There were 5 interview rounds.

Round 1 - Coding Test 

Hackerrank Test

Round 2 - Technical 

(1 Question)

  • Q1. Questions related to NodeJS and Javascript Basics
Round 3 - Technical 

(1 Question)

  • Q1. Technical questions based on past experience
Round 4 - HR 

(1 Question)

  • Q1. Company Culture related
Round 5 - Behavioral 

(1 Question)

  • Q1. Expectations and Processes

Interview Preparation Tips

Interview preparation tips for other job seekers - Read the basics. Medium level interview questions. All the best.
Interview experience
5
Excellent
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Aptitude Test 

The aptitude test was of moderate level.

Round 2 - Coding Test 

It checked on the concepts of oops

Round 3 - HR 

(1 Question)

  • Q1. How will you deal with tight delivery time.
  • Ans. 

    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...

  • Answered by AI

I applied via Referral and was interviewed before Jan 2020. There was 1 interview round.

Interview Questionnaire 

2 Questions

  • Q1. Which technology are you using, is this latest?
  • Ans. 

    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.

  • Answered by AI
  • Q2. If not then which technology can we use instead of this?
  • Ans. 

    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

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - Hi,
Listen carefully and speak fluently.

I applied via Referral and was interviewed before Feb 2021. There were 3 interview rounds.

Round 1 - HR 

(1 Question)

  • Q1. Tell me about yourself
Round 2 - Technical 

(1 Question)

  • Q1. 1 Project Explanation 2 SDLC & STLC. 3 Differentiate Smoke vs Sanity 4 What is Regression testing? 5 Bug life cycle. 6 Scenarios on real time example. 7 Questions on agile
  • Ans. 

    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...

  • Answered by AI
Round 3 - One-on-one 

(1 Question)

  • Q1. All basic HR questions and salary discussion.

I applied via Recruitment Consulltant and was interviewed in Oct 2021. There were 3 interview rounds.

Round 1 - Resume Shortlist 
Pro Tip by AmbitionBox:
Keep your resume crisp and to the point. A recruiter looks at your resume for an average of 6 seconds, make sure to leave the best impression.
View all tips
Round 2 - Technical 

(1 Question)

  • Q1. Completely on java
Round 3 - Technical 

(1 Question)

  • Q1. Asked java questiona

CAMSDATA Technologies India Interview FAQs

What are the top questions asked in CAMSDATA Technologies India Software Engineer interview?

Some of the top questions asked at the CAMSDATA Technologies India Software Engineer interview -

  1. Suppose lookup is getting 10k records normally in all days suddenly records cou...read more
  2. How to get a file name which has one string called "Virus" as complete word in ...read more
  3. How to achieve SCD Type 2 in informatica, mention all the transformations use...read more

Tell us how to improve this page.

CAMSDATA Technologies India Software Engineer Salary
based on 23 salaries
₹2.4 L/yr - ₹12 L/yr
17% less than the average Software Engineer Salary in India
View more details

CAMSDATA Technologies India Software Engineer Reviews and Ratings

based on 3 reviews

3.1/5

Rating in categories

1.8

Skill development

3.1

Work-life balance

3.1

Salary

1.8

Job security

2.7

Company culture

2.1

Promotions

2.3

Work satisfaction

Explore 3 Reviews and Ratings
Software Engineer
23 salaries
unlock blur

₹2.4 L/yr - ₹12 L/yr

Information Technology Recruiter
14 salaries
unlock blur

₹1.1 L/yr - ₹5 L/yr

Softwaretest Engineer
12 salaries
unlock blur

₹4.5 L/yr - ₹12 L/yr

Senior IT Recruiter
10 salaries
unlock blur

₹3.3 L/yr - ₹6.6 L/yr

Senior Software Engineer
8 salaries
unlock blur

₹11 L/yr - ₹27 L/yr

Explore more salaries
Compare CAMSDATA Technologies India with

Accel Frontline

4.0
Compare

Northcorp Software

4.3
Compare

Elentec Power India (EPI) Pvt. Ltd.

3.7
Compare

HyScaler

4.5
Compare
Did you find this page helpful?
Yes No
write
Share an Interview