Note: This position will require the consultant to work from the office location 5 days per week.

Responsibilities
· Design, implement, and continuously expand data pipelines by performing extraction, transformation, and loading activities.
· 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, and conducting unit tests.
· Resolves and troubleshoots technical problems which arise during the use and operation of software packages, including technical assistance in implementation, conversion and migrations.
· The resources will also support CSC release and infrastructure solutions support sustainment activities, urgent priorities, changing needs, or time-sensitive infrastructure upgrades, or other sustainment activities supporting any CSC platforms overseen by the Cluster where annual work is required.

General Skills
· Experience in programming and analysis; specialized software package support at the specified experience level
· Ability to collaborate with IT Professionals throughout the Software Development Life Cycle
· Experience in structured methodologies for the development, design, implementation and maintenance of applications
· Experience in design, code, test, debug and document applications
· Experience in the use of object and/or third generation language development tools
· Experience in one or more programming languages
· Experience in application design, latest design patterns, deployment and troubleshooting
· Experience with relational and hierarchical database technologies
· Experience in the use of information retrieval packages using query languages
· Experience with one or more communications protocols
· Experience in structured methodologies for the design, development, implementation and maintenance of applications
· Experience eliciting and documenting information from diverse business area stakeholders and subject matter experts
· Experience with application architecture, front-end & back-end integration, API development
· Excellent analytical, problem-solving and decision-making skills; verbal and written communication skills; interpersonal and negotiation skills
· A team player with a track record for meeting deadlines

Full Stack Skills
· Proficient with both front end and back end development, including any associated areas such as database design/management and DevOps
· Knowledge and experience with design and implementation of the overall web architecture
· Experience with implementation of approved user interface, design and deployment of database
· Knowledge and experience ensuring the entire stack is designed and built for speed and scalability
· Knowledge and experience with the design and construction of REST API services
· Knowledge and experience integrating front-end UI with the constructed API
· Knowledge and experience in design and implementation of continuous integration and deployment

Desirable Skills
· Knowledge and experience with programming Internet-ready applications
· Knowledge and experience in rapid application development (RAD) methodologies
· Knowledge and understanding of Information Management principles, concepts, policies and practices
· Experience with middleware and gateways
· Experience reviewing, analyzing, and modifying product installation scripts including encoding, testing, debugging
· Ability to provide post-implementation support and resolve any post-implementation technical issues
· Experience conducting design walkthrough sessions with project team
· Knowledge and understanding of Accessibility for Ontarians with Disability Act (AODA) and related regulations and standards
· Ability to provide user and system documentation as required
· High level of knowledge around the Angular framework and JavaScript.
· High level knowledge of front-end interfaces.
· Strong knowledge of RESTful APIs and good understanding of Swagger files.
· Demonstrated ability to create self-contained, reusable, and testable modules and components that build on the elements and modules of core AngularJS.
· Experience creating, designing, and implementing layouts for new and existing web pages. Excellent knowledge of front-end web programming languages, such as HTML, CSS, JavaScript, and AngularJS, with ability to render server-side and client-side content.
· Experience designing user interactions on websites, developing servers and databases for website functionality and coding for mobile platforms.
· Fundamental knowledge of UX/UI.
· Experience ensuring front end code is able to query APIs.
· Experience with Java WebLogic and Java programming for web applications (Tomcat, Weblogic), EJB, Servlet
· Strong database skills and SQL skills (Oracle, SQL Server)
· Experience / knowledge of REST, SOAP web services.
· Experience / knowledge of Azure DevOps, JIRA, agile/scrum

• Skills

• Experience and Skill Set Requirements
Programmer and Development Skills - 65%
· Experience in systems design, configuration, integration and development, IT security, programming concepts, languages and related methods, techniques, practices and standards such as JAVA, J2EE, JSF, HTML/DHTML, XML/XSL, iText and Microservice.
· Hands on experience in n-tier web-based application development using Oracle database.
· Development experience using emerging technologies such as Web Services, web responsive frontend development, AODA compliant solutions.
· Experience in using open source software such as Spring, myBatis, Bootstrap, jQuery
· Experience using reporting tools such as Jasper, and Crystal Reports
· Demonstrated experience directly supporting the SDLC (agile/iterative) and implementation of business-critical software applications and systems.
· Experience in writing application architecture and data modelling artifacts for the development and customization of large web-based applications
· Knowledge of J-rules, Oracle content management system and docker, WebSphere application server
· Hands on experience with azure cloud, AKS, WebSphere liberty or open liberty, and DevOps tool chain (Nice to have)
General Skills - 30%
· Analytical and problem-solving skills to identify and resolve existing and potential systems issues.
· Consultation, interpersonal and teamwork skills to discuss client requirements, lead discussions of system development options and technical process and to work effectively with colleagues and clients.
· A team player with a track record for meeting deadlines
· Experience in providing technical leadership & guidance to junior developers.
OPS Experience - 5%
· Experience with Public sector architecture, methodologies and GO–ITS standards would be an asset.
· Familiar with Public sector Threat Risk Assessment (TRA) and Privacy Impact Assessment (PIA) process