Finance Systems Tester

TechDoQuest; Markham; On-site; CAD 75,000 - 90,000; Full time

Job summary

A technology company in Markham is seeking a Mid-Senior level IT Analyst to deliver solutions and test applications in the P&C insurance domain. Responsibilities include analyzing requirements, conducting various types of testing, and collaborating with cross-functional teams. The ideal candidate will have 3+ years of ETL testing experience and a solid understanding of SQL. This is a full-time role in the IT Services and Consulting industry.

Qualifications

• 3–6+ years of experience in ETL testing for Datawarehouse applications.
• Strong domain knowledge of P&C insurance including underwriting and claims.
• Excellent communication and documentation skills.

Responsibilities

• Design and deliver solutions meeting standards for availability and performance.
• Analyze business and functional requirements for insurance products.
• Collaborate with analysts, developers, and product owners.

Skills

ETL testing

SQL

P&C insurance

Test case design

Communication

Detail-oriented

Tools

JIRA

Selenium

Job description

Overview

Solving HR Challenges with Technology | IT Analyst

Direct message the job poster from TechDoQuest

Responsibilities

• Design and deliver solutions that meet Client’s standards for availability, security, resilience, and performance.
• Analyze business and functional requirements specific to P & C insurance products (e.g., personal auto, commercial auto, personal property, commercial property).
• Design and execute manual test cases for applications testing by coordinating with SMEs and developers.
• Strong SQL knowledge: essential for querying and validating data across different databases and systems. Experience with relational databases (Oracle, SQL Server, Postgres, etc.).
• Solid understanding of P&C insurance concepts including policy administration, claims processing, and underwriting.
• Perform functional, regression, integration, backend and UAT testing.
• Collaborate with business analysts, developers, and product owners to ensure test coverage and quality.
• Identify and document defects using tools like JIRA and work with development teams for resolution.
• Conduct API and backend testing (SQL) to validate data integrity and system integrations.
• Participate in Agile ceremonies and contribute to sprint planning and retrospectives.

Required Skills & Experience

• 3–6+ years of experience in ETL testing for Datawarehouse and Data mart applications.
• Strong domain knowledge of P &C insurance including underwriting, rating, billing, and claims.
• Experience with test case design, execution, and defect management.
• Proficiency in SQL for data validation and backend testing.
• Excellent communication and documentation skills.
• Ability to work independently and collaboratively in a fast-paced insurance environment.
• Detail-oriented with a proactive approach to identifying issues and improvements.

Qualifications

• Nice to have experience with automation frameworks (e.g., Selenium).
• 3+ years of ETL testing experience with ETL tools.
• Knowledge of state-specific P & C insurance regulations.
• Knowledge of CI/CD pipelines and Agile/Scrum methodologies.
• Experience with SQL tools like running queries.

Details

• Seniority level: Mid-Senior level
• Employment type: Full-time
• Industry: IT Services and IT Consulting