Senior Java/ ETL Software Developer

6 days ago

Toronto, Ontario, Canada Source Code Full time $80,000 - $120,000 per year


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 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 

  • ETL Java developer

    2 weeks ago

    Toronto, Ontario, Canada LTIMindtree Full time $80,000 - $120,000 per year

    Role: ETL Java developerTerm: Full TimeLocation: Toronto, ON (hybrid)Key skills: ETL developer with Java Springboot; MarkitEDM experience preferred but no mandatory; Database/MySQL knowledge and understandingRole OverviewThe ETL & Java Senior Developer will be responsible for designing, developing, and maintaining efficient data integration and management...

  • RQ09460 - Software Developer - ETL - Senior

    1 week ago

    Toronto, Ontario, Canada S M Software Solutions Inc Full time $120,000 - $180,000 per year

    Client: Ministry of Public and Business Service Delivery and ProcurementWork Location:595 Bay Street, Toronto, Ontario,OnsiteEstimated Start Date: Estimated End Date: #Business Days:130.00Extension:Probable after the initial mandateHours per day or Week:7.25 hours per daySecurity Level:CRJMC + Credit CheckMust Have5+ years of proven working experience in an...

  • RQ09886 - Software Developer - ETL - Senior

    1 week ago

    Toronto, Ontario, Canada S M Software Solutions Inc Full time $80,000 - $120,000 per year

    Client: Ministry of Public and Business Service Delivery and ProcurementWork Location:595 Bay Street, Toronto, Ontario,OnsiteEstimated Start Date: Estimated End Date: #Business Days:165.00Extension:Probable after the initial mandateHours per day or Week:7.25 hours per daySecurity Level:CRJMC + Credit CheckMust Have5+ years of proven working experience in an...

  • RQ10027 - Software Developer - ETL - Senior

    1 week ago

    Toronto, Ontario, Canada S M Software Solutions Inc Full time $80,000 - $120,000 per year

    Client: Ministry of Treasury Board SecretariatWork Location:222 Jarvis St., Toronto, Ontario,OnsiteEstimated Start Date: Estimated End Date: #Business Days:274.00Extension:130.00Hours per day or Week:7.25 hours per daySecurity Level:CRJMCMust HaveExperience with the Microsoft suite of technology including: Azure Data Factory, Azure SQL Database, Azure Data...

  • Senior ETL Developer

    1 week ago

    Toronto, Ontario, Canada 2iSolutions Inc. Full time $80,000 - $120,000 per year

    RQ Software Developer - ETL – SeniorLocation:Onsite / 595 Bay Street, TorontoPeriod:  6-monthsMust-haves:·      5+ years of proven working experience in an ETL role;strong understanding of ETL principles, including data extraction, transformation, and loading processes; knowledge of common ETL design patterns. Understanding of data pipeline...

  • RQ10027 - Software Developer - ETL - Senior

    2 weeks ago

    Toronto, Ontario, Canada Maarut Inc Full time $100,000 - $120,000 per year

    Responsibilities:Design, implement, and continuously expand data pipelines by performing extraction, transformation, and loading activities.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,...

  • Java Software Developer

    12 hours ago

    Toronto, Ontario, Canada Venuiti Solutions Full time

    Senior Java DeveloperCanadian Citizenship MandatoryPermanent, Full-timeIn-Office, Toronto, ONWHERE YOUR EXPERTISE IS NEEDEDWe are seeking a highly skilled and experienced Senior Java Developer to join our team. This role combines leadership responsibilities with hands-on development, requiring approximately 40% focus on team management and 60% on coding and...

  • Java Fullstack Developer

    1 day ago

    Toronto, Ontario, Canada Iris Software Inc. Full time $120,000 - $150,000 per year

    Iris's client, the largest bank in the Canada is looking to hireSenior Java FS DeveloperPlease find below the job details and share your resume if interested atJob Description:Title: Java FS DeveloperLocation: Toronto, ON (Hybrid – 4days/Week)Duration: Long term assignmentRequired Skills:Java (Spring), Java Script (Angular)OCP, DevOps, Mongo and/or...

  • RQ10027 - Software Developer - ETL - Senior

    2 weeks ago

    Toronto, Ontario, Canada Maarut Inc Full time $100,000 - $150,000 per year

    Responsibilities:Design, implement, and continuously expand data pipelines by performing extraction, transformation, and loading activities. 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,...

  • Senior Java Developer

    1 day ago

    Toronto, Ontario, Canada Altitude Technology Solutions Full time $320,000 per year

    Position: Senior Java DeveloperLocation: Toronto, Canada (On-site mandatory 2 days per week)Experience- 8+ yearsExperience: Minimum 5 years hands-on with Java Microservices and strong database and data modelling skills Key Responsibilities:Develop and maintain applications using Java (versions 11 to 21) and Spring Boot (2 to 3).Strong SQL querying skills for...