At KeyData Cyber, our vision is to be the North American leader in designing and delivering digital identity security strategies and solutions to protect our clients in their digital transformation initiatives.

KeyData Cyber is a Gartner-recognized leader in professional identity security services, specializing in:

Identity Governance & Administration (IGA)
Privileged Access Management (PAM)
Customer Identity & Access Management (CIAM)
Cloud Security Posture Management (CSPM)
Identity Threat Detection & Response (ITDR)

Come join us, you're key to our success!

We are currently looking for a ETL Engineer (Oracle Data Integration) to join KeyData Cyber's Delivery Services team! In this role, you will work with clients and technical teams to deliver customer requirements and be hands-on with all technical elements of implementation for Oracle Data Integration.

Title: ETL Engineer (Oracle Data Integration)

Location: United States

Employment Type: Contract till March 2026, Remote

Overview
We are seeking a skilled ETL Engineer to design, develop, and maintain data integration pipelines that will populate our Oracle-based customer identity database. The identity data model design is already completed, and the Oracle Database Engineer will implement the schema. This role will focus on sourcing, transforming, and loading the identity data from multiple systems into the Oracle database in a secure, accurate, and efficient manner.

Key Responsibilities

Data Integration & Pipeline Development
- Design and build ETL processes to bring data from multiple authoritative sources (HR, CRM, directories, etc.) into Oracle Database.
- Implement robust data ingestion workflows to support initial load, ongoing synchronization, and incremental updates.
- Develop transformation logic to align source data with the customer identity data model.
Data Quality & Governance
- Define and implement data validation, cleansing, and enrichment rules.
- Ensure data accuracy, consistency, and completeness across all integrated systems.
- Collaborate with data governance teams to apply metadata, lineage, and quality standards.
Performance & Optimization
- Tune ETL jobs and queries for efficiency and scalability.
- Monitor ETL workflows, troubleshoot issues, and ensure reliable and timely data delivery.
Collaboration & Support
- Work closely with the Oracle Database Engineer to ensure seamless integration with the implemented schema.
- Partner with IAM architects and business teams to define requirements for data flows.
- Document ETL processes, data mappings, and operational procedures.

Required Skills & Experience

Strong hands-on experience with ETL tools (e.g., Informatica, Talend, Oracle Data Integrator, SSIS, or equivalent).
Solid knowledge of Oracle Database (SQL, PL/SQL, schema integration).
Proven experience building ETL pipelines for enterprise-scale systems.
Strong understanding of data modeling, data mapping, and relational database principles.
Experience with data quality, validation, and error-handling frameworks.
Proficiency in SQL development and performance tuning for large datasets.
Proficiency with scheduling/orchestration tools (Control-M, Airflow, or equivalent).
Strong analytical, problem-solving, and communication skills.

Preferred Qualifications

Experience integrating identity-related data sources (e.g., Homegrown technology platforms, Mainframe, LDAP, CRM, ERP).
Knowledge of data privacy and security requirements (e.g., GDPR) related to ETL and data handling.
Exposure to cloud-based data integration platforms (AWS Glue, Azure Data Factory, OCI Data Integration).
Familiarity with real-time streaming or change data capture (CDC) for identity synchronization #LI-AS1

Why KeyData Cyber?

A Place Putting People First – Our team is our strongest asset. We have smart, hard-working, and talented team members. We support learning and development at all levels and encourage work-life balance as part of our key values.

A Place to Accelerate Your Career – We have the most digital identity solution deployments in Canada and we are in hyper-growth mode across North America. There are extensive opportunities to learn, develop, and advance in different areas of the business.

A Place to Share Your Perspective – We create a culture of respect, belonging, and empowerment for everyone by promoting fair treatment and full participation for all.

If you require accommodation due to a disability at any time during the recruitment and/or assessment process, please contact Talent Acquisition and we will make all reasonable efforts to accommodate your request.

Apply now to join the KeyData Cyber team!

KeyData Cyber

Latest Jobs

ETL Engineer (Oracle Data Integration)