Greetings from TCS!!!

TCS has been a great pioneer in feeding the fire of Techies like you. We are a global leader in the technology arena and there’s nothing that can stop us from growing together.

Your role is of key importance, as it lays down the foundation for the entire project.

Make sure you have a valid EP number before the interview. To create an EP Number, please visit https://ibegin.tcs.com/iBegin/register

Kindly complete the registration if you have not done it yet.

Role: ETL Test Lead

Experience: 10-15 years

Location: Bangalore, Chennai, Hyderabad, Pune, Bhubaneshwar, Kochi

Skills: ETL, SQL

Notice Period: Immediate joiner to 30 days

Must-Have:

1. 10+ years’ experience as ETL Tester, SQL & ETL Tools Knowledge
2. Validating the data sources, extraction of data, applying transformation logic, and loading the data in the target tables.
3. Count check, Reconcile records with the source data, Data type check
4. Validate Transformation logic on raw data and identify any discrepancies
5. Record count check, before and after the transformation logic applied.
6. Data flow validation from the staging area to the intermediate tables, intermediate to target systems.
7. Validate all keys are getting populated correctly.
8. Ensure the key field data is not missing or Null, check aggregate values and calculated measures are loaded in the fact tables.
9. Check modeling views based on the target tables, CDC has been applied on the incremental load table, Data check in dimension table and history table check.
10. Check the BI reports based on the loaded fact and dimension table and as per the expected results.
11. Create, design, and execute the test plans and test cases.

Good-to-Have:

1. Informatica or any other ETL tool
2. Understanding of AWS Services.

Thanks & Regards

Shubhangi