ETL Test Lead

Role & responsibilities

ETL Testing with Stored Procedures and SSIS

Lead Role who has completed End to End Project.

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

ETL Tools: Knowledge 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

Database Knowledge: Specificity with knowledge of various DBMS available today such as Oracle, SQL server, MySQL, and PostgreSQL among others and the specialties that are associated with these systems.

Data Warehousing Concepts: Knowledge of fundamental concepts of data as well as types of schemas, OLAP and OLTP, and data marts.

Preferred candidate profile

ETL Testing with Stored Procedures and SSIS

Lead Role who has completed End to End Project.