ETL Test Automator (Java/Python/SQL)
We’re looking for software engineers with a passion for assuring quality. With this opportunity you’ll support building and executing automated tests to verify ETL processes for a client in the Canadian Banking domain with Canada s largest Information Technology Outsourcing and Management Consulting Company. Please see details below and apply if you fit the bill!
Your future duties and responsibilities:
• Provide test development / automation to ensure that the quality of the intended solution is met.
• Provide inputs for test planning, test design / development test case automation and test execution to achieve business outcomes.
• Integrate directly into a team s continuous delivery process, augmenting the delivery of quality software and ensuring speed, agility and risk management.
• Implement functional and non-functional automation (performance, readiness / reliability testing, accessibility, security) approach, frameworks, script development and execution, and ensure automated tests are integrated into the continuous integration, delivery, and testing (CI/CD/CT) pipelines.
• Ensure source code management looking for opportunities to effectively leverage tools and engineering practices (DevOps tools and processes, SV, monitoring tools and process, etc.
• Apply the principles of Behaviour / Test-Driven Development (BDD / TDD) and focus on value driven outcomes.
• Provide subject matter expertise considering overall quality / performance, user experience, and future bug prevention.
• Monitor service, productivity and assess efficiency levels within own function and implement continuous process / performance improvements where opportunities exists.
• Work collaboratively with the team and leadership to proactively identify and resolve issues related to product quality.
Required qualifications to be successful in this role:
• Bachelor s Degree in Computer Science OR Diploma in IT with equivalent IT experience
Required Experience:
• 3-7 years of relevant experience
• Experience with automation testing.
• Ability to code in Python (or Java).
• Proficient in writing complex SQLs.
• Sound knowledge with ETL/ Backend testing.
ETL
• Strong RDBMS SQL Skills (SQL Server, DB2, joins, pivots, subquery parameterization)
• Ability to establish connections to new sources of data or different databases (Python/JDBC)
• Working knowledge of Autosys Scheduler
• Strong analytical skills to observe and report data discrepancies
PYTHON
• Basics and File Handling
JAVA
• Programs, Classes, Objects, Encapsulation, Dates, Arrays, Exceptions
GENERAL
• Critical thinking and problem solving; demonstrates the ability to apply with day-to-day tasks and decisions
• Working knowledge of git/bitbucket to make contributions to the automation code (ex. branching, creating pull request, merging)
• Working knowledge of JIRA
• Excellent communication skills and the ability to interact directly with Client Stakeholders, Senior Management, and/or our technology partners
• Strong interpersonal skills
• Strong written and oral communication skills
• Positive attitude
• The ability to build consensus and resolve interpersonal challenges
• Ability to build strong relationships with clients and team members
• Demonstrate the ability to provide information and ideas in a clear, comprehensive, concise and organized manner
• Coach and mentor other members
Nice to Have:
• Experience with Workday
• Exposure to Spark, Scala, Hadoop
• Ability to work with Spring MVC, JSP, HTML, and JavaScript
• ISTQB Certified Foundation Level with Agile extension (and/or other industry recognized testing certifications)
• SAFe SP Certified (and/or other industry recognized agile certifications)
Skills:
- ETL
- Python
- SQL
- Java
- Agile Testing