03/24/2025

Role: Software Developer - ETL RQ: RQ08687 Rate: $95/h inc Client: MTO Location: Hybrid, 87 Sir William Hearst Ave., Toronto, Ontario M3M 0B4 Duration: 252 business days, 7.25 hours per day Anticipated Start Date: April 2025 Description Deliverables section: Scope of Services and Deliverables - The Services and Deliverables to be provided by the Vendor will include the following: ·         Participate in the review of project, work request and maintenance release artefacts - Use Case, System Requirement Specification, etc. ·         Deliver detailed system design documents and any other supporting documentation conforming to Ministry standards. ·         Design logical and physical data models using Sybase Power Designer. ·         Produce transformation mapping document. ·         Implement data pipelines using Azure Data Factory (ADF), stored procedure, and Informatica PowerCenter performing extraction, transformation, and loading activities. ·         Implement solutions using Logic App and Function App. ·         Generate structured JSON file using ADF/ SQL. ·         Develop Azure CI/CD pipeline to automate ADF release. ·         Develop complex Oracle PL/SQL program to fulfill project requirements. ·         Implement complex data conversion, e.g., binary to character, EBCDIC to UTF. ·         Implement complex data transformation(s) for derived and calculated values. ·         Integrate data sets from diverse source systems. ·         Implement ADF for initial data load and incremental load. ·         Promote ADF and Informatica ETL/ELT through all Ministry environments including Development, Integration Testing, QA, UAT, Production. ·         Resolve and troubleshoot ADF pipeline, stored procedure, and Informatica workflow technical problems. ·         Monitor and analyze incident, provide timely resolution. ·         Collaborate with IT Professionals throughout the Software Development Life Cycle. ·         Document information from diverse business area stakeholders and subject matter experts. ·         Optimize performance of ADF pipeline, Azure SQL and Synapse databases, and Informatica workflow. ·         Monitor application functionality and performance on daily basis. ·         Provide effective knowledge transfer to Ministry staff at all stages of this assignment. Skills Experience and Skill Set Requirements Evaluation Table ETL Development-Data Integration                                                                              40% ·        Extensive experience in gathering requirements and business process knowledge in order to design correct and high-quality data transformation. ·        Extensive experience in design, development, and implementation with Azure Data Factory, Databricks, including: o  Self-Hosted Integration Runtime o  Data movement, ETL pipelines o  Performance tuning on large data volumes o  Complex data transformations o  ADF Debugger to validate data transformation. o  Azure Roles ·        Experience with Informatica, including: o  Workflow Manager o  Repository Manager o  Designer o  Workflow Monitor ·        Experience with developing solutions using Logic App and Function App. ·        Experience in rapid application development (RAD) methodologies. ·        Experience in maintaining and improving existing ETL processes. ·        Experience in investigating data to identify potential issues within ETL pipelines. ·        Experience with Business Intelligence tools IBM Cognos and Microsoft PowerBI. Azure Technologies                                                                                                      40% ·        Experience with CI/CD (DevOps) pipelines and concepts, including: o  Azure Resource Management o  GitHub Repo o  Source code version control o  Branching, pull requests, build, release, multiple parallel development repositories merge. ·        Experience with Azure DevOps, including: o  Azure Boards o  Azure Test Plans o  Azure Pipelines o  Azure Repos o  Azure Artefacts Oracle PL/SQL Development                                                                                      10% ·        Extensive experience in designing and developing SQL Server Stored Procedure, Oracle PL/SQL programs. Database Technologies                                                                                               10% ·        Experience with Oracle, Microsoft SQL Server database and tools. ·        Experience with relational and hierarchical database technologies. ·        Extensive knowledge of Azure SQL DB and Synapse platforms, including: o  Performance tuning on large data volume Candidate is required to come in office 3 days a week Must haves:  Extensive experience in gathering requirements and business process knowledge in order to design correct and high-quality data transformation.

03/17/2025

Role: Software Developer - Curam RQ: RQ08690 Rate: $105/h inc Client: Ministry of Public and Business Service Delivery and Procurement Location: Hybrid, 5700 Yonge Street, Toronto Duration: 248 business days, 7.25 hours per day Anticipated Start Date: April 2025 Description Responsibilities Required to translate technical systems specifications into working, tested applications. This includes: developing detailed programming specifications writing and/or generating code compiling data-driven programs, maintaining, Skills Experience and Skill Set Requirements Please note this role is part of a Hybrid Work Arrangement and resource(s) will be required to work at a minimum of 2-3 days per week at 5700 Yonge St. 7-10 years of experience as a Senior Technical Consultant in large (greater than 1000 users) businesses and I&IT transformation project(s). •      Hands-on experience with Curam •      Hands-on experience writing Java code and using integration technologies, ESB, Java/JEE, application and web server technologies •      Experience in large scale case management implementations •      Technical expertise to enhance, configure, customize and integrate case management system with external or related applications •      Experience in conducting requirements elicitation, fit-gap, design, and development phases in large Cúram or COTS implementations •      Ability to advise and provide technical recommendations on infrastructure, data conversion, reporting and interfaces Selection Criteria Section Percentage Criteria Application design and development experience 50 ·        Hands on experience in Curam Version 7 ·        Provide end to end solution design, development and unit testing along with recommendations to achieve business outcomes in alignment with business requirements, Cluster reference architecture and Ministry specific objectives ·        Collaborate with stakeholders to understand business goals and support delivery outcomes ·        Develop code following the SA development standards, architectural governance principles and design patterns in the development of end-to-end solutions ·        Experience in design and implementation of REST API integrations and best practices ·        Incorporate security requirements into the design, understand and comply with OPS security standards and policies Methodology, testing and troubleshooting 30 ·        Excellent analytical, problem-solving and decision-making skills; verbal and written communication skills; interpersonal and negotiation skills ·        Experience working in agile development environment ·        Ability to provide user and system documentation as required ·        Contribute to the effective management of risks and issues associated with Solution designs ·        Collaborate with cross-functional and distributed teams, including designers, developers, architects, project managers, and QA ·        Promotes industry standards and best practices with the product teams. ·        Perform thorough code reviews including unit tests and ensure high quality of the software. ·        Fix defects and support developers, testers and end users Planning, Documentation and communication 20 ·        Prepare work plans with CYSSC Managers, report and adjust completion status, report issues and risks in a timely manner ·        Write technical documentation that supports and thoroughly explains the architecture ·        Deliver knowledge transfer sessions to the team on the work completed Please note this role is part of a Hybrid Work Arrangement and resource(s) will be required to work at a minimum of 2-3 days per week at 5700 Yonge St. Must haves: 7-10 years of experience as a Senior Technical Consultant in large (greater than 1000 users) businesses and I&IT transformation project(s). •      Hands-on experience with Curam •      Hands-on experience writing Java code and using integration technologies, ESB, Java/JEE, application and web server technologies •      Experience in large scale case management implementations •      Technical expertise to enhance, configure, customize and integrate case management system with external or related applications •      Experience in conducting requirements elicitation, fit-gap, design, and development phases in large Cúram or COTS implementations •      Ability to advise and provide technical recommendations on infrastructure, data conversion, reporting and interfaces

03/17/2025

Role: Software Developer - Java RQ: RQ08352 Rate: $95/h inc Client: MTO Location: Hybrid, 87 Sir William Hearst Ave. Toronto, ON M3M 0B4 Duration: 252 business days, 7.25 hours per day Anticipated Start Date: April 2025 Description Deliverables -     Work with Business Analysts / UX & UI Designer / Product Manager / Cloud Architect, base on storyboard, user stories, UI/UX artefacts, solution architecture, security requirements, data models, develop application design and technical specification document, deliver quality software products (including Minimal Viable Products and Cloud-Native Web Application products, AODA compliance) as required. -     Create object-oriented models in UML as design artefacts using tools such as Power Designer. -     Support Quality Assurance & Defect Management, including Unit Test, Test Automation, Penetration / Vulnerability Test, Load Test, AODA Test, system / user test, migration test, etc. -     Construct / enhance / renew web applications using Cloud-Native / PaaS & Java EE application models (e.g. Microservice Architecture, API-based model, Responsive Web Design, Serverless Architecture, etc), and industry-leading Open Source frameworks like Angular, React / Redux, JSON, Node.js, Spring Framework / Spring Boot / Spring MVC, Lombok Annotations, in addition to Java 1.8+, JDK 11+, EJB, JSP, Servlets, JDBC, JPA, XML (DOM, SAX, XSLT), DHTML/HTML, Web Service, WebLogic (14+) / WebSphere / JBoss / TomCat / WildFly, relational, hierarchical and NoSQL databases -     Provide critical application support (incident investigation, troubleshooting, interim / long-term fixes, maintenance / incremental changes, etc) for complex production Java enterprise Applications -     Provide Method of Procedure (implementation package) document for production releases where required, and operational procedure document for production support staff as required. -     Co-ordinate system development activities and provide technical consultative support to other staff members. -     Provide knowledge transfer to ministry staff at all stages of this assignment. -     Provide post implementation support. Skill Set ·         10+ year knowledge of, and experience with the following computing environments: o    Databases: Oracle, SQL Server, PostgreSQL, DB2, IMS, etc, and SQL programming o    Operating System / Platforms: Unix (Solaris, AIX), Linux (e.g. RedHat), Windows (Server), container platforms / technologies (e.g. Docker), industry leading IaaS / PaaS Cloud platforms (e.g. Azure App Service) o    Web / Application Servers: WebLogic (14+), WebSphere, JBoss, TomCat, WildFly, Microsoft IIS, etc ·         15+ year experience with Object Oriented Analysis & Design (UML – Use Case/Class Sequence/ Collaboration/State) and 3+ year experience with Micro Service Architecture model ·         10+ year experience in developing web-based applications using JEE (Java 1.8+, JDK 11+,  EJB, JPA, JSP, Servlets, JDBC, JNDI), XML (DOM, SAX, XSLT), DHTML/HTML, Struts, JavaScript, Web Services, JUnit, Log4J, iTEXT, Jasper Reports, Jakarta Commons Beans Utilities / Collections framework, Apache Commons Logging, Spring Framework / Spring Boot / Spring MVC, JSON, etc ·         Secure web application under OWASP guideline and rules ·         3+ year experience in Angular, React / Redux, GraphQL, Node.js, Lombok Annotations, etc. ·         Good understanding and exposure (3+ years) of program & service concepts, general and best practices, business processes & rules, stakeholders & relationships, service delivery models (incl. self service / digital service), private & public partnership, etc in complex and high-impact public sector (e.g. transportation safety) related licensing, registration, permit, enforcement, safety inspection, photo identification and related fraud prevention line of businesses, services, or functional areas, in relation to I&IT application software delivery ·         Proven Experience (10+ years) with all stages of automated system implementation in large complex high volume heterogenous systems, with online Mainframe Transactions ·         Experience (15+ years) in structured methodologies for the development, design, implementation and maintenance of applications ·         3+ year experience and knowledge in Cloud-Native application design, Agile, DevOps Continuous Delivery / Continuous Integration methodologies / processes, integration of business rules engines (e.g. Oracle Process Automation OPA) ·         Demonstrable knowledge and experience (2+ years) working in accordance with policies and procedures of Public Sector Service in Canada. ·         Working experience with toolsets and open source software packages / frameworks that support object oriented languages, web application, and Cloud-Native product development including: o   Configuration / Builds:  Harvest (or similar), Ant, GitHub / GitLab, Maven (v3) build tools o   UML modeling tools, e.g. PowerDesigner o    Eclipse, Visual Studio o    Test Automation Framework / Tools, e.g. Selenium, JAWS, WAVE, Chrome AXE, NVDA, WC3 Validator ·         Excellent problem solving, communication (verbal and written), and interpersonal skills. ·         A team player with the ability to work with competing priorities and strict deadlines. ·         Proven ability to perform to successful completion assignments of high magnitude and complexity. Lead Evaluator John Song               Skills Experience and Skill Set Requirements Evaluation Criteria Technical Skills in Web-based Java EE (Enterprise Edition, 10+ years) / Cloud-Native PaaS (3+ years) application development -     Overall 10+ years’ work experience as a software developer on Java enterprise and Cloud-Native application analysis, design and development -     Strong (and recent) technical design, build / development, and quality assurance expertise in Java EE and Cloud-Native frameworks, standards, technologies and tools -     Working experience of developing Web-based Java EE and Cloud-Native applications using Java 1.8+, JDK 11+, EJB, JPA, JSP, Servlets, JDBS, JNDI, XML, DOM, SAX, and XSLT, DHTML/HTML, Struts, Node.js, JSON, Spring Framework / Spring Boot / Spring MVC, JavaScript, Web Services, JUnit, Log4J, iTEXT, Jasper Reports, Jakarta Commons Beans Utilities / Collections framework, Apache Commons Logging, etc -     Solution design and development experience for Cloud-Native PaaS based technologies -     Secure web application development under OWASP guideline and rules 30 Computing Environments and Toolsets (10+ years) Knowledge of, and experienced with the following computing environments: -     Database: Oracle, SQL Server, PostgreSQL, DB2, IMS, etc, and SQL programming -     Operating Systems / Cloud Platforms: UNIX (Solaris, AIX), Linux (e.g. RedHat), Windows (Server), container platforms / technologies (e.g. Docker), industry leading IaaS / PaaS Cloud platforms (e.g. Azure App Service) -     Web / Application Servers: WebLogic (14+), WebSphere, JBoss, TomCat -     Working experience with toolsets / frameworks that support object oriented languages, web application, and Cloud-Native product development including: o  Configuration / Builds:  Harvest (or similar), Ant, GitHub / GitLab, Maven (v3) build tools o  UML modeling tools, e.g. PowerDesigner o  Eclipse, Visual Studio o  Test Automation Framework / Tools, e.g. Selenium, JAWS, WAVE, Chrome AXE, NVDA, WC3 Validator 20 User Interface Design / Development (3+ years) Familiar with UX / UI design principles and guidelines, familiar with Angular, React / Redux, and AODA compliance 15 Subject Matter Knowledge and Expertise (3+ years) in related Business Programs, Services, and Processes Good understanding of program & service concepts, general and best practices, business processes & rules, stakeholders & relationships, service delivery models (incl. self service / digital service), private & public partnership, etc in complex and high-impact public sector (e.g. transportation safety) related licensing, registration, permit, enforcement, safety inspection, photo identification and related fraud prevention line of businesses, services, or functional areas, in relation to I&IT application software delivery 5 Object-Oriented Analysis & Design (15+ years) and complex & modern application system implementation / delivery -     Experience with Object Oriented Analysis & Design (UML – Use Case/Class sequence/Collaboration/State) and Micro Service Architecture model -     Experience with all stages of automated system implementation in large complex high volume heterogenous systems, with online Mainframe Transactions -     Knowledge in Cloud-Native application design, Agile, DevOps Continuous Delivery / Continuous Integration methodologies / processes, integration of business rules engines -     Experience in structured methodologies for the development, design, implementation and maintenance of applications. 15 Public Sector Experience (2+ years) -     Experience with Public Sector I&IT Solutions architecture, application design / development (& secure programming) / quality assurance standards, solution / project delivery methodologies, and practices -     Demonstrable knowledge and experience in working in accordance with policies and procedures of Canadian Public Sector Services 5 Interpersonal & Communication Skills -     A team player with the ability to work with competing priorities and strict deadlines. -     Strong problem-solving and decision-making skills; verbal and written communications skills; interpersonal and negotiation skill 10 The candidate is required to come in office 3-days a week Must Haves Overall 10+ years’ work experience as a software developer on Java enterprise and Cloud-Native application analysis, design, and development

01/15/2025

Role: DevOPS/Cloud Engineer RQ: RQ08364 Rate: $100/h inc Client: Ministry of Transportation Location: Hybrid, 87 Sir William Hearst Ave., Toronto, Ontario M3M 0B4 Duration: 252 business days, 7.25 hours per day Anticipated Start Date: April 2025 Title DevOPS/Cloud Engineer Description Deliverables/Skill Set Requirements Deliverables Task 1 ·         Monthly Performance Status Report (where applicable) Deliverables ·         All deliverables that consultant worked on during past month are included ·         Progress and specific accomplishment against the deliverable are described ·         Status of consultant’s deliverable compared to the project Baseline Estimated Completion Date ·         Monthly Task 2 ·         Review Technical Design ·         Revise Technical Design Based on Review ·         Develop automation scripts based on technical design ·         Implement & Promote to User Test environment ·         Implement & Promote Production environment ·         Document for Knowledge transfer ·         Provide support to the development of integration and data migration requirements ·         Provide support to the Q&A phase of the project ·         Provide stabilization support post the project go-live Deliverables Estimated Completion Date ·         According to the project timeline schedule Task 3 ·         Knowledge transfer to ministry staff Deliverables ·         Documentations ·         Walk-through sessions Estimated Completion Date ·         Throughout the project Skill Set ·         Minimum 10 years of experience in WebLogic V12, WebSphere V9, Informatica V10 configuration, customization, upgrading ·         Minimum 5 years of experience in DevOps toolsets in Azure Cloud, including but not limited to, Docker, Ansible, Packer, Terraform, Azure DevOps Pipelines, OpenShift. ·         Working knowledge and experience in git, including branching and merging strategies (e.g. git-flow), collaborating via pull request and practicing GitOps ·         Working knowledge and experience of designing and implementing infrastructure as code build automation using Terraform and immutable infrastructure with Ansible and Packer ·         Minimum 10 years of experience in systems, data communications and telecommunication technology including experience with RedHat Enterprise Linux V7+, UNIX Solaris V10 and Mainframe IMS Connect, system software and System tools ·         Working knowledge and experience of implementing instances/applications performance tuning, storage/capacity management, DB migration/upgrade, Backup/Disaster Recovery (DR) strategies ·         Working knowledge and experience of clustering Load Balancers, and Firewall configuration and accomplishing the same in Azure cloud ·         Experience with technologies (J2EE, Java) and web technologies (Node.js, Azure Functions, Serverless, Pub/Sub event driven systems, Azure App Gateway) ·         Experience with Informatics Power Centre tools, Designer, Workflow Manager, Workflow ·         Experience on application monitoring and support ·         Highly skilled analysis and problem-solving skills Lead Evaluator     Skills Experience and Skill Set Requirements Evaluation Criteria Technical Knowledge – 30% ·        10+ years of experience in systems, data communications and telecommunication technology including experience with RedHat Enterprise Linux V7+, UNIX Solaris V10 and Mainframe IMS Connect, system software and System tools ·        Extensive experience in WebLogic V12, WebSphere V9, Informatica V10 configuration, customization, upgrading, and patching ·        Extensive experience in DevOps toolsets in Azure Cloud, including but not limited to, Docker, Ansible, Packer, Terraform, Azure DevOps Pipelines, OpenShift ·        Working knowledge and experience in git, including branching and merging strategies (e.g. git-flow), collaborating via pull request and practicing GitOps ·        Working knowledge and experience of designing and implementing infrastructure as code build automation using Terraform and immutable infrastructure with Ansible and Packer ·        Working knowledge and experience of implementing instances/applications performance tuning, storage/capacity management, DB migration/upgrade, Backup/Disaster Recovery (DR) strategies ·        Working knowledge and experience of clustering Load Balancers, and Firewall configuration and accomplishing the same in Azure cloud ·        Experience with technologies (J2EE, Java) and web technologies (Node.js, Azure Functions, Serverless, Pub/Sub event driven systems, Azure App Gateway) ·        Mid-Tier refresh initiatives experience with technologies (Docker, Ansible, Packer, Terraform) in Azure cloud environment Support & Troubleshooting – 25% ·        High skilled problem solving, reasoning and trouble-shooting experience to provide advice and resolve data recovery issues in a multi-platform environment ·        Support for pre-production and production systems on 7/24/365 basis for application and middleware ·        Experience conducting system monitoring and performance and data integrity in accordance with ITIL standards Operations – 25% ·        Experience on supporting enterprise business and infrastructure projects ·        Experience in Incident Management, Change Management Ability to perform performance analysis ·        Experience in resource usage tracking, analysis ·        Ability to perform log searches for problem solving, audit and performance checking ·        Experience in emergency problem resolution ·        Ability to provide ad-hoc reporting Interpersonal & Communication Skills – 15% ·        Strong oral and written communications and interpersonal skills with experience making presentation, liaising with staff to resolve issues, and working as part of a technical multi-disciplinary team ·        Based on management's request, the ability to provide support to internal and external clients on a 7/24 basis ·        Experience in coordinating and providing leadership to staff and stakeholders Public Sector Experience – 5% ·        Working knowledge of Transportation Safety architecture, applications, databases, and systems Hybrid: 3 days onsite / 2 days remote Must Haves: ·        10+ years of experience in systems, data communications and telecommunication technology including experience with RedHat Enterprise Linux V7+, UNIX Solaris V10 and Mainframe IMS Connect, system software and System tools ·        Extensive experience in WebLogic V12, WebSphere V9, Informatica V10 configuration, customization, upgrading, and patching ·        Extensive experience in DevOps toolsets in Azure Cloud, including but not limited to, Docker, Ansible, Packer, Terraform, Azure DevOps Pipelines, OpenShift

01/14/2025

Role: Systems Testing/QA Specialist RQ: RQ08021 Rate: $75/h inc Client: Ministry of Public and Business Service Delivery (former MGCS) Location: Hybrid, 222 Jarvis, Toronto Duration: 289 business days, 7.25 hours per day Anticipated Start Date: February 2025 Description We are seeking a QA Tester with expertise in structured testing methodologies, government compliance, and Accessibility for Ontarians with Disabilities Act (AODA) standards. This role requires a deep understanding of testing processes, strong analytical skills, and experience conducting functional, non-functional, integration, and user acceptance testing (UAT). The ideal candidate will have 5+ years of experience in testing, ensuring software meets stringent public sector quality and accessibility standards. Key Responsibilities: Testing and Test Strategy Development: Develop and execute test plans, test scripts, and test cases aligned with business and technical requirements. Conduct detailed testing, including functional, regression, system integration, and user acceptance testing (UAT). Identify, log, and track defects using tools like Jira, ensuring accurate documentation and resolution. Perform exploratory testing for edge cases and scenarios outside regular workflows. Accessibility and Government Compliance Testing: Test for accessibility compliance (AODA and WCAG 2.1) across all applications. Validate systems against public sector policies, ITIL processes, and security/privacy standards. Data and Systems Validation: Create database queries to verify test data and ensure data integrity. Test system configurations, integrations, and interfaces to validate end-to-end workflows. Test Documentation and Reporting: Maintain detailed documentation, including test cases, traceability matrices, test results, and defect logs. Prepare and deliver testing progress updates and reports to stakeholders and project teams. Collaboration and Knowledge Sharing: Work closely with cross-functional teams, including developers, business analysts, and project leads, to clarify requirements and resolve issues. Provide cross-training to team members on testing tools and techniques as needed. Key Deliverables: Test Plans and Test Cases: Comprehensive test plans and cases based on business and functional requirements. Defect Reports: Clear and concise documentation of all identified issues, including steps to reproduce and impact analysis. Accessibility Compliance Validation: Testing reports detailing compliance with AODA and WCAG 2.1 standards. Testing Summary Reports: Periodic updates and final testing summaries that highlight progress, defect resolution, and overall quality status. Traceability Matrices: Documentation linking test cases to requirements to ensure comprehensive coverage. Collaboration Logs: Record of discussions and clarifications with stakeholders to support testing accuracy and alignment with project goals. Skills Experience and Skill Set Requirements Experience: Testing Expertise: 5+ years of experience in testing across various testing types (functional, non-functional, UAT). Strong knowledge of Software Testing Life Cycle (STLC) and Systems Development Life Cycle (SDLC). Public Sector Compliance: Proven experience in AODA compliance testing and WCAG 2.1 standards. Familiarity with ITIL processes and public sector testing requirements. Defect Management: Experience using tools like Jira to track and manage defects. Ability to conduct root cause analysis and verify bug resolutions. Skills: Strong knowledge of testing methodologies, including risk-based and exploratory testing. Ability to create detailed test plans, test cases, and reports. Proficiency with collaboration tools (e.g., Microsoft Teams, Confluence). Excellent communication and problem-solving skills to work effectively with stakeholders. Desirable Skills: Experience working in Agile/Scrum environments. Familiarity with database testing and writing SQL queries for data validation. Knowledge of performance and load testing techniques. Hybrid: 3 days onsite / 2 days remote Must Haves: 5+ years of experience in testing across various testing types (functional, non-functional, UAT). Ability to create detailed test plans, test cases, and reports. Proven experience in AODA compliance testing and WCAG 2.1 standards. Experience using tools like Jira to track and manage defects.