Requisition Title: Systems Analyst – Level 3
Location: Toronto, ON
Duration: 6 months
Our public sector client is looking for two Systems Analyst – Level 3 to work on Transportation Safety Division Applications (Maintenance & Support)
Deliverables
Task 1
Monthly Performance Status Report.
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
Analyze, design and develop the Driver, Vehicle and other related systems in support of the data and information requests from MTO internal and external clients.
Deliverables
- Analyze the Driver, Vehicle and other related data requirements
- Reverse engineer and document business and data rules embedded in the legacy Driver, Vehicle and other related systems & applications
- Design, develop & test the data extraction programs and SQLs to complete the requested reporting products
Estimated Completion Date
- Throughout the operational support and maintenance cycles.
Task 3
Support MTO and other Ministry clients in the delivery of dashboard and reporting products.
Deliverables
- Support users in the analysis of data, construct of data relationships, development of the data extract queries and development of the data and information products
Estimated Completion Date
- Throughout the operational support and maintenance cycles.
Task 4
Knowledge transfer to ministry staff.
Deliverables
- Documentations
- Walk-through sessions
Estimated Completion Date
- Through scheduled document deliverable review timeline and weekly review sessions.
Skill Sets
- Proven experience in the architecture, design, development and maintenance of mainframe and n-tier applications, data warehouses and data marts
- Experience in using JCL, TSO/ISPF, BTS, PLI, COBOL, RPG3/4, SQL, PL/SQL, stored procedure, REXX, CLIST, IMS DB/DC, DB2 and IMS Connect
- Experience with IBM 3270SNA communications and Communications Manager
- 10+ years experience with relational and hierarchical databases technologies and with high volume of data
- 10+ years experience in the use of information retrieval using query languages
- 10+ years experience with enterprise data warehouse architecture, designing, building, testing and execution of warehouse/mart load scripts
- Experience in data extraction, data analysis, data quality and data profiling for mainframe IMS, DB2 and Oracle data
- Experience with Informatica ETL Tool
- Experience with MS SQL, MS PowerBI and Report Builder
- Experience with the Application Lifecycle Management (ALM) Tool
- Excellent analytical, problem-solving and decision-making skills
- Excellent verbal and written communication skills
- Excellent interpersonal and negotiation skills