Jobs
>
Mississauga

    PL/SQL Developer - Mississauga, Canada - Iris Software Inc.

    Iris Software Inc.
    Iris Software Inc. Mississauga, Canada

    1 month ago

    Show more Collapse job
    Default job background
    Technology / Internet
    Description

    Iris's Fortune 100 direct client is looking for PL/SQL Developer . Please find below Job description and share me your updated resume at

    Position: PL/SQL Developer

    Location: Mississauga, ON

    Candidate must have at least 5-6 years of relevant experience in Oracle SQL/PLSQL

    Must be good in communication, approachable and proactive.

    We want candidate should have good hands on experience in these areas with use cases.

    SQL;

    • Joins : INNER, LEFT, RIGHT, FULL, CARTESION join of two or more tables
    • Aggregate Functions : COUNT, MIN, MAX, AVG, FIRST, LAST, LISTAGG
    • Analytic Function : LEAD, LAG, RANK, DENSE_RANK, FIRST_VALUE, LAST_VALUE, ROW_NUMBER
    • View and Materialized Views : Basics of creating and maintaining views
    • Hierarchical queries : Data retrieval from table having hierarchical data
    • Oracle SYS tables : Basic knowledge on Oracle metadata tables
    • Privileges : How Role/Object level privileges works
    • Complex Queries : Nested queries, inline views, co-related subqueries
    • Data Types : Different types of oracle defined data types and their usage (especially CLOB, BLOB, LONG)
    • Table Partitioning : Basic knowledge on table & index partitioning
    • Oracle Functions : NVL, NVL2, DECODE, GREATEST, COLLESCE,
    • Candidate should know the concept of Oracle sharding

    PL/SQL;

    • PL/SQL Objects : Create and maintain objects like procedures, functions, packages , types, triggers,
    • Recursion, Loops (FOR, WHILE DO), Nested blocks, conditional logic (IF, CASE statements)
    • Exception handling : Knowledge on how to manage run time oracle defined/user defined errors
    • Collection & Records : Ways of using collection and records in PL/SQL blocks
    • BULK operation : Knowledge on performing operations on bulk

    We have other current jobs related to this field that you can find below

  • CMiC

    PL/SQL Developer

    3 days ago

    CMiC Toronto, Canada Full time

    Description · Are you looking to work for a growing software company? How about a socially responsible company that cares about its employees? If so, keep reading CMiC has been awarded one of Canada's Best Managed Companies and is continuing to grow and strive for the best. · A ...

  • Computer Methods International Corp.

    PL/SQL Developer

    1 week ago

    Computer Methods International Corp. Toronto, ON, Canada

    Are you looking to work for a growing software company? How about a socially responsible company that cares about its employees? If so, keep reading CMiC has been awarded one of Canada's Best Managed Companies and is continuing to grow and strive for the best. · Are you a season ...

  • CMiC

    PL/SQL Developer

    1 week ago

    CMiC Toronto, Canada Full time

    Are you looking to work for a growing software company? How about a socially responsible company that cares about its employees? If so, keep reading CMiC has been awarded one of Canada's Best Managed Companies and is continuing to grow and strive for the best. · Are you a seasone ...

  • Finastra

    Developer - SQL

    3 weeks ago

    Finastra Mississauga, ON, Canada

    Formed in 2017 by the combination of Misys and D+H, we provide the broadest portfolio of financial services software in the world today—spanning retail banking, transaction banking, lending, capital markets and treasury. Our solutions enable customers to deploy mission critical t ...

  • Tyler Technologies

    Oracle Database PL/SQL Developer

    3 weeks ago

    Tyler Technologies Old Toronto, Canada

    Are you tired of managing databases and operational issues and want to focus more on solving problems and adding value through product development? This position allows you to leverage all of your Oracle expertise to produce complex, highly optimized PL/SQL programs. · The ideal ...

  • ROSS

    DBA / SQL Developer

    1 day ago

    ROSS Mississauga, ON, Canada

    Database Administrator · The Database administrator provides specialized technical input and support and ensures auditing, configuration standards, security levels and technical support are delivered timely and professionally to promote a sound operating environment. · This pos ...

  • Tyler Technologies, Inc.

    Oracle Database PL/SQL Developer

    1 week ago

    Tyler Technologies, Inc. Toronto, ON, Canada

    Tyler Technologies is seeking candidates for the Summer 2024 Marketing Internship program You will be immersed in Tyler's successful marketing department and will gain an understanding of the public sector and technology industry, as well as gain valuable experience in market and ...

  • CB Canada

    SQL Developer

    6 days ago

    CB Canada Toronto, Canada

    SQL Developer · On behalf of our client in the Banking Sector, PROCOM is looking for a SQL Developer. · SQL Developer – Job Description · The Canadian Statutory Reporting team works to align with any new or additional requirements facing Canadian Banks · The current project i ...

  • Stackitrecruitment

    Senior .NET Developer/C#/SQL

    3 weeks ago

    Stackitrecruitment Mississauga, ON, Canada

    Our client in Mississauga is looking for a Senior .NET Developer to join their growing team · You are a highly skilled Senior .NET Developer who has expertise in the Full Stack, using Microsoft and Javascript technologies. Your responsibilities will encompass the entire software ...

  • ProViso Staffing

    Developer - SQL

    22 hours ago

    ProViso Staffing Toronto, ON, Canada

    Story Behind the Need · • Business group: Business Group: Commercial Banking Engineering oversees changes/implementations to commercial client programs. · • Project: Supporting the Business Banking CLient portal (BBCP) application – onboarding tool for Commercial clients and Pr ...

  • Nexus Systems Group Inc.

    SQL Developer

    3 weeks ago

    Nexus Systems Group Inc. Old Toronto, Canada

    Location Address: Toronto – hybrid – onsite 3x/week · Contract Duration: 10 months · Possibility of extension & conversion to FTE · Number of Positions: 1 · Schedule Hours: 9am-5pm Monday-Friday (Possible OT) · Reason: additional workload · Story Behind the Need · Business group: ...

  • First Derivative

    Senior SQL Developer

    2 weeks ago

    First Derivative Toronto, Canada

    Who are we? · First Derivatives (FD) is a leading software and services company, with world-leading intellectual property in ultra-high-performance analytics (KX) across industries, and extensive domain expertise and capabilities in capital markets systems and technology (managed ...

  • Delpath

    PowerBi/SQL Developer

    21 hours ago

    Delpath Toronto, Canada

    Location Address: Hybrid - Downtown Toronto – 1 day/week (Wednesdays, subject to change to increase to 3 days in October) – need candidates in GTA · Contract Duration: 1 year · Possibility of extension · Schedule Hours: 9am-5pm Monday-Friday; standard 37.5 hrs/week · Reason: Back ...

  • ProViso Staffing

    Developer – MS SQL

    3 weeks ago

    ProViso Staffing Old Toronto, Canada

    · Story Behind the Need: · • Business group: Global Wholesale, Wealth, and Risk Technology – Market Risk team, responsible delivering system solutions for Global Risk Management. · • Project: End of Life Software remediation for SAG-GC; The successful candidate will work closely ...

  • First Derivative

    Senior SQL Developer

    3 weeks ago

    First Derivative Toronto, ON, Canada

    Who are we?First Derivatives (FD) is a leading software and services company, with world-leading intellectual property in ultra-high-performance analytics (KX) across industries, and extensive domain expertise and capabilities in capital markets systems and technology (managed se ...

  • BeachHead Inc.

    Developer SQL

    3 weeks ago

    BeachHead Inc. Toronto, ON, Canada

    Are you collaborative, resourceful and highly organized? Do you enjoy developing relationships with influential stakeholders? If yes, this could be your next opportunity · Working with one of the top financial clients this role calls for a PowerBI Developer-DAX/Salesforce who wil ...

  • Compest Solutions Inc

    Informatica, Etl, Powercenter(Pl/SQL, Unix

    2 weeks ago

    Compest Solutions Inc Toronto, Canada

    **Job title: Informatica developer** · **Client: Bank domain** · **Location**: Willing to come to client's **Toronto office 3 times a week** · **Need Developer with below skill set ready for developing and coding should have basic and expert level of coding developing experience ...

  • ProViso Staffing

    Power BI Developer – SQL

    3 weeks ago

    ProViso Staffing Old Toronto, Canada

    · Story Behind the Need: · • Business group: Global Cash Management · • The team focused on internal treasury reporting around liquidity and funding metrics. · • We are seeking a skilled Power BI Developer to join our dynamic team. The ideal candidate will be responsible for tra ...

  • City of New York

    SQL Developer Data Engineer

    1 week ago

    City of New York Hamilton, ON, Canada

    ONLY PERMANENT EMPLOYEES IN THE TITLE AND THOSE THAT ARE REACHABLE ON THE COMPUTER SPECIALIST (SOFTWARE) CIVIL SERVICE LIST ARE ELIGIBLE TO APPLY. · AGENCY DESCRIPTION · Established in 1805, the New York City Department of Health and Mental Hygiene (the NYC Health Department) i ...

  • First Derivative

    Senior SQL Developer

    3 weeks ago

    First Derivative Toronto, ON, Canada

    Who are we? First Derivatives (FD) is a leading software and services company, with world-leading intellectual property in ultra-high-performance analytics (KX) across industries, and extensive domain expertise and capabilities in capital markets systems and technology (managed s ...