Etl developer/oracle Jobs

Senior Oracle Data Warehouse Developer (PL/SQL Expert) Remote, QC
Rona —Boucherville, QC
- Full-time
- Remote
- Oracle
- Databases
- SQL
Quick apply
Software Engineer with ETL and DataStage Development
Scotiabank —Toronto, ON
- Oracle
- DevOps
- SQL
- Profit sharing
Hyperion and Oracle Cloud EPM FDMEE Developer
Astral Solutions Group —Toronto, ON
- Full-time
- Hybrid work
- Oracle
- Project management
- Accounting
Senior Systems Developer/Integrator, Dynamics 365
City of Ottawa —Ottawa, ON
- $93,764.58–$114,097.62 a year
- Temporary
- Bilingual
- Oracle
- English
Manager, Campaign Development
Rakuten Kobo —Toronto, ON
- $77,837.00–$122,548.53 a year
- Full-time
- Hybrid work
- Bar
- Oracle
- Management
- Paid time off
- Vision care
Salesforce Technical Lead / Salesforce Developer
APPTOZA INC. —Toronto, ON
- $50–$55 an hour
- Oracle
- Salesforce
- Java
Quick apply
Lead Agentic AI Engineer – VP (Mississauga)
Citi —Mississauga, ON
- $120,800–$170,800 a year
- Full-time
- Azure
- Oracle
- Java
7d
Data Migration Specialist
Raise —Oakville, ON
- Contract
- Hybrid work
- Oracle
- Computer Science
- Engineering
Quick apply
6d
Senior Software Developer
Royal Bank of Canada —Toronto, ON
- Full-time
- Oracle
- Java
- Databases
GIS Developer
Spatial DNA —Toronto, ON
- $115,000–$155,000 a year
- Full-time
- Remote
- Azure
- Oracle
- Doctoral degree
- Profit sharing
- Disability insurance
Database Developer
Deluxe Media —Toronto, ON
- Full-time
- Oracle
- Computer Science
- Engineering
Senior Pension Software Testing Analyst
CAAT Pension Plan —Toronto, ON
- $96,800–$113,800 a year
- Full-time
- Azure
- Oracle
- Computer Science
- Wellness program
Quick apply
Javascript Developer
Gurus Solutions —Montréal, QC
- Full-time
- Hybrid work
- Oracle
- Computer Science
- Engineering
- Dental care
- Flexible schedule
Integration Specialist / Developer
Spatial DNA —Toronto, ON
- $80,000–$125,000 a year
- Full-time
- Azure
- Oracle
- Doctoral degree
- Profit sharing
- Disability insurance
Technology Lead (Oracle Customer Risk Rating)
TD Bank —Toronto, ON
- $114,000–$156,000 a year
- Full-time
- Hybrid work
- Oracle
- Computer Science
- DevOps
- Paid time off
10d
Programmer Systems Analyst II
University of British Columbia —Vancouver, BC
- $8,305.08–$12,952.33 a month
- Full-time
- Oracle
- ERP systems
- Java
Sr. IDMC Developer
Tata Consultancy Services —Toronto, ON
- $100,000–$120,000 a year
- Oracle
- Databases
- SQL
13d
Senior Technical Officer or Advisor
Canadian Security Intelligence Service —Ottawa, ON
- $112,746–$137,226 a year
- Remote
- Bilingual
- Azure
- Oracle
- Flexible schedule
GIS Developer
Geologic —Calgary, AB
- Full-time
- Computer science
- Oracle
- Computer Science
Quick apply
Technical Support Specialist - Weekend
Flexspring —Montréal, QC
- Weekends only
- Remote
- Spanish
- Oracle
- Computer Science
- Work from home
- Flexible schedule
Quick apply
1d

I want to receive the latest job alerts for etl developer/oracle

By signing in to your account, you agree to SimplyHired's Terms of Service and consent to our Cookie and Privacy Policy.

Explore jobs in more locations

etl developer/oracle jobs near

Senior Oracle Data Warehouse Developer (PL/SQL Expert) Remote, QC

Rona -
Boucherville, QC

Quick apply

Job details

Full-time

Qualifications

French
SFTP
Statistics
Power BI
System administration
Operating systems
Oracle
XML
Database development
UNIX
Databases
SQL
Scripting
Scrum
Agile
Linux
JSON
Informatica
PL/SQL

Full job description

We require all our head office associates to be proficient in French, spoken and written.

Position is REMOTE : The selected candidate must reside within 250 km of our BOUCHERVILLE (Qc) office.

At RONA, our employees let their passion blossom every day. Our teams are driven by the desire to help people bring their projects to life and are committed to making a difference in the communities we serve.

We operate or service corporate and affiliated dealer stores. With a distinctive product and service offering and complementary store formats ranging from neighbourhood hardware stores to big box stores, our RONA+, RONA and Dick’s Lumber banners are well equipped to help meet the needs of all DIYers and contractors.

You’ve got the talent? We’ve got the tools! Here, your work and ideas will contribute to building a flourishing organization. Your voice will always be heard and valued. You’ll find career opportunities that live up to your ambitions and be able to further develop your unique set of skills.

So, if you’re looking to do what you love, we could be a perfect match.

Department: Business Intelligence (BI) & Analytics

Industry: Retail

Environment: Hybrid (Oracle 19c On-Premise & Oracle Cloud Infrastructure - OCI)

1. Mission

As a key member of the BI team, you will be the guardian of our data warehouse’s performance and reliability. Your role is to transform raw data from multiple sources (POS systems, inventory, e-commerce, loyalty programs) into optimized data structures for strategic reporting and predictive analytics.

2. Key Responsibilities

Design and Development (PL/SQL Expertise)

Design, develop, and maintain complex ETL processes using exclusively PL/SQL (Packages, Procedures, Triggers, Analytical Functions).
Develop materialized views and specific data structures for visualization tools (e.g., MicroStrategy “Strategy”, Power BI).
Develop and automate scripts for data flow management, flat file manipulation (CSV, XML, JSON), and task scheduling.

Optimization and Performance

Perform advanced SQL Tuning to ensure that critical sales reports are available every morning before store opening.
Optimize CPU/Memory resource utilization in environments.

BI Data Architecture

Collaborate with architects to define star or snowflake schemas.
Implement Change Data Capture (CDC) mechanisms and secure file transfers (SFTP/SCP) between source systems and the Data Warehouse.
Ensure data integrity and quality through automated validation scripts.

3. Required Technical Skills

Languages: Expert mastery of PL/SQL (Collections, Bulk Collect, Forall, Dynamic SQL).
Database: Oracle 12c/19c and knowledge of OCI (Autonomous DB, Object Storage).
Operating System: Familiarity with Unix/Linux (navigation, permissions management, editing via UltraEdit, log analysis).
ETL Tools & : Expertise in native scripting. Previous knowledge of AppWorx & Informatica is an asset.
Performance: Proficiency in execution plans, statistics, indexing (B-Tree, Bitmap), and partitioning.
Reporting: Understanding of data consumption requirements for BI tools.

4. Desired Profile

Experience: Minimum 7 to 10 years in Oracle SQL/PL/SQL development, specializing in Data Warehousing.
Domain Knowledge: Previous experience in the Retail industry is a major asset (inventory management, margins, POS flows, supply chain).
Adaptability: Ability to maintain robust "Legacy" systems while driving future innovation toward the Cloud. Ability to pivot easily between light system administration (Linux) and pure database development.
Team Spirit: Experience working in an Agile (Scrum) environment, collaborating with Business Analysts to translate retail needs into technical solutions.

By joining the RONA family, you’ll enjoy many benefits, such as:

A childcare centre that can accommodate up to 78 children
A cafeteria with a delicious menu prepared by a dedicated chef, healthy options, as well as FARO Roasting Houses and Tim Hortons coffee stations
Electric car charging stations
A fitness centre, sports activities, and showers
Exclusive employee discounts, plus a 10% discount on store merchandise (at all RONA locations)
Benefits: retirement savings plan, annual bonuses, student incentive program, etc.
Career growth opportunities within the company
An inclusive and safe working environment
Promotion of work-life balance
An employer that’s involved in the community
And much more!

If selected for an interview, please advise our Human Resources team if you require accommodation during the interview and assessment process and we will work with you to meet your accessibility needs.

RONA is committed to encouraging diversity and inclusion. We are pleased to consider applications from all qualified candidates, regardless of race, colour, religion, sexual orientation, gender, nationality, age, disability, or any other protected status.

Quick apply

Refine Your Search

Senior Oracle Data Warehouse Developer (PL/SQL Expert) Remote, QC

Software Engineer with ETL and DataStage Development

Hyperion and Oracle Cloud EPM FDMEE Developer

Senior Systems Developer/Integrator, Dynamics 365

Manager, Campaign Development

Salesforce Technical Lead / Salesforce Developer

Lead Agentic AI Engineer – VP (Mississauga)

Data Migration Specialist

Senior Software Developer

GIS Developer

Database Developer

Senior Pension Software Testing Analyst

Javascript Developer

Integration Specialist / Developer

Technology Lead (Oracle Customer Risk Rating)

Programmer Systems Analyst II

Sr. IDMC Developer

Senior Technical Officer or Advisor

GIS Developer

Technical Support Specialist - Weekend

I want to receive the latest job alerts for etl developer/oracle

Related Searches

Explore jobs in more locations

Job seeker tools

Employer Tools

Browse

Stay Connected