Responsibilities of an ETL tester

Responsibilities of an ETL tester

Key responsibilities of an ETL tester are segregated into three categories
  • Stage table/ SFS or MFS
  • Business transformation logic applied
  • Target table loading from stage file or table after applying atransformation. 
Some of the responsibilities of an ETL tester are
  • Test ETL software
  • Test components of  ETL datawarehouse
  • Execute backend data-driven test
  • Create, design and execute test cases, test plans and test harness
  • Identify the problem and provide solutions for potential issues
  • Approve requirements and design specifications
  • Data transfers and Test flat file
  • Writing SQL queries3 for various scenarios like count test

ETL Performance Testing and Tuning

ETL performance testingis a confirmation test to ensure that an ETL system can handle the load of multiple users and transactions.  The goal of performance tuning is to optimize session performance by eliminating performance bottlenecks. To tune or improve the performance of the session, you have to identify performance bottlenecks and eliminate it. Performance bottlenecks can be found in source and target databases, the mapping, the session and the system. One of the best tools used for performance testing is Informatica.

Automation of ETL Testing

The general methodology of ETL testing is to use SQL scripting or do “eyeballing” of data.. These approaches to ETL testing are time-consuming, error-prone and seldom provide complete test coverage. To accelerate, improve coverage, reduce costs, improve defect detection ration of ETL testing in production and development environments, automation is the need of the hour. One such tool is Informatica.