LTIMindtree ETL Tester Interview Questions and Answers

Use SQL query to find the nth row and top 50% records using string function

• To find the nth row, use LIMIT and OFFSET in SQL query

• To find top 50% records, use PERCENTILE_CONT function in SQL

• String functions like SUBSTRING can be used to manipulate string data

Use SQL DATEDIFF function to calculate age from date of birth.

• Use DATEDIFF function to calculate the difference in years between current date and date of birth.

• Example: SELECT DATEDIFF(year, '2000-01-01', GETDATE()) AS Age;

• Make sure to handle leap years and edge cases like birthdate being in the future.

Slowly Changing Dimensions (SCD) are techniques used in data warehousing to track changes to dimension data over time.

• SCD Type 1: Overwrites old data with new data, losing historical information.

• SCD Type 2: Creates new records for each change, preserving historical data.

• SCD Type 3: Creates additional columns to track changes, allowing limited history.

• SCD Type 4: Uses separate tables to store historical and current data...read more

I am a dedicated ETL Tester with 5 years of experience in testing data integration processes and ensuring data quality.

• 5 years of experience in ETL testing

• Proficient in testing data integration processes

• Skilled in ensuring data quality

• Strong attention to detail

• Excellent problem-solving skills