Walkin Kochi_TCS Hiring for ETL Tester

Job Title: ETL Tester

Location: Kochi - Direct Face to Face - walkin

Experience: 5 to 12 Years

Job Description:

Experience:

Key Skills

ETL, SQL

Must have Skills

• 3+ years’ experience as ETL Tester, SQL & ETL Tools Knowledge
• Validating the data sources, extraction of data, applying transformation logic, and loading the data in the target tables.
• Count check, Reconcile records with the source data, Data type check
• Validate Transformation logic on raw data and identify any discrepancies
• Record count check, before and after the transformation logic applied.
• Data flow validation from the staging area to the intermediate tables, intermediate to target systems.
• Validate all keys are getting populated correctly.
• Ensure the key field data is not missing or Null, check aggregate values and calculated measures are loaded in the fact tables.
• 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.
• Check the BI reports based on the loaded fact and dimension table and as per the expected results.
• Create, design, and execute the test plans and test cases.

Good to have (Knowledge)

• Informatica or any other ETL tool
• Understanding of AWS Services.