TEST ENGINEER - ETL

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