AmbitionBox
Interview Questions
- Reviews
- Salaries
- Interview Questions
- About Company
- Benefits
- Jobs
- Office Photos
- Community
Add office photos
Filter interviews by
Cameron Data Engineer Interview Questions and Answers
Cameron Data Engineer Interview Experiences
2 interviews found
kartikey mishra
Test duration was 1 hr they have sent me one hacker rank link
In 2nd round it's mostly about my project and spark questions and some part of python also
In final round there was mainly discussion with hiring manager and they were interested in the design of my project and my understanding about it
L Siva Subramaniam
I applied via Naukri.com and was interviewed in Apr 2022. There were 2 interview rounds.
(1 Question)
- Q1. Based on job profile
(1 Question)
- Q1. About salary and other stuff
Interview Preparation Tips
Top trending discussions
Interview questions from similar companies
Anonymous
Selected
I was interviewed in May 2024.
(6 Questions)
- Q1. SQL table distributions.
- Q2. ADF switching questions?
- Q3. How do you optimize the performance?
- Ans.
Performance optimization in data engineering involves tuning queries, indexing, partitioning, and utilizing appropriate hardware.
Tune queries by optimizing SQL code, using appropriate joins, and avoiding unnecessary operations.
Utilize indexing to speed up data retrieval by creating indexes on frequently queried columns.
Partition data to distribute it across multiple nodes or servers for parallel processing.
Utilize appr...
- Q4. What is stored procedure?
- Ans.
A stored procedure is a set of SQL statements that can be saved and reused in a database management system.
Stored procedures are used to perform a specific task or set of tasks in a database.
They can accept input parameters and return output parameters.
Stored procedures can improve performance by reducing the amount of data sent between the database and the application.
They can also enhance security by controlling acce...
- Q5. Ranking functions in SQL?
- Ans.
Ranking functions in SQL are used to assign a rank to each row based on a specific criteria.
Ranking functions include RANK(), DENSE_RANK(), and ROW_NUMBER()
RANK() assigns a unique rank to each distinct row
DENSE_RANK() assigns a unique rank to each distinct row without gaps
ROW_NUMBER() assigns a unique sequential integer to each row
- Q6. Modelling questions.
Skills evaluated in this interview
Selected
I applied via Naukri.com and was interviewed before Apr 2023. There were 5 interview rounds.
Reverse a binary tree and few other technical questions
(1 Question)
- Q1. Data structure and Oops concepts were asked
(1 Question)
- Q1. Technical round on projects that we have worked on and questions around that
(1 Question)
- Q1. General HR questions
(1 Question)
- Q1. More of like a general conversation with the center manager
Selected
I applied via Company Website and was interviewed before Oct 2022. There were 5 interview rounds.
(1 Question)
- Q1. Question as per my skill set from SQL, Unix, Power Center Mappings.
(1 Question)
- Q1. In detail questions on skill sets and writing logic and flow diagram for one of the problem statement
(1 Question)
- Q1. General discussion on expectations and the requirments
(1 Question)
- Q1. Don't remember the exact questions
I applied via Campus Placement and was interviewed in Dec 2016. There were 2 interview rounds.
Interview Preparation Tips
Experience: HR was really friendly and discussed resume in detail.
Round: Technical Interview
Experience: Had more discussion on technical terms on resume.
Round: Technical Interview
Experience: Asked questions on Programming and questions related to course work mentioned in the resume. The interview was completely candidate driven.
College Name: IIT Madras
I applied via Campus Placement and was interviewed in Dec 2016. There were 4 interview rounds.
Interview Preparation Tips
Experience: There were totally 8 sections to the test. But they could be broadly put under 4 categories. Firstly all questions were compulsory to attempt and there was no negative marking. Aptitude: Basic quantitative math questions were asked. There was one simple programming question where one could code in C/Java in your local IDE and upload the code file. It was a DO or DIE question, either you get the question and proceed to the next questions of the test or the test gets stopped if the code is not successfully compiled within 5 attempts. This programming question, as was told was an important criteria to filter out candidates for the next round. There was a descriptive question asking about a recent team project done.
Tips: Achievements in sports and other extra curricular activities are valued. Mention them in the resume, if applicable.
Duration: 1 hour 30 minutes
Round: Technical Interview
Experience: In this round, they look for the candidate's experience in coding in whatever language mentioned in the resume - I was asked to write some simple codes in c. I was also asked to explain some projects from the resume.
Tips: basic knowledge of data structures, resume preparation
Round: Technical + HR Interview
Experience: In this round, the questions were mostly based on the resume and the projects done. Also, HR questions like What do you know about Schlumberger, How do you perform in a team, What makes you unique from the other candidates etc. were asked. They also ask if you have any questions from your side - Better to ask questions if you have one or if you can't think upon any specific question, ask them a doubt from whatever they have said(usually they say a lot about their company and principles before they ask you for questions)
Tips: Prepare for a HR interview separately, resume preparation
College Name: IIT Madras
I applied via Campus Placement and was interviewed in Dec 2016. There were 2 interview rounds.
Interview Preparation Tips
Experience: HR was really friendly and asked about projects in the resume.
Round: Technical Interview
Experience: Interviewer asked questions related to programming and algorithms.
Round: Technical Interview
Experience: Interviewer asked all technical details inside the resume. This round was more technical. More emphasis was on problem solving skills.
College Name: IIT Madras
I applied via Naukri.com and was interviewed in Oct 2020. There were 3 interview rounds.
Interview Questionnaire
1 Question
- Q1. The HR round was very pathetic. Sreethala took my HR round.
Interview Preparation Tips
Mumbai location. They will take all the interview rounds. The HR will ask you to submit all documents and last moment they will cancel your candidature without giving you any specific reason.
I applied via Naukri.com and was interviewed before Nov 2019. There was 1 interview round.
Interview Questionnaire
4 Questions
- Q1. Basics related to piperack design
- Q2. Design parameters for steel structure
- Ans.
Design parameters for steel structure
Load capacity and distribution
Material strength and durability
Environmental factors such as wind and seismic activity
Connection details and joint design
Fire resistance and protection measures
- Q3. Number of years exposure to staad
- Ans.
I have 5 years of exposure to STAAD software.
I have used STAAD for various structural analysis and design projects.
I am proficient in using STAAD for modeling, analysis, and design of steel and concrete structures.
I have experience in using STAAD for seismic analysis and design of structures.
I have also used STAAD for foundation design and analysis.
I keep myself updated with the latest versions and features of STAAD so
- Q4. Grating design and deflection limits
Interview Preparation Tips
Cameron Interview FAQs
Tell us how to improve this page.
Cameron Interviews By Designations
Interview Questions for Popular Designations
- Senior Data Engineer Interview Questions
- Big Data Engineer Interview Questions
- Software Engineer Interview Questions
- Senior Software Engineer Interview Questions
- Database Admin Interview Questions
- Data Analyst Interview Questions
- System Engineer Interview Questions
- Associate Software Engineer Interview Questions
- Show more
Cameron Data Engineer Interview Process
based on 2 interviews
Interview experience
Interview Questions from Similar Companies
Cameron Data Engineer Reviews and Ratings
based on 2 reviews
Rating in categories
|
Quality Engineer
12
salaries
|  ₹0 L/yr - ₹0 L/yr |
|
Senior Designer
10
salaries
| ₹0 L/yr - ₹0 L/yr |
|
Mechanical Engineer
10
salaries
| ₹0 L/yr - ₹0 L/yr |
|
Customer Service Representative
9
salaries
| ₹0 L/yr - ₹0 L/yr |
|
Mechanical CAD Designer
7
salaries
| ₹0 L/yr - ₹0 L/yr |
Schlumberger
Halliburton
Baker Hughes
Weatherford
- Home >
- Interviews >
- Cameron Interview Questions >
- Cameron Data Engineer Interview Questions
