Logo of Huzzle

Quality Assurance Testing Specialist - Contract Full Time

image

Scotiabank

22d ago

  • Job
    Full-time
    Expert Level
  • Data
    Software Engineering
  • Toronto

AI generated summary

  • You have 9+ years in QA with ETL testing, expert SQL skills, experience in automation (Robot, Python), data warehouse concepts, Hadoop, and strong communication abilities in Agile environments.
  • You will conduct functional and non-functional testing of ETL/ELT jobs, develop test plans, execute tests, and establish a repeatable testing framework while ensuring management is informed.

Requirements

  • Your passion for Software/Data Quality and ETL testing
  • Exposure to Big Data, Enterprise Data Lake, Hadoop is an asset
  • Expert knowledge of SQL queries, ETL, Back-End testing
  • Work with Technology Partners, Source Teams, Developers, Business Analysts to understand mapping and resolve complex data logic
  • Work with QAT Leads across value streams within QAT to understand test data requirements and facilitate test data preparation
  • You are diligent with documenting test artifacts such as, test plans, test cases, test results and defect reports
  • You are proactive and part of a dynamic team in an Agile environment
  • You work with your scrum team to design and develop test strategies, testability requirements and implementation strategies
  • You will contribute to test automation tools and infrastructure by creating and augmenting test cases and test libraries
  • You are comfortable working in a self-guided manner with the ability to prioritize tasks and manage your own time efficiently, without direct input or oversight
  • You work as part of a team and encourage both individual and collaborative innovation
  • You’re a fast learner who has an appetite for learning what’s behind both simple and complex solutions
  • You have a positive and resilient personality. You must be able to embrace feedback and have a desire for continuous iteration and improvement
  • You have strong analytical and problem resolution skills
  • QA Specialist with strong ETL testing background, minimum of 9 years of experience
  • Excellent knowledge of SQL
  • Experience with Automation skills such as Robot framework, Python, etc.,
  • Excellent knowledge of data warehouse concepts and database such as Oracle, DB2, SQL Server, NoSQL(MongoDB, Cassandra)
  • Experience with one or more ETL applications like Talend, SSIS, Data Stage, Informatics, Oracle Data Integrator
  • Testing experience in Hadoop and public cloud environment, including Azure
  • Working knowledge of JIRA, Data Comparison tools
  • You have experience in software testing techniques, methodologies, and tools
  • Establish traceability between test cases, user stories and bugs
  • Expert understanding of UAT standards and methodology
  • Testing Automation strategy definition and execution
  • Effective communication skills to address issues with QA testing and other department staff who have varying degrees of experience and technological knowledge
  • Outstanding written and verbal communication abilities

Responsibilities

  • This position will help to ensure to perform functional and non-functional testing of ETL/ELT jobs for data and analytics platforms, including but not limited to Hadoop, Azure, SQL server, DB2, Oracle, NoSQL. Developing test plans that ensure appropriate functions, features and scenarios are exercised for each new application/release; driving test development and execution to meet the project objectives for each new application/release; testing code fixes and change requests after the data integration jobs move into production including regression testing as appropriate; and establishing a testing framework that promotes a repeatable, quality-driven test process for all phases of the software development lifecycle. Guided by Bank policy, receives direct supervision from the Senior Manager. Within a well-defined task, the QA Specialist is expected to function independently while ensuring that management is kept informed, and that problems and issues are escalated appropriately.

FAQs

What is the job title for this position?

The job title is Quality Assurance Testing Specialist - Contract Full Time.

What are the primary responsibilities of this role?

The primary responsibilities include performing functional and non-functional testing of ETL/ELT jobs, developing test plans, driving test development and execution, and establishing a testing framework throughout the software development lifecycle.

What qualifications are required for this position?

Candidates should have a minimum of 9 years of experience as a QA Specialist, strong ETL testing background, excellent knowledge of SQL, and experience with automation skills such as Robot Framework and Python.

Is experience with Hadoop required for this role?

While not explicitly required, exposure to Big Data and Hadoop is considered an asset for this position.

What tools or technologies should candidates be familiar with?

Candidates should have experience with database concepts and tools such as Oracle, DB2, SQL Server, NoSQL (MongoDB, Cassandra), as well as ETL applications like Talend, SSIS, Data Stage, Informatica, and Oracle Data Integrator.

What type of work environment can one expect in this role?

The work environment is collaborative, dynamic, and Agile, encouraging both individual and team contributions.

What are the benefits of working with Scotiabank?

Benefits include a competitive rewards program, flexibility in vacation days, personal and sick days starting from day one, opportunities for upskilling, and a commitment to diversity, equity, and inclusion.

How does Scotiabank support accessibility in the workplace?

Scotiabank is committed to creating and maintaining an inclusive and accessible environment and will accommodate individuals during the recruitment process as needed.

What is the location for this position?

The position is located in Toronto, Ontario, Canada.

Are there opportunities for community engagement at Scotiabank?

Yes, there are various programs for community engagement including hackathons, contests, and team-building activities.

Finance
Industry
10,001+
Employees

Mission & Purpose

Welcome to Scotiabank. We serve thousands of customers, families, and communities across the globe, helping them achieve success through advice, products, and services. Follow for news, insights, thought leadership and more.

Culture & Values

  • Respect

    Everyone is always treated with dignity; diverse backgrounds and experiences are what make us better as a whole.

  • Integrity

    Acting honorably comes first – earning the trust of our customers (and each other) is what matters most.

  • Passion

    We’re enthusiastic about what we do, and want you to feel the same way. Imagine coming in to work, and actually feeling excited to learn!

  • Accountability

    We commit, we take action, and most importantly, we take responsibility for those actions. It’s just the right thing to do.