In this article, i’m going to share my interview experience with Datametica for the Data Engineer Role with below skills:
Thank you for reading this post, don't forget to subscribe!- Primary Skills – Hands-on and deep experience working in ETL Development with Informatica or DataStage/Strong in SQL Query
- Mandatory Skills: experience in cloud (AWS,GCP, Azure, Snowflake)
Table of Contents
About Datametica
Datametica is well known Indian company headquartered in Pune that helps businesses by migrating the infrastructure application using Data/Workload/ETL/Analytics to the Cloud by using in the house migration Automation product. Datametica has their own Automated products:
- Eage: Data warehouse Assessment & migration Planning Product
- Raven: Automated Workload Conversion product
- Pelican: Automated Data Validation Tool
Datametica helps automates and make the data migration much faster to the cloud enabling the businesses smooth transitioning to the cloud with greater Accuracy, Lesser Risk and with best market cost. Datametica have expertise in legacy software like Teradata, Oracle, Hadoop, Netezza, Vertica, Greenplum along with the ETLs technologies like Informatica, Datastage, Abinitio and others. Datametica enables the business with other capabilities in Data Engineering, advanced analytics solution, data management and implementation and cloud optimization. Refer to the Datametica Linkedin for more details and jobs openings.
Interview Experience for Data Engineer Role
In this section, i will discuss about the interview questions and share my experience for the Data Engineer Role. Primarily the opening was for the candidate who have 4-6 years of experience with good understanding and hands-on of the ETL tools like Informatica, IICS and Datastage as these tools are being used to migrate the large database and warehouses. Also, the advanced SQL which is the main programming/database language used in the migration process.
HR Process
The recruiter from the Datametica will reach out to you based on your profile from Naukri, Linkedin or Indeed and will ask for all the required details like year of experience, tools and technologies you’re working , current CTC and the expected CTC. After this discussion, if you’re fit candidate, HR will schedule the interview. As per the the HR discussion over the phone, there will be two rounds of technical interview and last round will be HR where they’ll negotiate the salary and other compensation/rewards.
L1 – Interview
L1 Interview was moderate difficulty as the question were asked basically around my experience in ETL technologies and the past projects.
Tell me about yourself
The first interview question in any interview will be ‘Tell me about yourself‘. Here, I would recommend to candidate to go through your resume and try to remember as many point as they can so that it can be used during the introduction section. Sometimes you can get selected based on this section as you have to sound confident and show that you have the required skills to get onboard and help the business grow.
List of ETL Interview Technical round question
- What is the difference between Informatica and Informatica Cloud?
- What are the challenges faced by the team while migrating from Informatica to IICS, explain in detail.
- Why the business moved from Oracle to PostgreSQL?
- What is persistent cache in Informatica, explain with one scenario?
- Informatica scenario: You have a flat file with data 1, 1, 1 , 2 and so on, you have to reject all 1 data and load in Target 1 and load the other data in Target 2. How will you achieve this using Informatica and SQL?
- Find the Third highest salary with the below data, so that all top salary is determined as 1 and there on.
- What is the difference in Rank and Dense Rank window function and tell me how the data will look from the above table?
- You have to give increment based on the rating for coulmn id – 1, 2, 4,3,1
- Rating : 1 – 15%, 2 -10%, 3 – 5%, 4 – 0%. Try using SQL and Informatica.
| Id-PK | Salary |
| 101 | 200K |
| 102 | 200K |
| 103 | 200K |
| 104 | 100K |
| 105 | 50K |
| 106 | 25K |
7.Assume you have flatfile and you need to load only the last record in the database. Explain using Informatica and SQL?
8. You have a source and target and you need to load only data based on PK – ID and emp_department when there is a change in source and it doesn’t exit in the target. How will you do using Informatica and SQL, explain in detail?
Conclusion
For the role of Data Engineer the question was asked primarily from the Informatica and SQL and of moderate complexity. Also, if you are preparing for any Data Engineering and Data Analyst role the above SQL question can be asked in the interview.
