Senior Java/ ETL Software Developer
Senior Java/ ETL Software Developer
Employer Active
Job Alert
You will be updated with latest job alerts via email
Share
Job Alert
You will be updated with latest job alerts via email
Job Description
Senior Java/ ETL Software Developer (Java Informatica ETL SQL PL/SQLand 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 OLTP 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:
- 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.
Must have:
- 5 yr Demonstrated experience in JAVA-based software development.
- 5 years of ETL experience including data Warehouse design Reporting and ETL concepts.
- 3 years experience with analysis design developing unit testing defect fixing and other necessary tasks in data warehousing BI environment designing and developing data warehousing BI reporting and analytics
- 3 years Experience in Designing developing and testing SQL and PL/SQL.
- 3 years Experience in Designing developing and testing in Informatica.
- Experience in RDBMS design concepts.
- Experience with Data Warehouse architecture design dimensional modeling development and deployment of business intelligence systems.
Nice to have:
- Experience in BOE dashboards universes & reports Power BI Crystal Report
- Public Sector experience
Employment Type
Full Time
