I applied via
Naukri.com
and was interviewed in Nov 2024. There
was
1 interview round.
Round 1 - Technical
(2 Questions)
Q1. Explainyour job role
Ans.
ETL Developers are responsible for designing, developing, and maintaining ETL processes to extract, transform, and load data from various sources into a data warehouse.
Designing ETL processes to extract data from multiple sources
Transforming data to meet business requirements
Loading data into a data warehouse or other target systems
Developing and maintaining ETL jobs using tools like Informatica, Talend, or SSIS
Answered by
AI
Add your answer
Q2. Explain implementation of SCD 1 in IICS
Ans.
SCD Type 1 in IICS involves overwriting existing data with new data without maintaining historical changes.
In IICS, use the Mapping Designer to create a mapping that loads data from source to target.
Use a Lookup transformation to check if the record already exists in the target table.
If the record exists, update the existing record with new data using an Update Strategy transformation.
How many rounds are there in WERTMARK TECHNOLOGIES Senior SQL Developer interview?
WERTMARK TECHNOLOGIES interview process usually has 2 rounds. The most common rounds in the WERTMARK TECHNOLOGIES interview process are Resume Shortlist and Technical.
What are the top questions asked in WERTMARK TECHNOLOGIES Senior SQL Developer interview?
Some of the top questions asked at the WERTMARK TECHNOLOGIES Senior SQL Developer interview -
write an sp to with 5 input var and one output var,all int and display the max ...read more
write a job scheduler code to backup up database daily at a particular t...read more