Job Title: Data Test Engineer

Job Summary:

We are seeking a skilled Data Test Engineer with strong technical capabilities and a deep understanding of ETL development. The ideal candidate will have experience in coding languages such as Python, SQL, and XML, along with expertise in data warehousing concepts and architecture techniques. This role requires extensive troubleshooting skills to solve complex technical issues in ETL processes. Proficiency in data warehousing methods like Operational Data Store (ODS), Data Marts (DM), Enterprise Data Warehouse (EDW), and Relational OLAP (ROLAP) is essential.

Top 4 Required Skills:

1. AWS (S3)
2. Hadoop
3. PostgreSQL
4. Informatica BDM & Power Center

Key Responsibilities:

• Quality Assurance Experience: Utilize 5+ years of software quality assurance experience on enterprise-level applications, specifically in data warehouse testing.
• SQL Expertise: Write complex SQL queries to support various testing needs such as data validation and regression, assess testability of requirements, and develop comprehensive test plans for business and technological solutions.
• Testing Phases: Test across multiple project phases, especially in medium to large-scale projects, ensuring data integrity through validation.
• Data Governance Knowledge: Apply principles of information governance in a testing context.
• Data Warehousing and Data Mart Testing: Execute testing for data warehouses and data marts with clear understanding.
• Test Data Preparation: Identify test data preparation techniques and transform complex business logic into SQL or PL/SQL queries.
• Testing Lifecycle Proficiency: Maintain thorough knowledge of Software Test Life Cycle, Test Case Life Cycle, Defect Life Cycle, and requirements traceability.
• Test Case Management: Prepare, execute, and track test cases; ensure requirements are accurately traced with RTM.
• Automation and Tools: Leverage QA automation tools with Python for test automation.
• ETL Testing: Conduct ETL testing with extensive SQL proficiency, handling large data sets within a Data Quality Framework.
• Data Analysis and Profiling: Perform data analysis, including profiling, auditing, balancing, and reconciliation.
• Defect Tracking and Resolution: Use tools such as Jira and ALM for tracking and managing defects.
• SQL Tuning: Enhance SQL performance through optimization of queries, stored procedures, and views.
• Attention to Detail: Bring an analytical mindset, focusing on detail-oriented testing and analysis.
• Data Modeling Knowledge: Understand data models and entity-relationship diagrams for effective testing.

Technical Requirements:

• Cloud and Data Lake Expertise: Experience with Snowflake, AWS S3, Hadoop Data Lake, PostgreSQL, MongoDB, and other cloud technologies.
• ETL Tools Proficiency: Skilled in Informatica PowerCenter and Informatica BDM for ETL processes.
• Data Integration and Analytics: Experience in data extraction, transformation, and loading from various data repositories (structured and semi-structured).
• Data Modeling and Design: Knowledge in designing data marts and data warehouses following data modeling principles.
• Problem Solving: Strong analytical skills to address complex issues efficiently.
• Independent and Collaborative Work Style: Self-motivated with the ability to work independently and as part of a team, with a commitment to delivering high-quality service.
• Mentorship and Learning: Quick learner who is willing to guide team members and foster a knowledge-sharing environment.

Preferred Qualifications:

• Experience with Large Data Sets: Familiarity with data quality frameworks, data cleansing, and data analysis methods.
• Adaptability and Multitasking Skills: Ability to handle multiple tasks in a dynamic environment, responding to changes with urgency and flexibility.

Attributes:

• Ownership: A proactive self-starter who takes initiative, ownership, and responsibility for tasks.
• Team Player: Works collaboratively within a team environment and strives to achieve high-quality results.

Job Description: Database Administrator

Position Overview:

We are seeking a highly skilled and experienced Database Administrator (DBA) to join our dynamic IT team. The ideal candidate will have extensive knowledge and hands-on experience with Oracle Databases (12c and 19c), as well as proficiency in other database systems such as PostgreSQL or MongoDB. Knowledge of AWS is a plus. The DBA will be responsible for database application support, troubleshooting, patching, performance tuning, and query optimization. Additionally, expertise in Oracle Enterprise Manager is essential.

Key Responsibilities:

• Database Management:
  • Install, configure, and maintain Oracle Databases (12c and 19c).
  • Manage database instances, including creation, configuration, and monitoring.
  • Ensure high availability, disaster recovery, and data integrity.
• Database Application Support:
  • Provide support for database applications, ensuring optimal performance and reliability.
  • Collaborate with development teams to design and implement database solutions.
  • Troubleshoot and resolve database-related issues promptly.
• Performance Tuning:
  • Perform system and query tuning to optimize database performance.
  • Analyze and resolve performance bottlenecks.
  • Implement best practices for database performance and scalability.
• Patching and Upgrades:
  • Apply patches and perform upgrades to database systems.
  • Ensure compliance with security policies and standards.
  • Plan and execute database migrations and version upgrades.
• Monitoring and Maintenance:
  • Utilize Oracle Enterprise Manager for database monitoring and management.
  • Conduct regular health checks and performance assessments.
  • Automate routine maintenance tasks to improve efficiency.
• Cross-Platform Database Support:
  • Provide support for additional database systems such as PostgreSQL or MongoDB.
  • Ensure seamless integration and interoperability between different database platforms.
  • Maintain documentation and standard operating procedures for multi-database environments.
• AWS Knowledge (Preferred):
  • Leverage AWS services for database hosting and management.
  • Implement cloud-based database solutions and ensure their optimal performance.
  • Stay updated with the latest AWS offerings and best practices.

Qualifications:

• Bachelor’s degree in Computer Science, Information Technology, or a related field.
• 5 to 7 years of proven experience as a Database Administrator with a focus on Oracle Databases (12c and 19c).
• Proficiency in Oracle Enterprise Manager.
• Working knowledge of PostgreSQL or MongoDB.
• Familiarity with AWS services is a plus.
• Strong analytical and problem-solving skills.
• Excellent communication and teamwork abilities.
• Ability to work in a fast-paced, dynamic environment.

Preferred Skills:

• Certification in Oracle Database Administration.
• Experience with database security and compliance.
• Knowledge of scripting languages (e.g., Python, Shell scripting) for automation.
• Familiarity with DevOps practices and tools.

Perform assigned responsibilities, collaborate with team members, and adhere to company policies. Strong communication, problem-solving, and work ethic required. Adaptability, initiative, and willingness to learn are valued.

Perform assigned responsibilities, collaborate with team members, and adhere to company policies. Strong communication, problem-solving, and work ethic required. Adaptability, initiative, and willingness to learn are valued.

We have a fantastic opportunity for an Agile Delivery Specialist to join the IT team. Change delivery uses the most appropriate delivery model, including Agile Scrum, Kanban, and XP, with both formal and informal scaling approaches for large and/or complex change. Agile and DevOps are core to our operational strategy, with strong alignment to Systems Thinking and other modern, adaptive, and team-centric approaches to delivery and operations.

The Agile Delivery Specialist role supports the adoption and adherence to these approaches, developing and continuously improving Agile capability and maturity within the team. The primary purpose of the Agile Delivery Specialist is to ensure teams drive change delivery effectively, with a focus on quality, innovation, and value optimization aligned with Agile values and principles.

This is a facilitative servant leadership role. The Agile Delivery Specialist promotes self-organization within the team and drives increasing levels of software engineering maturity, such as DevOps. They work to clear the path for the team, remove blockers, facilitate discussions, enable seamless communication, and collaborate with the Technology Platform Lead and Product Owner to clarify the Product Backlog.

Duties & Responsibilities

• Guide the Team: Foster adherence to Agile values and principles, applying appropriate frameworks and techniques to create an environment of self-organization.
• Teach and Coach: Provide Agile theory and software engineering technique coaching for the team and organization.
• Support Product Owners: Assist Product Owners, particularly in refining and maintaining a product backlog.
• Enhance Communication: Facilitate internal and external communication, improving transparency, and sharing information on team activities.
• Collect and Communicate Metrics: Gather necessary metrics and propose new ones to support continuous improvement.
• Drive Quality Across Change Delivery: Optimize change across the technology platform, ensuring quality throughout the delivery lifecycle and minimizing defects.
• Perform Capability Gap Analysis: Conduct a gap analysis for overall technology platform capabilities and tools, developing a roadmap for improvement.
• Support Value Stream Mapping: Collaborate with Agile Delivery Lead on value stream mapping efforts.

Skills & Experience Required

• Agile Knowledge: Strong understanding of Agile values, principles, and a range of Agile frameworks.
• Industry Knowledge: Familiarity with the insurance business is an asset.
• Stakeholder Management: Effective communication skills and an ability to inspire change within individuals and teams.
• Technical Proficiency: Knowledge of Agile techniques and software development processes, such as Test Automation, Continuous Integration, Pairing, DevOps, Refactoring, ATDD/TDD/BDD, Extreme Programming (XP), and Value Stream Mapping.
• Self-Motivation: Demonstrated ability to learn and explore new ideas independently.

Qualifications

• Professional Certification (minimum PSM1 or equivalent).

Job Description: Test Architect / Lead Software Development Engineer in Test (SDET)

Location: Markham (3 days in office, flexible for 1 day in Toronto)

Start Date: Early January

Employment Type: Contract (12 Months)

Position Overview

We are seeking an experienced and visionary Test Architect / Lead SDET to join our dynamic team. This role is instrumental in driving the modernization of testing practices, embedding quality into the software development lifecycle, and fostering a culture of excellence. You will lead by example, mentoring developers and testers, and championing cutting-edge testing strategies that align with our mission to deliver reliable, scalable, and innovative digital applications.

Key Responsibilities

Modernizing Testing Practices

• Lead the transition from external test automation to engineering-embedded testing practices.
• Integrate testing into CI/CD pipelines to enable iterative, fast, and reliable releases.
• Advocate for rapid feedback and experimentation by shifting testing practices to smaller, incremental stages.

Engineering-Focused Testing

• Collaborate with developers to write scalable and maintainable unit tests.
• Coach developers on writing testable, high-quality code.
• Partner with testers to enhance alternative testing strategies and improve code testability.

Test Framework and Tool Selection

• Evaluate current tools like Selenium and assess modern alternatives such as Playwright or Cypress.
• Define and implement best practices for integration and UI testing while minimizing reliance on UI tests.
• Build robust testing frameworks using Java (SpringBoot) and TypeScript (Angular Framework).

Leadership and Coaching

• Influence and shape the testing strategies across digital engineering teams.
• Mentor developers and testers on automation, test-driven development (TDD), and modern testing methodologies.
• Establish a roadmap for sustainable, forward-thinking testing practices in a product-centric delivery model.

Collaboration and Stakeholder Engagement

• Collaborate with engineering leads to design scalable test architectures.
• Align integration testing strategies with teams working on backend systems like Guidewire.
• Serve as a thought leader, providing strategic guidance on testing practices to technical and business stakeholders.

Qualifications

Technical Expertise

• Strong expertise in test automation frameworks and tools, including Selenium, Playwright, Cypress, and Appium.
• Proficient in programming languages such as Java (SpringBoot) and TypeScript (Angular Framework).
• Deep understanding of CI/CD pipelines and embedding tests within development workflows.
• Hands-on experience writing scalable and reliable unit and integration tests.

Leadership and Vision

• Proven experience in designing and implementing modern test practices.
• Ability to coach cross-functional teams, including developers and testers, in adopting best practices.
• Strong capability to define test strategies, set roadmaps, and lead organizational change in testing methodologies.

Collaboration and Communication

• Exceptional communication skills with the ability to collaborate with cross-functional teams and influence stakeholders.
• Experience working with engineering leads and technical teams to align on testing goals.

Experience

• At least 8-10 years in test automation and test architecture, with a focus on digital applications.
• Experience in enterprise-level organizations; exposure to industries like telecom or insurance is a plus.

Preferred Skills

• Familiarity with performance and load testing tools (e.g., JMeter, LoadRunner).
• Experience with declarative CI/CD pipelines (e.g., Azure DevOps, GitLab CI).
• Knowledge of cloud platforms (e.g., AWS, Azure) and containerization tools (e.g., Docker, Kubernetes).

Why Join Us?

• Opportunity to work in a hybrid environment with flexibility across locations.
• Lead and shape the testing architecture of cutting-edge digital products.
• Collaborate with a passionate and skilled engineering team dedicated to innovation.
• Competitive compensation and professional growth opportunities.

Application Process

• Submit your resume and cover letter highlighting relevant experience and leadership achievements.
• Interview Rounds:
  1. Hiring Manager Interview.
  2. Technical Team Interview.

Let’s innovate and redefine testing practices together! Apply today to be part of our transformative journey.

Job Title: Guidewire ClaimCenter Developer

We are seeking a collaborative and skilled Technical Lead – Guidewire ClaimCenter. As a key part of the Software Engineering Group, you will work closely with globally distributed teams, including business representatives, analysts, architects, and engineers, to plan, design, develop, test, and implement solutions. Our team thrives in a culture that challenges the status quo, constantly seeking ways to simplify processes, technology, and workflows.

In this role, you will lead the design and implementation of Guidewire ClaimCenter solutions, driving our claims transformation agenda. You’ll play a vital role in enhancing claims processing efficiency, reducing costs, and improving customer satisfaction.

This position reports to the AVP of Software Engineering.

Key Responsibilities

• Develop architectural diagrams and design documents.
• Write, configure, package, and deploy software applications.
• Perform peer code reviews and ensure adherence to best practices.
• Collaborate with business stakeholders to translate requirements into technical solutions.
• Design and implement ClaimCenter configurations and integrations with external systems.
• Provide technical guidance and mentorship, fostering a culture of continuous improvement.
• Oversee technical aspects of ClaimCenter upgrades and patches.
• Troubleshoot and resolve complex technical issues promptly.
• Monitor system performance and recommend enhancements.

Required Qualifications

• Bachelor’s degree (or higher) in Computer Science, Computer Engineering, or a related field, or equivalent experience.
• 5+ years of experience in Guidewire ClaimCenter application development.
• Expertise in GOSU language, Guidewire tools, Guidewire Batch, and predefined plugins.
• Ability to read code in various languages and reverse-engineer products.
• Proficiency in Agile software development tools, including Git, Bitbucket, Jenkins, Jira, and Confluence.
• Domain knowledge in Property & Casualty Insurance.
• Guidewire Cloud Associate Certification required.
• 5+ years of Guidewire development experience.
• 5+ years of experience with RESTful API coding.
• 5+ years of experience coding in multiple programming languages such as C#, Java, and Python.
• 5+ years of experience with relational databases and SQL, with a preference for MS SQL Server & Transact SQL proficiency.
• Expertise in end-to-end design and development of business database applications.
• Experience in creating modern web applications and designing Web APIs with REST/JSON.
• Strong understanding of design thinking and customer-centric development.

This role offers the opportunity to make a significant impact on claims processing efficiency and customer satisfaction through innovative Guidewire ClaimCenter solutions.

Job Description: Finance Systems - Data Engineer Associate

Location: Markham, ON

Work Mode: Hybrid (3 days onsite)

Job Type: Contract

Eligibility: Canadian Citizen, PR Holder, or Valid Canadian Work Permit

Overview

We are seeking a skilled Finance Systems - Data Engineer Associate to design, develop, and optimize ETL processes for our finance systems. The ideal candidate will have strong expertise in PostgreSQL, ETL development (Informatica), and experience in the insurance industry, particularly with Guidewire systems. The role requires a collaborative mindset and an ability to ensure data accuracy and integrity across finance and insurance operations.

Top Required Skills:

1. Strong expertise in PostgreSQL and database design, particularly for finance systems.
2. Proven ETL development experience with Informatica PowerCenter and BDM.
3. Experience with Guidewire Policy, Billing, and Claims Centers.

Key Responsibilities

1. ETL Development & Optimization:
   • Design, develop, and maintain ETL processes to extract, transform, and load data into finance systems.
   • Optimize complex SQL queries and stored procedures in PostgreSQL.
   • Monitor daily/monthly ETL jobs and resolve failures.
2. Collaboration:
   • Work with finance and insurance teams to gather data requirements and ensure data accuracy.
   • Collaborate with teams using Guidewire applications to meet data requirements and maintain system integrity.
3. Financial Reporting & Analysis:
   • Build Qlik reports and implement financial calculations using PostgreSQL stored procedures or ETL tools.
   • Perform data analysis and troubleshooting for data-related issues.
   • Create financial reports and execute calculations in Corporate Reporting Engine (CRE) and Accounting Engine (AE).
4. Data Management & Quality Assurance:
   • Implement data quality checks and validation processes.
   • Monitor and improve the performance of ETL processes and database systems.
   • Maintain comprehensive documentation for technical specifications, ETL processes, and database schemas.
5. Guidewire Data Integration:
   • Extract and integrate data from Guidewire BillingCenter, PolicyCenter, and ClaimsCenter for financial reporting and analysis.
   • Utilize Guidewire data for tracking receivables, revenue recognition, and claims reserves.
6. Technology Leadership:
   • Stay updated with industry trends and best practices in ETL, data warehousing, and database management.
   • Leverage automation tools like Control-M and ASG Zena to streamline processes.

Requirements

1. Technical Skills:
   • Expertise in PostgreSQL development and database design.
   • Proficiency in ETL tools, particularly Informatica PowerCenter and Informatica BDM.
   • Knowledge of Oracle Fusion applications, including Accounts Payable, Cash Management, and Fixed Assets.
   • Experience with Guidewire PolicyCenter, BillingCenter, and ClaimsCenter.
   • Familiarity with automation tools (e.g., Control-M, ASG Zena) and Unix scripting.
   • Experience in data visualization tools like Qlik and Python reporting.
   • Familiarity with Snowflake and cloud-based data solutions.
2. Industry Experience:
   • Background in the insurance industry with knowledge of underwriting data terminology.
   • Experience supporting finance systems and understanding accounting principles (e.g., Balance Sheet, P&L).
3. Methodologies & Tools:
   • Agile methodology and JIRA experience.
   • Solid understanding of data warehousing concepts and best practices.
4. Soft Skills:
   • Excellent problem-solving skills and attention to detail.
   • Strong communication and collaboration abilities.
   • Capability to work independently and in team environments.

Preferred Qualifications

• Bachelor’s degree in Computer Science, Information Technology, or a related field.
• Certifications in Informatica (ICP, IDMC, CDCG, MDM) and SQL (Associate level).
• Guidewire professional certifications.
• Familiarity with Power BI for data visualization.

We encourage you to apply if you meet the requirements and want to contribute to a dynamic finance and insurance environment.

Job description

Job Title: IT QA - GW Automation Tester

Job Overview:

We are seeking a collaborative, inquisitive, and dedicated Automation Test Engineer to join our team. The ideal candidate will play a key role in crafting and improving automation frameworks, tools, and quality engineering processes. You will be responsible for contributing to technology, productivity, and operational efficiency improvements, as well as ensuring high-quality standards and IT controls are met.

Key Responsibilities:

• Design and improve automation frameworks, tools, and QE delivery processes.
• Lead initiatives to enhance technology, productivity, and operational efficiency.
• Review user stories, requirements, and technical design documents to provide timely feedback and recommendations from a Quality Assurance perspective.
• Create comprehensive test strategies, test plans, and estimates. Lead test execution and provide status updates to project teams.
• Build and maintain risk-based automation regression test suites and application component breakdown diagrams.
• Coordinate and ensure all quality engineering and documentation meet established QE standards and IT controls.
• Create and deliver test artifact communications, collaborating effectively with both technical and non-technical teams.
• Provide mentoring and training to junior team members.
• Ensure all deliverables meet quality requirements and timelines.

Skills and Experience:

Must have:

• Extensive experience with GuideWire PolicyCenter, BillingCenter, Documents, and Digital Applications.
• Current GuideWire Certification.
• 5+ years of hands-on experience in software automation testing, with 3+ years in API automation and manual testing.
• Strong expertise in Web Automation Testing using Selenium (Java/Python/C/C++) and framework development.
• Experience with API Automation Testing using XML/JSON, SOAP API, REST API, Java, and API framework development.
• Proficient with GIT/Bitbucket for source code management and CI/CD pipelines.
• Experience with JIRA integration and a solid understanding of SQL.
• Experience in the Canadian Personal and/or Commercial Insurance industry.
• Excellent verbal and written communication skills, with the ability to describe complex processes clearly.
• Strong problem-solving skills, capable of managing issues from start to resolution.
• Team player, contributing to a positive team culture.

Nice to have:

• Experience with Digital Test Automation, Cross Browser, Mobile, and Localization.
• Familiarity with Cucumber for automation.
• Previous development experience is an asset.

Qualifications:

• Bachelor's degree in Computer Science, Computer Engineering, or IT.
• 5+ years of experience in Software Development and/or Quality Assurance.
• Test Engineering Certification (e.g., ISTQB Certified) is required