47 Pl Sql Developer jobs in Canada

Job Description

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:

• 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

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:

• 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 

Job Description

Salary:

Since 2012, Rightsline has been revolutionizing rights and royalties management with its leading IP Commerce SaaS platform. Trusted by global innovators like Disney, Amazon, Spotify, and the NFL, our solutions empower rights holders to maximize portfolio value, reduce risk, and increase profitability. Serving industries from media and entertainment to life sciences, our scalable platform combines advanced analytics, business process outsourcing, and decades of expertise to tackle the most complex rights and royalties challenges.

With over 300 employees across multiple regions, including the United States, Canada, the United Kingdom, and India, Rightsline fosters a dynamic, collaborative environment where innovation thrives. Were passionate about creating smarter solutions, encouraging personal growth, and celebrating creativity. Join a team that offers competitive benefits, a supportive workplace, and the opportunity to lead the future of intellectual property management.

Welcome to a world of less data entry and more data integrity. Welcome to the Rightsline reality!

The Position

We are seeking a skilled Data Engineer to join our dynamic team. In this role, you will play a pivotal part in designing and implementing custom solutions that support complex financial and IP calculations, reporting, and data transformations. Your work will directly contribute to improving our clients' operational efficiency and decision-making capabilities.

**We are looking to fill this role in a hybrid environment**

What you will do:

• Problem-Solving: Develop innovative solutions to complex challenges in financial calculations, rights management, and process optimization.
  
• Data Engineering Solutions: Design, build, and maintain scalable data pipelines for migration, cleansing, transformation, and integration tasks, ensuring high-quality data outcomes.
  
• Database Development & Maintenance: Configure, implement, and refine stored procedures and queries to ensure optimal performance, scalability, and maintainability of database systems.
  
• ETL & Data Migration: Develop robust ETL (Extract, Transform, Load) processes that integrate data from diverse sources, ensuring seamless migration and transformation for downstream analytics and reporting.
  
• Automation & Scripting: Create and implement automated scripts and tools to streamline routine database tasks, reduce manual intervention, and improve overall operational efficiency.
  
• Collaboration: Partner with cross-functional teams to align data engineering efforts with broader business objectives and deliver seamless solutions that drive value across the organization.
  
• IP Commerce Data Expertise: Leverage deep knowledge of financial and rights data to develop creative solutions that address client needs and advance business goals.
  
• Process Improvement: Continuously identify opportunities to optimize workflows, automate repetitive tasks, and enhance efficiency in data processing and delivery.
  

What you will bring to the role :

Must-Have:

• Minimum 2 years of experience in an database developer or analyst position.
  
• Bachelors in Computer Science, Engineering or equivalent work experience.
• Exceptional analytical thinking and problem-solving capabilities.
  
• Strong verbal and written communication skills with the ability to articulate technical concepts clearly.
  
• Proficiency in analyzing complex financial or IP data sets.
  
• Hands-on experience with engineering principles, including designing and implementing scalable solutions.
  
• Strong attention to detail and commitment to ensuring data accuracy and integrity.
  

Preferred:

• Experience working with SQL and/or Python for data manipulation and analysis.
  
• Experience working in finance or IP-related industries, with an understanding of their unique challenges and requirements.
  
• Familiarity with handling large-scale datasets and cloud-based platforms (e.g., AWS, Azure, Google Cloud).
  
• Knowledge of DevOps practices and CI/CD pipelines to streamline database management and deployment.
  
• Understanding of data warehousing architectures and business intelligence tools for advanced analytics.
  
• Certifications in relevant database technologies (e.g., Microsoft Certified: Azure Database Administrator Associate or Oracle Certified Professional) are a bonus
  

Compensation :

• Competitive Compensation and Health & Dental Benefits
  
• 401K / RRSP Match Program

The Rightsline Advantage

At Rightsline we encourage inclusiveness, purpose and innovation. We offer flexible work hours, birthdays off, alternating 4-day work weeks, one-time home office allowance, unlimited vacation time, team socials, happy hours and career progression in a high growth environment.

• Rightsline was the very 1st cloud-based rights and contract management platform, so were used to innovation. Were also used to incredible growth if youre into that sort of thing.
• You will become part of an amazing culture with a supportive executive team, smart colleagues who truly care, and a global team thats been rocking this virtual collaboration thing since before anyone had ever heard the term COVID19.
• Youll often hear Yes, lets try that! and then have the chance to execute your ideas.
• You will grow more here than you would at any other company. Thats a promise.
• A People First Company - 4.2 rating on Glassdoor

Our 4 Stage Recruitment Process

1. Review - We review applications and screen based on a variety of criteria
2. Phone - Candidates will be screened via a quick 20-minute Zoom meeting to discuss the role opportunity
3. Interview - We will conduct 2-3 stages of interviews via Zoom
4. Offer - We will make an offer to the candidate that we feel would excel most in the role.

**Please be advised that only those candidates selected for interviews will be contacted, and references will be requested for those candidates selected in the final interview stage.**

Equal Employment Opportunity

Rightsline is an equal opportunity workplace. All candidates will be afforded equal opportunity through the recruiting process. We do not discriminate against any employee or applicant for employment because of race, color, sex, age, national origin, religion, sexual orientation, disability, gender identity and/or expression. We are dedicated to growing a diverse team of highly talented individuals and creating an inclusive environment where everyone feels empowered to bring their authentic selves to work.

If you are contacted for an interview and require accommodation during the interviewing process, please let us know.

Apply Today

If you want to join a company that strives for a mission, purpose and making an impact, we encourage you to apply today.

Job Description

Database Developer – Join a Team Powering the Future of Smart Technology!

Location: Burnaby, BC | Type: Full-Time, Permanent | Work Mode: Onsite, Monday to Friday

We’re excited to be hiring a Database Developer on behalf of a cutting-edge smart grid technology client who is redefining how data powers clean energy. If you're a Database Developer who thrives on solving big problems with elegant solutions, this is your chance to make a lasting impact.

As a Database Developer, you'll be a central part of the Product Development team—owning the evolution of the data layer that supports a suite of next-generation products. You’ll help transition legacy systems to a modern, cloud-native architecture and build a new business layer to generate real-time insights from time-series data. You’ll also maintain and enhance existing SQL-based infrastructure to ensure rock-solid performance and scalability.

This is more than a maintenance role—it's a high-impact opportunity for a forward-thinking Database Developer to work across cloud environments, data modelling, and next-gen architectures.

• Work on next-gen data platforms: Be part of a transformative journey from legacy systems to scalable, cloud-native solutions.

• Cross-functional impact: Collaborate with engineering, product, and business teams to shape the core of smart grid data.

• Innovation meets stability: Enjoy the pace of a fast-evolving tech environment with the support of a well-established company.

• Competitive base salary: $100,000 – $20,000

• Comprehensive health benefits + $1 600 annual flexible spending account

• Paid parental leave

• 3 weeks of paid vacation

• Annual training budget of $1,000

• Participation in stock options program

• As a Database Developer, own and evolve data models that enable scalable product development

• Architect horizontal scalability for data layers across on-prem and cloud platforms

• Enhance and maintain SQL-based business and data access layers

• Optimize database performance to ensure reliability and uptime across all deployments

• Collaborate with cross-functional teams to integrate diverse technologies into a unified platform

• Bachelor’s in Computer Science, IT, or related field

• 5+ years as a Database Developer with strong SQL/PLSQL expertise, expert sequence development skills

• Deep knowledge of data architecture, performance optimization, and cloud database systems

• Experience with Oracle and PostgreSQL (TimescaleDB preferred)

• Strong Linux skills and backend integration using Python, Java, C/C++, or Go

• Proven success in supporting mission-critical database environments

• Familiarity with database security, monitoring, and operational best practices

• Master’s degree in a related field

• Hands-on experience with TimescaleDB, Snowflake, MongoDB, or other cloud-based DBs

• Experience with large-scale database migrations or building data lakes

• Exposure to fast-paced, agile software development environments

If you’re a driven Database Developer who’s passionate about building powerful, efficient, and future-ready data systems, we’d love to connect with you. Join a team that’s not just managing data—but transforming how the world uses it.

Apply now and be a Database Developer shaping the future of clean, smart technology!

Job Description

Database Developer – Join a Team Powering the Future of Smart Technology!

Location: Burnaby, BC | Type: Full-Time, Permanent | Work Mode: Onsite, Monday to Friday

We’re excited to be hiring a Database Developer on behalf of a cutting-edge smart grid technology client who is redefining how data powers clean energy. If you're a Database Developer who thrives on solving big problems with elegant solutions, this is your chance to make a lasting impact.

As a Database Developer, you'll be a central part of the Product Development team—owning the evolution of the data layer that supports a suite of next-generation products. You’ll help transition legacy systems to a modern, cloud-native architecture and build a new business layer to generate real-time insights from time-series data. You’ll also maintain and enhance existing SQL-based infrastructure to ensure rock-solid performance and scalability.

This is more than a maintenance role—it's a high-impact opportunity for a forward-thinking Database Developer to work across cloud environments, data modelling, and next-gen architectures.

• Work on next-gen data platforms: Be part of a transformative journey from legacy systems to scalable, cloud-native solutions.

• Cross-functional impact: Collaborate with engineering, product, and business teams to shape the core of smart grid data.

• Innovation meets stability: Enjoy the pace of a fast-evolving tech environment with the support of a well-established company.

• Competitive base salary: $100,000 – $20,000

• Comprehensive health benefits + $1 600 annual flexible spending account

• Paid parental leave

• 3 weeks of paid vacation

• Annual training budget of $1,000

• Participation in stock options program

• As a Database Developer, own and evolve data models that enable scalable product development

• Architect horizontal scalability for data layers across on-prem and cloud platforms

• Enhance and maintain SQL-based business and data access layers

• Optimize database performance to ensure reliability and uptime across all deployments

• Collaborate with cross-functional teams to integrate diverse technologies into a unified platform

• Bachelor’s in Computer Science, IT, or related field

• 5+ years as a Database Developer with strong SQL/PLSQL expertise

• Deep knowledge of data architecture, performance optimization, and cloud database systems

• Experience with Oracle and PostgreSQL (TimescaleDB preferred)

• Strong Linux skills and backend integration using Python, Java, C/C++, or Go

• Proven success in supporting mission-critical database environments

• Familiarity with database security, monitoring, and operational best practices

• Master’s degree in a related field

• Hands-on experience with TimescaleDB, Snowflake, MongoDB, or other cloud-based DBs

• Experience with large-scale database migrations or building data lakes

• Exposure to fast-paced, agile software development environments

If you’re a driven Database Developer who’s passionate about building powerful, efficient, and future-ready data systems, we’d love to connect with you. Join a team that’s not just managing data—but transforming how the world uses it.

Apply now and be a Database Developer shaping the future of clean, smart technology!

#BRBC

Job Description

We are looking for an experienced Data Developer for our client. This is a permanent position, remote! Our client is a large fintech firm with a product that you've likely used many times before.
You'll have the opportunity to work on an extremely large, internationally used payment platform. Your role will encompass managing, building, planning administrating and maintaining infrastructure services like Systems, Containers, Servers, Data Centers and Storage to ensure our client has a robust, scalable and stable infrastructure.

You Have:

• 7+ years experience working with SQL data development
• Strong experience with SSRS and Stored Procedures
• Experience with visualization tools like Power BI and Tableau
• Experience working in a cloud environment (ideally Azure )
• Bonus points if you have experience with Python and Pyspark
• A B.Sc. or equivalent work experience required.

Some AWESOME selling points:

• Remote + flexible work schedule
• Competitive salary + Extended Health and Dental Benefits
• Amazing opportunity for career progression to lead
• Amazing mentorship (seriously)
• Plenty of vacay

It's a seriously awesome opportunity! If this looks interesting to you, please click the link and apply.

** Unfortunately we are only able to consider candidates who either live in Canada, or currently have an active Canadian work visa or citizenship for this role.

Job Description

We are looking for an experienced Data Developer for our client. This is a permanent position, remote! Our client is a large fintech firm with a product that you've likely used many times before.
You'll have the opportunity to work on an extremely large, internationally used payment platform. Your role will encompass managing, building, planning administrating and maintaining infrastructure services like Systems, Containers, Servers, Data Centers and Storage to ensure our client has a robust, scalable and stable infrastructure.

You Have:

• 7+ years experience working with SQL data development
• Strong experience with SSRS and Stored Procedures
• Experience with visualization tools like Power BI and Tableau
• Experience working in a cloud environment (ideally Azure )
• Bonus points if you have experience with Python and Pyspark
• A B.Sc. or equivalent work experience required.

Some AWESOME selling points:

• Remote + flexible work schedule
• Competitive salary + Extended Health and Dental Benefits
• Amazing opportunity for career progression to lead
• Amazing mentorship (seriously)
• Plenty of vacay

It's a seriously awesome opportunity! If this looks interesting to you, please click the link and apply.

** Unfortunately we are only able to consider candidates who either live in Canada, or currently have an active Canadian work visa or citizenship for this role.