ETL Testing

ETL Tools: Experience of ETL tools like INFA (Informatica), TALEND, IBM DATA STAGE, Microsoft SSIS, PENTHO etc. Awareness of these tools’ setup, operation, and ways of tracking their performance Keeping down the focus on Established knowledge of tool setup, tool usage, and the ways of tracking their performance SQL Proficiency: Capability of producing intricate SQL statements to check data consistency at some point in the ETL process. This would include joining, aggregation, subqueries and data manipulation among others.

Scripting Languages: Scripting languages like Python, Java or Perl for test automation and/or for data manipulation purposes could be helpful. Stored Proc testing is must