Job DescriptionTitle: Senior Systems Analyst (RQ09620)Location: Toronto, ON M5B 2H7 (Hybrid)ContractOrganization: Government Services Integration ClusterMinistry: Ministry of Public and Business Service Delivery and ProcurementSkillsExperience and Skill Set RequirementsHave excellent knowledge of OO Systems Analysis & DesignExpert knowledge designing and implementing Java/JEE, HTML5, CSS, Javascript, Angular based enterprise solutions.Experience designing solution with cloud platforms such as AWS, Azure or Google Cloud Platform;Knowledge of all cloud service models: SaaS, PaaS, and IaaSExperience performing S&D for Case Management, Document Management System (DMS), Large Systems of RecordProficiency in Security solutions including oAuth2, SAML, Multifactor Factor Authentication (MFA), B2C and B2B Authentication, API Keys, Single Sign On (SSO), Assure AD.Experience designing solution components including web and business logic modules, Micro Services, Business ReportsExperience Analyzing/Designing Systems integration solutions including Session EJB, SOAP WS, RESTFul Web Services, SFTP server integrations.Experience performing Solution Gap Analysis, ETL Data transformation requirements, and Data Migration Plans.Have excellent DBA experience with database modeling including Conceptual, Logical, and Physical data models. Have extensive hands-on experience developing DB objects in Oracle, including Tables, Views, Sequences, Triggers, Store Procedures.Excellent practical experience writing and executing SQL queries analyzingExpert knowledge in reverse engineering Physical Data Models creating EntityRelationship Models (ERD) and Metadata ReportsExperience with Performance metrics for a DATABASE using Apache JMETER and other Load Testing toolsIn-depth knowledge of Web Design principlesSound understanding and experience with AODA and knowledge of Accessibility compliance principles as presented in WCAG 2.0Hands-on experience in Quality Assurance preparing Test Plans, Test Cases and executing and monitoring unit, integration and UAT testing while working directly with clientsProven experience with JAD facilitation and interpretation of business needs into system design requirements.Extensive experience within all project cycles from Analysis, Design to Development,Testing and Implementation, including Project Management assignmentsAbility to participate in the TRA process and prepare appropriate documentsProvide guidance to developers in the initial phases on the implementation of a solution.Experience with Figma, Balsamiq and other mock-up design toolsExperience developing architecture artifacts including: Solution Requirements Document (SRD), Business Architecture Document (BAD), Information Architecture Document (IAD), Solution Architecture Document (SAD), Architecture review presentations; Prepare presentations for Corporate Architecture CommitteesExpertise developing Technology Options Analysis including qualitative and quantitative analysis.Perform other project related activities as requiredWork independently and is also a Team playerExcellent analytical and problem solving skillsExcellent communication skills in both oral and writtenExperience in preparing technical presentationsConsultant may be asked to work on additional projects/assignmentsDesirable Skills:Systems Analysis Experience - 40%10+ years of System Analysis and Design experience, preferably in a large, complex business environmentExpert knowledge in reverse engineering Physical Data Models creating EntityRelationship Models (ERD) and Metadata ReportsDemonstrated experience within all project cycles from Analysis, Design toDevelopment, Testing and ImplementationKnowledge and experience related to TRA (Threat, Risk, Assessment) process and prepare appropriate documentsExperience preparing architecture artifacts, including TRA artifactsBusiness, Testing & Integration Experience - 20%10+ years of Business Analysis experience including running JAD sessions, UAT and gathering requirements10+ years of system testing, integration testing experienceDemonstrated experience with system Integration experience including ability to understand different systems and pick up new technologies quicklyExtensive experience in Quality Assurance preparing Test Plans, Test Cases and executing and monitoring unit, integration and UAT testing while working directly with clientsProven experience with requirement elicitation techniques such as User interviews, Workshops, JAD facilitation and interpretation of business needs into system design requirements.Manual system testing and integration testing experience including creating test cases and test plansPublic Sector experience - 5%Knowledge of GO-IT Standards(GO-ITS) and Enterprise Architecture within the RGDMS systemAODA Experience - 5%Hands on experience with AODA and knowledge of accessibility compliance principles as presented in WCAG 2.0, level AA QualificationsMUST HAVE:10+ years of System Analysis and Design experience, preferably in a large, complex business environmentExp in delivery design documentSystem architectureexp in database modeling (logical, physical and conceptual modeling)exp in developing in database SQL scriptexp in programing with object oriented programing languages - JAVA (required), AngularStrong Communication skills - Verbal and Presentation skills Additional InformationAll your information will be kept confidential according to EEO guidelines.
