Upload Button Icon Add office photos
Engaged Employer

i

This company page is being actively managed by Datamatics Global Services Team. If you also belong to the team, you can get access from here

Datamatics Global Services Verified Tick

Compare button icon Compare button icon Compare

Filter interviews by

Datamatics Global Services ETL Developer Interview Questions and Answers

Updated 4 Dec 2024

Datamatics Global Services ETL Developer Interview Experiences

1 interview found

Interview experience
3
Average
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Technical 

(2 Questions)

  • Q1. Minimum 14 character required
  • Q2. Maximum 1400 character required

Interview questions from similar companies

Interview experience
1
Bad
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Technical 

(1 Question)

  • Q1. Greatest challenge faced while migrating to cloud from onpremise DB
  • Ans. 

    The greatest challenge faced during migration to cloud from on-premise DB is ensuring data security and compliance.

    • Ensuring data security during transit and at rest

    • Maintaining compliance with regulations and industry standards

    • Minimizing downtime and ensuring data integrity

    • Optimizing performance and cost efficiency in the cloud environment

  • Answered by AI

Skills evaluated in this interview

Interview experience
4
Good
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Campus Placement and was interviewed before Jan 2022. There were 4 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 - Assignment 

It's an assignment for apti, verbal

Round 3 - Technical 

(1 Question)

  • Q1. It's like an what are u mentioned in resume skills.
Round 4 - HR 

(1 Question)

  • Q1. Just like interaction with candidate like personal details.

Interview Preparation Tips

Interview preparation tips for other job seekers - Be prepare on what u mentioned in resume skills and self confidence..

ETL Developer Interview Questions & Answers

TCS user image Vikash Kumar

posted on 21 Oct 2024

Interview experience
5
Excellent
Difficulty level
Easy
Process Duration
-
Result
Selected Selected

I applied via Campus Placement and was interviewed before Oct 2023. There was 1 interview round.

Round 1 - Technical 

(2 Questions)

  • Q1. Lookup transformation
  • Q2. Joiner transformation
Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
2-4 weeks
Result
Selected Selected

I applied via Campus Placement and was interviewed before Aug 2022. 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 - Coding Test 

2 coding questions, 1 hr and Aptitude questions are also clubbed into other section.

Round 3 - HR 

(3 Questions)

  • Q1. Are flexible with location
  • Ans. Yes, I am flexible with location
  • Answered Anonymously
  • Q2. Are you ok if we give you testing project
  • Ans. 

    Yes, I am open to taking on a testing project as part of my role as an ETL Developer.

    • I have experience with testing tools and methodologies in my previous roles.

    • I understand the importance of testing in ensuring data accuracy and quality.

    • Taking on a testing project will help me improve my skills and knowledge in ETL development.

  • Answered by AI
  • Q3. Are you flexible with working hours

Interview Preparation Tips

Interview preparation tips for other job seekers - You will get great experience in TCS. If you are 30+yrs age and want stability then join TCS.
Interview experience
2
Poor
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
No response

I applied via Referral and was interviewed in Jul 2024. There was 1 interview round.

Round 1 - One-on-one 

(1 Question)

  • Q1. Which version of talend you are using
  • Ans. 

    I am using Talend version 7.3.1 for ETL development.

    • I am currently using Talend version 7.3.1 for ETL development.

    • The specific version of Talend being used is 7.3.1.

    • Talend 7.3.1 offers various features and improvements for ETL processes.

  • Answered by AI

Skills evaluated in this interview

Interview experience
4
Good
Difficulty level
-
Process Duration
-
Result
Not Selected
Round 1 - One-on-one 

(2 Questions)

  • Q1. Self introduction
  • Q2. Scenario based questions

Interview Preparation Tips

Interview preparation tips for other job seekers - Nothing
Interview experience
2
Poor
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Technical 

(1 Question)

  • Q1. Performance tuning of ssis packages
  • Ans. 

    Performance tuning of SSIS packages involves optimizing data flow, memory usage, and parallelism.

    • Optimize data flow by using efficient data sources and destinations

    • Minimize memory usage by using appropriate buffer sizes and reducing unnecessary data transformations

    • Increase parallelism by using multiple threads and optimizing task execution order

    • Use performance monitoring tools like SSIS logging and performance counters...

  • Answered by AI
Round 2 - Technical 

(1 Question)

  • Q1. Basics,ETL Process and performance tuning
Round 3 - HR 

(1 Question)

  • Q1. Past experience

Skills evaluated in this interview

Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
-
Result
Selected Selected

I applied via Campus Placement and was interviewed before Feb 2023. There was 1 interview round.

Round 1 - Technical 

(1 Question)

  • Q1. Informatica power centre transformation questions
Interview experience
2
Poor
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Technical 

(2 Questions)

  • Q1. What is loads in informatica
  • Ans. 

    Loads in Informatica refer to the process of moving data from source to target in a data warehouse.

    • Loads involve extracting data from source systems

    • Transforming the data as needed

    • Loading the data into the target data warehouse or database

    • Loads can be full, incremental, or delta depending on the requirements

    • Example: Loading customer data from a CRM system into a data warehouse for analysis

  • Answered by AI
  • Q2. Query to find duplicates in table
  • Ans. 

    Use GROUP BY and HAVING clause to find duplicates in a table.

    • Use GROUP BY to group rows with same values together

    • Use HAVING COUNT(*) > 1 to filter out duplicates

    • Example: SELECT column_name, COUNT(*) FROM table_name GROUP BY column_name HAVING COUNT(*) > 1;

  • Answered by AI

Skills evaluated in this interview

Datamatics Global Services Interview FAQs

How many rounds are there in Datamatics Global Services ETL Developer interview?
Datamatics Global Services interview process usually has 1 rounds. The most common rounds in the Datamatics Global Services interview process are Technical.
How to prepare for Datamatics Global Services ETL Developer 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 Datamatics Global Services. The most common topics and skills that interviewers at Datamatics Global Services expect are ETL, Hadoop, Informatica, Python and AWS.
What are the top questions asked in Datamatics Global Services ETL Developer interview?

Some of the top questions asked at the Datamatics Global Services ETL Developer interview -

  1. Maximum 1400 character requi...read more
  2. Minimum 14 character requi...read more

Tell us how to improve this page.

Datamatics Global Services ETL Developer Interview Process

based on 1 interview

Interview experience

3
  
Average
View more

Datamatics Global Services ETL Developer Reviews and Ratings

based on 1 review

1.0/5

Rating in categories

1.0

Skill development

1.0

Work-life balance

1.0

Salary

1.0

Job security

1.0

Company culture

1.0

Promotions

1.0

Work satisfaction

Explore 1 Review and Rating
Consultant
787 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Associate Consultant
663 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Executive
608 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Senior Executive
328 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Executive Accountant
297 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Explore more salaries
Compare Datamatics Global Services with

TCS

3.7
Compare

Wipro

3.7
Compare

Infosys

3.6
Compare

HCLTech

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