Senior BI Engineer building data models, semantic layers, and dashboards for Jobber’s small - business service platform. Driving governed self - service analytics and trusted business metrics.
LP
Oracle Pl/SQL Developer
Posted via LinkedIn Recruiter (not a company profile)
Posted 7 months ago
About the role
- Oracle PL/SQL Developer role in Mississauga (Hybrid). Requires strong Oracle SQL/PLSQL skills, performance optimization, and experience with JSON data and application integration.
Responsibilities
- Oracle PL/SQL Developer responsible for developing and optimizing Oracle database solutions. Key responsibilities include: strong understanding between OLTP and Batch Processing using SQL and PLSQL; working with Oracle Table Indexes, Primary Keys, and Table Partitions; fetching JSON data using PIVOT with unknown number of columns; applying rowlocks; strong knowledge of SQL Joins and PLSQL collections; understanding deterministic functions and sysrefcursor; capturing program calls to Oracle PLSQL procedures/functions/packages; expertise in Oracle SQL parsing, SQL engine vs PLSQL engine, and PLSQL cursors; working with ToDate and totimestamp functions; renaming table columns; understanding SQL execution plans and inline functions; implementing user-defined referential constraint checks using PLSQL; comparing data between identical tables and finding unmatched columns; optimizing storage and retrieval of JSON data from CLOB columns; using Execute Immediate; handling PLSQL exceptions (user-defined and Oracle-provided); passing data from Oracle PLSQL procedures to Angular, Java, or Python; understanding SQL operators (IN, ANY, ALL); evaluating advantages/disadvantages of PLSQL packages; understanding nested transactions in Oracle.
Requirements
- Strong expertise in Oracle SQL and PL/SQL development including OLTP/batch processing, performance optimization, JSON data handling, and application integration. Industry certification in Oracle Database is mentioned.
Job title
Job type
Experience level
Salary
Not specified
Degree requirement
No Education Requirement
Tech skills
Location requirements
Report this job
Found something wrong with the page? Please let us know by submitting a report below.
Senior BI Data Engineer building data pipelines, warehouses, and reporting solutions for Trillium Health Partners hospitals. Leading Microsoft BI architecture, integration, and technical delivery.
Business intelligence consultant building Sage Intacct and Sage 300 CRE financial reports. Supporting accounting and operations teams with SQL - integrated, multi - entity reporting solutions.
Senior BI Developer designing SAP Datasphere data solutions for Aecon, an infrastructure construction company. Enabling SAP analytics, integration, governance, and secure enterprise data products.
Senior Business Intelligence Analyst managing analytics, dashboards, and revenue assurance for Metergy’s utility submetering business. Improving billing controls, margins, and operational performance.
Senior BI Analyst building Power BI dashboards and data solutions for TD, a global financial institution. Delivering actionable insights through SQL, Databricks, DAX, and Power Query.
Senior Data and BI Engineer building enterprise data lakes, pipelines, and real - time analytics platforms. Supporting utility software provider Systems & Software’s trusted customer insights and operations.
Data Analytics & BI Analyst building dashboards, models, and reporting for CoVet’s AI tools supporting veterinary professionals. Partnering across teams to improve business decisions and data quality.
Business Intelligence Analyst developing data products, dashboards and insights for the Government of Alberta. Supporting data strategy, governance and evidence - based decisions across departments.
Développeur BI chez BEEM, transformant les données d’entreprises en dashboards Power BI et solutions IA. Conception de semantic layers, SQL avancé et livraison de solutions data auprès des clients.