AmbitionBox
Search
Interview Questions
- Reviews
- Salaries
- Interview Questions
- About Company
- Benefits
- Jobs
- Office Photos
- Community
Add office photos
Filter interviews by
Artefact Interview Questions and Answers
Updated
24 Aug 2024
Artefact Interview Experiences
1 interview found
Interview experience
Good
Difficulty level
Moderate
Process Duration
2-4 weeks
Result
-
I applied via Approached by Company
Round 1 - Technical
(2 Questions)
- Q1. In depth about current project design
- Q2. Setting up data engineering solution using GCP
- Ans.
Setting up data engineering solution using GCP involves utilizing various GCP services for data processing and storage.
Utilize Google Cloud Storage for storing raw data
Use Google BigQuery for data processing and analysis
Implement data pipelines using Google Cloud Dataflow or Apache Beam
Leverage Google Cloud Pub/Sub for real-time data streaming
Utilize Google Cloud Composer for orchestrating data workflows
Add your answer
Answered by
AI
Add your answer
Round 2 - Technical
(2 Questions)
- Q1. BigQuery features
- Q2. GCP Dataflow, dataproc
Add your answer
Add your answer
Skills evaluated in this interview
Senior Data Engineer Interview Questions asked at other Companies
Q1. Write a query to get the customer with the highest total order value for each year, month. [Note: Order table is different and Customer table is different. Order_ID and Customer_ID are the PK of the table with Oid from Customer table being ...
read more
View answer
(2)
Jobs at Artefact
Top trending discussions
View All
Interview Tips & Stories
2w
heartwarmingracoon
·
works at
Esways Conglomerate
Post interview process
I am working as a front-end developer for 4.5years in a same company. So I think this is the right time to switch my job.
I attended F2F interview yesterday(21-01-25) at TCD, I completed two rounds of interview and wait for a while, they say you may leave now you got a call from us soon.
Is they call me either I cleared the interview or not cleared it, or they call only I cleared the interview?
Can I wait for the call or focus on other interview?
Got a question about Artefact?
Ask anonymously on communities.
Interview questions from similar companies
Functional Testing Senior Consultant Interview Questions & Answers
Deloitte
Anonymous
posted on 4 Feb 2025
Interview experience
Bad
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
No response
I was interviewed in Jan 2025.
Round 1 - HR
(2 Questions)
- Q1. Current CTC, Expected CTC, Notice Period, Skill set
- Q2. Open for Fixed term hire? Open for working from client location at Gurgaon? (3 days from office)
Add your answer
Add your answer
Round 2 - Technical
(10 Questions)
- Q1. Introduction, Current role and responsibilities
- Q2. List out the achievements in current project, Tools used
- Q3. Pilot vs Beta testing. How can newly developed functionality be tested via automation rather doing it manually?
- Q4. Primary key vs Unique key in SQL, Query to find row having last id in sql
- Q5. Explain Software Testing Life Cycle, Defect Life Cycle
- Q6. What's the meaning of 303 status code in API? Put vs Delete method in API What is 3 point estimation technique in Agile?
- Q7. What kind of links and labels can be tagged to a bug in jira?
- Q8. Have you done shell scripting? What does grep, href commands do in unix?
- Q9. As a lead, how would you resolve conflict with a team member? As a lead, if you are given plenty of tasks to be completed with in a limited time frame. What would be your approach in doing them?
- Q10. Open for relocating to Bangalore and working from client's office? (with no relocation bonus) Open for working in night / rotational shift? (with no additional compensation) Open for working in long exten...
Add your answer
Add your answer
Add your answer
Add your answer
Add your answer
Add your answer
Add your answer
Add your answer
Add your answer
Add your answer
Interview Preparation Tips
Interview preparation tips for other job seekers - Not a good experience. Some recruiters are very arrogant and have no respect for the people interviewing with them. They consider as themselves dummy kings, because they are working in Deloitte USI. I interacted with 4-5 recruiters for one opening (from Gurgaon / Hyderabad). One HR even said to me that I was not the only person interviewing with them, they have bunch of people to chose, also various other things were said in a very unprofessional and rude manner. She had no ethics of talking to an experienced resource, when I escalated this to the seniors, they immediately apologized for her behavior and I was then handled by another Senior HR
I applied via referral in Deloitte USI but to save their referral bonus (I guess), they rejected my profile on the portal and called me through Naukri.com. When I asked them the reason, they said its for a different profile them. however it was for the same one.
Also on their career site, it was not mentioned that role is of fixed term hire (for 2 years), but HR disclosed it later, during the conversation. (another discrepancy)
During my initial conversation, HR clearly said there won't be any night shifts and I would have to work from client's location in Gurgaon office. Although it is 2 year contractual role.
But during my technical interview, the person clearly said to me that I would have to relocate to Bangalore for working from client's secured ODC in office. Also there would be rotational/ night shifts (without any extra pay). Basically they were looking for someone who would devote his 24X7 time to the company for a minimal salary and does not demand for work life balance or weekends off
Neither the HR nor the interviewer opened their web camera during the video call. But HR kept asking me to keep my camera open, even during the waiting time
I applied via referral in Deloitte USI but to save their referral bonus (I guess), they rejected my profile on the portal and called me through Naukri.com. When I asked them the reason, they said its for a different profile them. however it was for the same one.
Also on their career site, it was not mentioned that role is of fixed term hire (for 2 years), but HR disclosed it later, during the conversation. (another discrepancy)
During my initial conversation, HR clearly said there won't be any night shifts and I would have to work from client's location in Gurgaon office. Although it is 2 year contractual role.
But during my technical interview, the person clearly said to me that I would have to relocate to Bangalore for working from client's secured ODC in office. Also there would be rotational/ night shifts (without any extra pay). Basically they were looking for someone who would devote his 24X7 time to the company for a minimal salary and does not demand for work life balance or weekends off
Neither the HR nor the interviewer opened their web camera during the video call. But HR kept asking me to keep my camera open, even during the waiting time
Interview experience
Bad
Difficulty level
Moderate
Process Duration
4-6 weeks
Result
No response
I was interviewed in Jan 2025.
Round 1 - Group Discussion
Programming questions related to Python and React.
Round 2 - Group Discussion
Programmatical problem related to Python and React
Round 3 - HR
(1 Question)
- Q1. Salary Discussion
Add your answer
Round 4 - Aptitude Test
Programming Problems related to react and python.
Round 5 - Technical
(1 Question)
- Q1. Object Oriented Programming, Memory Management, Multiprocessing, multithreading, GIL, React Components
Add your answer
Round 6 - Technical
(1 Question)
- Q1. Object Oriented Programming, GIL, Multi threading, multiprocessing, React Component, Shallow Copy, Deep Copy
Add your answer
Round 7 - Technical
(1 Question)
- Q1. Object Oriented Programming, GIL, Multi threading, multiprocessing, React Component, Shallow Copy, Deep Copy
Add your answer
Round 8 - Technical
(1 Question)
- Q1. Object Oriented Programming, GIL, Multi threading, multiprocessing, React Component, Shallow Copy, Deep Copy
Add your answer
Round 9 - One-on-one
(1 Question)
- Q1. Object Oriented Programming, GIL, Multi threading, multiprocessing, React Component, Shallow Copy, Deep Copy, Django ORM, Class Inheritance
Add your answer
Interview Preparation Tips
Interview preparation tips for other job seekers - In the name of the client Round, the internal team will contact you to conduct interview calls known as Preparation Call Round before the Client Round, aimed at creating a positive impression for the client. Typically, no additional rounds follow the HR round, but they conducted five more rounds while merely reiterating the aforementioned details, which led me to cancel my own job application.
Interview experience
Average
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
No response
I was interviewed in Jan 2025.
Round 1 - One-on-one
(5 Questions)
- Q1. Basics of Python, Flask, ReactJs, RestApi Development
- Q2. Python - Difference between is and ==
- Q3. React - useEffect vs useState
- Q4. Authentication in RestApi
- Q5. React - Pure Component and Higher order components
Add your answer
Add your answer
Add your answer
Add your answer
Add your answer
Interview experience
Excellent
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Selected
I was interviewed before Feb 2024.
Round 1 - Technical
(5 Questions)
- Q1. What is the SQL query using PIVOT to transform the given input table into the expected output?
- Q2. What is the process flow for implementing an incremental load?
- Q3. What are the steps involved in query optimization?
- Q4. What is the process flow of Slowly Changing Dimension Type 2 (SCD 2), and what are the associated post commands?
- Q5. Difference Between dimension tables and fact tables.Which one loaded firs?
Add your answer
Add your answer
Add your answer
Add your answer
Add your answer
Interview experience
Bad
Difficulty level
Hard
Process Duration
6-8 weeks
Result
Not Selected
I applied via LinkedIn and was interviewed in Nov 2024. There were 3 interview rounds.
Round 1 - One-on-one
(1 Question)
- Q1. Time you worked under pressure, with a team
Add your answer
Round 2 - Assignment
Writing Sample based on HBR
Round 3 - Case Study
Case study on 4 day work week using RCA
Interview Preparation Tips
Interview preparation tips for other job seekers - There were four rounds of interviews, starting with one hour behavioural around, writing sample, case study and final interview for cultural fit. The overall recruitment process is very disorganised as I applied for this role in October before Diwali and the HR got back to me in November end. It's almost as of September 2024 they have this position open and cannot fill it up I had qualified until the case study round which was a very negative experience overall the interviewer was from a senior position. This round requires you to have business acumen and use the RCA technique to perform well enough. It seems to me that the expectations are unreasonably high for a fresher level role and they want someone who is a jack of all trades and they don't have to provide the necessary training once the person joins. Worst, they called their recruitment process a very high standard as an excuse but this is a very wrong culture, especially for freshers starting their career as they're looking for highly technical skills. My writing sample and behaviour round went super well but the ultimate deciding factor for them was the case study round. I think it just shows how rigid they are and how they willingly ignore my other capabilities and stuck on that one round to make a decision. Would have been better if they just took the case stud round first if they were so specific on that skill set instead of wasting my time. The interviewer for the case study round was very rude and over confident on his skills and expertise that he wasn't willing to fully listen to me or let me complete my answer it felt like he already knew he didn't find me a fit. Gartner could be a good organisation overall but I think individuals in this company such as the one interviewing for this role is not doing any justice to the good reputation.
vinay kn
Interview experience
Good
Difficulty level
Moderate
Process Duration
-
Result
No response
I was interviewed in Dec 2024.
Round 1 - Technical
(6 Questions)
- Q1. What is spark,explain its ecosystem
- Q2. What are transformations, and how many types of transformations exist?
- Q3. Explain about spark job process and its planning
- Q4. What are the concepts of coalesce and repartition in data processing?
- Q5. Explain about oom and driverhead memory
- Q6. What is data skewness
Add your answer
Add your answer
Add your answer
Add your answer
Add your answer
Add your answer
Interview experience
Excellent
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
No response
I applied via campus placement at National Institute of Technology (NIT), Warangal and was interviewed in Nov 2024. There were 3 interview rounds.
Round 1 - Aptitude Test
Normal to medium level general aptitude questions
Round 2 - Technical
(2 Questions)
- Q1. Types of building contract
- Q2. Type of soil for each buildings
Add your answer
Add your answer
Round 3 - One-on-one
(2 Questions)
- Q1. Assesment day GD for 2 rounds
- Q2. All situational based questions
Add your answer
Add your answer
Interview Preparation Tips
Topics to prepare for WSP Due Diligence Analyst interview:
- Building contracts
- Soil Mechanics
Interview experience
Average
Difficulty level
Moderate
Process Duration
2-4 weeks
Result
Selected
Round 1 - One-on-one
(2 Questions)
- Q1. Explain projects worked on and benefits
- Q2. What is agile , SDLC, user stories
- Ans.
Agile is a project management methodology focused on iterative development, SDLC is the software development life cycle, and user stories are short descriptions of a feature told from the perspective of the end user.
Agile is a project management approach that emphasizes flexibility, collaboration, and customer feedback.
SDLC is the process of planning, creating, testing, and deploying software applications.
User stories ...
Add your answer
Answered by
AI
Add your answer
Round 2 - One-on-one
(2 Questions)
- Q1. How will to create a new market in vietnam for LC/BG
- Ans.
To create a new market in Vietnam for LC/BG, we can start by conducting market research, building relationships with local businesses and government agencies, and offering tailored financial solutions.
Conduct market research to understand the needs and preferences of Vietnamese businesses
Build relationships with local banks, businesses, and government agencies to establish credibility and trust
Offer tailored financial ...
- Q2. What is acceptance criteria
- Ans.
Acceptance criteria are conditions that a product must satisfy to be accepted by a user, customer, or stakeholder.
Acceptance criteria are typically defined during the planning phase of a project.
They are used to determine whether a product or feature is complete and functioning as expected.
Acceptance criteria are often written in a specific format, such as 'Given X, when Y, then Z.'
They help ensure that the product mee...
Answered by
AI
Add your answer
Answered by
AI
Add your answer
Skills evaluated in this interview
Dhiraj Dhande
Interview experience
Excellent
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Technical
(5 Questions)
- Q1. What is Derivatives
- Q2. What is financial Markets
- Q3. V Lookup, X Lookup, H lookup
- Q4. Experience in SQL And Power bi
- Q5. Internship Experience
Add your answer
Add your answer
Add your answer
Add your answer
Add your answer
Artefact Interview FAQs
How many rounds are there in Artefact interview?
Artefact interview process usually has 2 rounds. The most common rounds in the Artefact interview process are Technical.
How to prepare for Artefact interview?
Go through your CV in detail and study all the technologies mentioned in your CV. Prepare at least two technologies or languages in depth if you are appearing for a technical interview at Artefact. The most common topics and skills that interviewers at Artefact expect are AWS, GCP, Python, AWS Glue and Analytical skills.
Tell us how to improve this page.
Interview Questions for Popular Designations
Artefact Interview Process
based on 1 interview
Interview experience
View more
Interview Questions from Similar Companies
Compare Artefact with
Accenture
Compare
Wipro
Compare
TCS
Compare
Infosys
Compare
Popular Calculators
Did you find this page helpful?
Yes No
- Home >
- Interviews >
- Artefact Interview Questions
Share an Interview