Denodo Developer

Role Overview

We are seeking a Denodo Architect to design and implement the data virtualization and semantic access layer as part of our on-premise Data Lakehouse (DLH) program. The architect will play a critical role in integrating Denodo with Cloudera (HDFS, Spark, Kafka), Teradata, Informatica, and multiple source banking systems, enabling unified access, performance optimization, and governance across the medallion architecture (Bronze, Silver, Gold layers).

Key Responsibilities

Architecture & Design

Define Denodo architecture for data virtualization, caching, security, and query optimization across heterogeneous sources.

Enable semantic layer & data abstraction to support Medallion (Bronze/Silver/Gold) architecture.

Design high-performance data federation strategies with Cloudera (HDFS, Hive, Impala), Teradata, and real-time Kafka streams.

Integration & Migration

Work with Informatica teams to expose curated Silver-layer datasets via Denodo for downstream consumption.

Ensure smooth coexistence between legacy systems and new lakehouse through virtualization during migration.

Design APIs & services for consuming Gold-layer data products through Denodo.

Performance & Security

Implement caching, query acceleration, and workload management strategies.

Define row-level and column-level security, masking, and role-based access controls aligned with bank ISM requirements.

Monitor and tune Denodo queries for low latency and high concurrency workloads.

Collaboration & Governance

Partner with Cloudera, Teradata, and Informatica architects to align virtualization strategy.

Work with Data Governance team to enforce data lineage, metadata, and catalog integration.

Provide guidance to ETL, BI, and reporting teams (Power BI, downstream analytics) on Denodo consumption best practices.

Required Skills & Experience:

10+ years of data architecture experience, with 5+ years in Denodo (v8.x or above preferred).

Strong expertise in data virtualization, federation, caching, and query optimization.

Hands-on experience integrating Denodo with:

• Cloudera (Hive, Impala, HDFS, Kafka, Spark)
• Teradata
• Informatica (ETL pipelines, curated data sets)
• Oracle GoldenGate / CDC streams
• Knowledge of banking source systems and data domains (LOS, CLOS, Payments, Trade, Murex, Swift, etc.) is a plus.
• Familiarity with data governance, security (LDAP/AD, Kerberos, SSL, OAuth, masking), and compliance.
• Experience in API design, REST/SOAP services, and BI integration (Power BI, Tableau, MicroStrategy).

Nice to Have:

• Experience with Medallion architecture implementations in hybrid/on-prem ecosystems.
• Exposure to data lakehouse migration programs with co-existence strategies.

Job Types: Full-time, Contract
Contract length: 6 months

Pay: ﷼63.00 - ﷼100.00 per hour

Expected hours: 40 per week