RQ08166 - Specialized IT Consultant - Intermediate

Responsibilities:Works in partnership with clients, advising them on information technology in order to meet their business objectives or overcome problems, work to improve structure and efficiency of an organizations I&IT systems.The I&IT Consultant may be used to provide strategic guidance to organizations with regard to Information Management & IT technology, IT infrastructures and the enablement of major business processes through enhancements to IT.Provides subject matter expertise in their field and highly expert technical assistance.General Skills:Acts as the technical advisor/expert on all aspects of a specific deliverableProvide the quality assurance/quality control of specific deliverablesAnticipates and resolves problems to ensure that the deliverables are completed within budget, to the highest quality, meeting or exceeding expectationsDevelops processes and procedures for implementing deliverablesPrepares reports and presentations including options, recommendations, implementation plans, etc.Works with clients to define the scope of a project and to determine requirementsDefines software, hardware and network requirementsAnalyzes I&IT requirements giving independent and objective advice on the use of I&ITDesigns, tests, installs and monitors new systems and develops solutions and implementation of new systemsFamiliar with change-management principles and methodologyKnowledge and understanding of Information Management principles, concepts, policies and practicesKey deliverables to be performed by the consultants include, but are not limited to, the following:Participating in the analysis, design, development and testing on assigned projects;Participating in project design and code walkthroughs;Perform knowledge transfer to designated Ministry staff, providing expertise and training to business users;Establishing relationships with client management and client subject matter experts and staff of the ministries to build knowledge of business directions, issues and operations;Participating in the creation of detailed plans and accurate estimates towards development, testing, and implementation of the project or program;Participating in and/or leading Joint Application Design sessions with the business and IT teams;Contributing to successful project completion by identifying risks and developing/ recommending mitigation strategies;Liaising with IT specialists and unit leads and working closely with support team members and relevant stakeholders;Facilitating defect, issue and risk resolution by following up with the business to confirm design decisions as required;Participating in discussions with the business analyst regarding any changes required to business and/or system requirements, as well as requirement gathering sessions;Working closely with the subject matter experts, managers, and staff of the ministries on issues and business needs;Creating and/or updating data processing overview, technical design, source to target mapping, operation manual and other technical documentation;Providing input into and/or completing required architectural/development artifacts; Consulting with clients, analyzing their business needs and assessing their problems/opportunities, promoting I&IT services, solutions and approaches and ensuring the cluster adds value in supporting business needsSystems and Quality Assurance TestingAnalyzing requirements;Creating test strategy test plan, test case documentation and test scripts;Documenting expected testing results;Creating and modifying complex data-sets for testing purposes;Executing functional, regression and performance testing based on the test cases and scripts developed;Reporting on the status of test execution and testing results, documenting defects;Preparing for, supporting and participating in System Integration (SIT) testing, System Acceptance (SAT) testing and User Acceptance (UAT) testing;Implement the automation of new and existing testing scripts using Quick Test Pro v10.0; Creating and executing detailed test cases to support DB2 to Oracle migration of ETL code and dataLead and mentor junior QA analysts on the test framework and test executionBusiness Intelligence/Data Analysis and ProfilingAnalyzing business needs and participate in design of the overall project; Leading data analysis and profiling tasksAnalyzing data in source and target systems to identify data cleanliness issues (e.g. missing values, duplicate meanings, and invalid data)Developing complex SQL queries to extract, analyze and validate key business data from a wide-range of data repositories (relational and multi-dimensional data stores, flat files, structure and unstructured)Developing automation extraction, validation, cleansing and load scriptsDeveloping and supporting the use of Business Intelligence tools and best practices within the branch;Providing planning advice to the project team on the use of data, and building capacity within the Ministry on performing advanced anal