software developer
Description
Job Description Description: ?Employment Ontario? is one of the major programs delivered by the Employment and Training Division of the Ontario Ministry of Training, Colleges and Universities. Employment Ontario helps the citizens of Ontario gain the training, skills and experience to achieve their goals. The Employment Ontario Information Systems (EOIS) is the major IT system that supports the administration of these programs. Application subsystems under EOIS include CaMS (Case Management System), Service Provider lifeCycle (SPL), EO Self Service (EOSS), APPR (Apprenticeship), OJG (Ontario Job Grant), and APPR AOL (Apply OnLine). The operating Environment includes JEE, CURAM, Crystal Reports, Oracle SQL/PL SQL, Power BI, Oracle Database, Business Objects Universe and Dashboarding, WebI, Bursting technologies, and Informatica ETL. Responsibilities: This request is for strong developers to help in designing and developing data warehousing, BI, reporting and analytics. Perform analysis, design, developing, unit testing, defect fixing and other necessary tasks in a data warehousing and BI environment in Oracle PL/SQL Design, develop and test Informatica mappings Develop ETL scripts to transfer and transform data from OLTP database to Data Warehouse and Data marts Develop and maintain BOE reports Communicate your progress clearly and timely to the management team Must have skills in Crystal reports, Informatica, Power BI and BOE reporting 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 patters, deployment and troubleshooting Experience with relational and hierarchical database technologies <li class="align-justify" style=