Senior Java / ETL Software Developer (Java, ETL, SQL, PL / SQL, Power BI)

Senior Java / ETL Software Developer (Java, Informatica , ETL, SQL, PL / SQL,and Power BI)

Toronto, Ontario - Hybrid, 3 days onsite - 87 Sir William Hearst Ave Toronto, ON M3M 0B4

Contract, 9 months (with possibly of extension)

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), COJG (Canada Ontario Job Grant), and APPR AOL (Apply OnLine).

The operating Environment includes J2EE, CURAM, Crystal Reports, Oracle SQL / PL SQL, Power BI, Oracle Database, Business Objects Universe and Dashboarding, WebI, and Bursting technologies, and Informatica ETL.

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

• ETL scripts to transfer and transform data from O LTP database to Data Warehouse and Data marts .
• Nice to have skills in Crystal reports, Power BI, and BOE reporting

Required to translate technical systems specifications into working, tested applications. This includes :

Must have :

Nice to have :