Test Engineer - ETL
Location : Toronto – Hybrid
Job Summary:
· Developing Test Strategies, Test Plans and Closure Reports.
· Daily/Weekly Test Status Reporting.
· Reviewing Testing related documents with Stakeholders make sure Testing is on track.
· Review system requirements and design documents, then create, execute and document detailed, accurate test cases.
· Analyze, develop, debug, execute, maintain, and document test cases.
· Help define test data and environment requirements.
· Provide support to your technology peers and the business. join forces to identify solutions.
· Play an active role in developing test strategies and plans, traceability matrices and test closure reports, for small to moderately complex projects.
· Offer day-to-day test environment support, trouble shoot, triage issues, coordinate resolution with all tech partners.
· Promptly identify and raise awareness of issues. quickly resolve them.
· Find ways to improve processes and delivery outcomes.
· Promote and develop awareness of testing methodologies and standards.
· Respect TD's technology delivery practices, standards and project management disciplines.
· Continuously enhance knowledge and expertise, keep current.
· Coach colleagues and act as a reference for the requirements management life cycle.
· Identify testing risks within projects and provide testing solutions/processes to mitigate the risks
· Technical testing certificate such as ASQ CSQE or ISTQB.
· Knowledge of testing methodology, best practices and processes (including but not limited to automation, performance and data management methodologies).
· Talent in testing risks within projects and recommending ways to mitigate them.
· Adherence to prescribed testing processes, and identify, assess and address risks.
· Advanced knowledge of SQL.
· Experience in working with complex data sources like SQL and no SQL databases, XML files, fixed length files, multi-segmented clustered and un-clustered files etc.
· Experience in Hadoop ecosystem including strong understanding of HQL, HDFS data storage, data partitioning and data ingestion/extraction via scoop/oozie
· Have hands on ETL testing and test automation experience using in-house automation framework or industry ETL testing tools
· Experience with one of programming/scripting language – Java, Python, Jquery, javascript, Angular, VBA etc
· Hands-on experience with Unix/Shell/Bash scripting
· Knowledge of Cucumber, Bitbucket – Good to have
· Have working knowledge of Jira and Confluence
· Working experience with Tableau - Good to have