ETL Tester


Posted 2 years ago

We’re looking for a Fullstack Developer! Reach out if you’re interested and feel free to refer friends/colleagues!


Type of Employment: Contract
Title: Fullstack Developer
Term: 12-month Contract
Location: Remote for now – Mississauga
Job ID number: C13406


Brief description of duties:


  1. Analyze business requirements, participate in requirement discussions
  2. Collaborate with project managers, data architects, and developers to create effective test strategies and test plans
  3. Develop EWD test scripts based on technical specifications/design documents
  4. Work on heterogeneous source systems like flat files, Oracle, SQL server, etc. and develop test scripts for data validation
  5. Testing and validating data for new/updated tables and processes
  6. Conduct end to end testing to ensure data quality and data integrity
  7. Identify test approach, plan test strategy, develop test scripts, test execution, and report defects
  8. Monitor and run Informatica workflows and perform data validation


MUST haves:


  • In-depth SQL knowledge
  • Knowledge of Oracle and SQL Server databases
  • Good understanding of Data Warehouse concepts
  • EDW Testing knowledge
  • Informatica Tool Knowledge


Nice to haves:


  • ETL automation tool experience
  • Banking Domain Knowledge
  • Unix shell scripting

Job Features

Job CategoryETL Tester
Oracle and SQL databases5-6
Data WarehouseAsset
EDW TestingAsset

Apply Online