Connect Infosoft Technologies ETL Developer Interview Questions and Answers

Q1. SQL query and informatica scenario based questions
Add your answer

Q1. Explain the difference between ETL and ELT?
Ans. 
ETL is Extract, Transform, Load where data is extracted, transformed, and loaded into a data warehouse. ELT is Extract, Load, Transform where data is extracted, loaded into a data warehouse, and then transformed.
• ETL involves extracting data from source systems, transforming it according to business rules, and loading it into a data warehouse.

• ELT involves extracting data from source systems, loading it into a data wareh...read more
Answered by AI
Add your answer

Q1. What is the uses of filter stage
Ans. 
Filter stage is used in ETL processes to selectively pass or reject data based on specified criteria.
• Filter stage helps in removing unwanted data from the input dataset.

• It can be used to apply conditions like filtering out duplicate records, selecting specific columns, or excluding certain values.

• For example, a filter stage can be used to only pass records where the sales amount is greater than $1000.
Answered by AI
Add your answer
Q2. What is the uses of transfor stage
Ans. 
Transform stage is used in ETL process to apply business rules, clean and enrich data before loading into target database.
• Transform stage is used to apply business rules to the data.

• It is used to clean and standardize data before loading into the target database.

• Transform stage can also be used to enrich data by combining multiple sources or adding calculated fields.

• Examples include converting data types, removing dupl
Answered by AI
Add your answer
Q3. What is the uses of sort stage
Ans. 
Sort stage is used in ETL processes to sort data based on specified criteria before loading it into the target system.
• Sort stage helps in arranging data in a specific order for better analysis and reporting

• It can be used to remove duplicates from data before loading

• Sorting can be done based on multiple columns or expressions

• Example: Sorting customer data based on their purchase amount before loading into a data warehou
Answered by AI
Add your answer
Q4. How to create the prallel job
Ans. 
To create a parallel job, use parallel processing techniques to divide tasks into smaller subtasks that can be executed simultaneously.
• Identify tasks that can be executed independently and in parallel

• Use parallel processing techniques such as multi-threading or distributed computing

• Implement parallel job using ETL tools like Informatica or Talend

• Monitor and optimize parallel job performance to ensure efficient executio
Answered by AI
Add your answer
Q5. Defenation of scd
Ans. 
SCD stands for Slowly Changing Dimension, a technique used in data warehousing to track changes in dimension attributes over time.
• SCD is used to maintain historical data in a data warehouse

• There are different types of SCDs - Type 1, Type 2, and Type 3

• Type 1 SCD overwrites old data with new data

• Type 2 SCD creates a new record for each change and maintains history

• Type 3 SCD keeps a limited history by adding columns to tr
Answered by AI
Add your answer

Q1. Basic questions based on Informatica power center
Add your answer

Q1. Scenario based questions on Informatica power center
Add your answer

Q1. Basic salary and other discussion
Add your answer

Basic Informatica and SQL questions

Q1. Basic informatica questions on duplicate removal and others, SQL query writing
Add your answer

Q1. What are your salary expectations?
Add your answer
Q2. Share details of your previous job.
Add your answer
Q3. Why are you looking for a change?
Add your answer
Q4. Tell me about yourself.
Add your answer

Q1. Some in depth questions about python and java
Add your answer

Asked some problem solving questions they will allow to choose the language it's good

Q1. What is inital load in ETL
Ans. 
Initial load in ETL refers to the process of loading data from source systems into the data warehouse for the first time.
• Initial load is typically a one-time process to populate the data warehouse with historical data.

• It involves extracting data from source systems, transforming it as needed, and loading it into the data warehouse.

• Initial load is often done using bulk loading techniques to efficiently transfer large vo...read more
Answered by AI
Add your answer
Q2. What is difference between cluster and non cluster index
Ans. 
Cluster index physically orders the data on disk, while non-cluster index does not.
• Cluster index physically orders the data on disk based on the indexed column

• Non-cluster index does not physically order the data on disk

• Cluster index can only have one per table, while non-cluster index can have multiple

• Cluster index is faster for retrieval but slower for inserts and updates
Answered by AI
Add your answer

Q1. Basic Question Answer
Add your answer
Q2. Basic SQL , SNWOFLAKE AND ETL Concepts
Add your answer