Senior Software Engineer – Pentaho ETL (PDI & Oracle)
Job Fit Check
Base Career helps you apply smarter for this job.
Key skills for this role
About the Role
Cinergie Digital seeks a Senior Software Engineer with strong Pentaho Enterprise Edition experience to design, build, and manage ETL workflows over Oracle and file-based data sources.
Key Skills for This Role
Responsibilities
- Design, develop, and manage ETL workflows using the Pentaho Data Integration (PDI) platform, Enterprise Edition.
- Implement complex data integration requirements including data cleansing, validation, and transformation across multiple sources.
- Integrate Pentaho with databases, flat files, XML, JSON, and APIs as both source and target systems.
- Support workflow failures end to end — debug, analyse root cause, and deliver lasting solutions.
- Analyse source to target data discrepancies, publish findings, and monitor data infrastructure for performance and reliability.
- Document data pipelines, processes, and best practices, and collaborate with IT and business teams.
Requirements
- 5 to 8 years of data integration / ETL engineering experience with strong, hands on Pentaho Enterprise Edition
- Expert use of Pentaho Data Integration tools — Spoon, Kitchen, and Pan
- Hands on Oracle database experience
- Advanced SQL and PL/SQL — writing, optimising, and debugging complex queries and stored procedures
- Proficiency in data modelling, schema design, and query optimisation
- Strong problem solving, root cause analysis, and documentation skills
Full Job Posting
Position Overview
- We are seeking a Senior Software Engineer with strong, hands on Pentaho Enterprise Edition experience to design, build, and manage ETL workflows over Oracle and file based data sources.
Key Responsibilities
- Design, develop, and manage ETL workflows using the Pentaho Data Integration (PDI) platform, Enterprise Edition.
- Implement complex data integration requirements including data cleansing, validation, and transformation across multiple sources.
- Integrate Pentaho with databases, flat files, XML, JSON, and APIs as both source and target systems.
- Support workflow failures end to end — debug, analyse root cause, and deliver lasting solutions.
- Analyse source to target data discrepancies, publish findings, and monitor data infrastructure for performance and reliability.
- Document data pipelines, processes, and best practices, and collaborate with IT and business teams on shared goals.
Required Skills & Experience
- 5 to 8 years of data integration / ETL engineering experience with strong, hands on Pentaho Enterprise Edition (develop and manage).
- Expert use of Pentaho Data Integration tools — Spoon, Kitchen, and Pan — to design and optimise transformations and jobs.
- Hands on Oracle database experience, handling flat files and databases as both source and target.
- Advanced SQL and PL/SQL — writing, optimising, and debugging complex queries and stored procedures, including bulk data processing.
- Proficiency in data modelling, schema design, and query optimisation, and in designing modular, reusable ETL components for large scale pipelines.
- Strong problem solving, root cause analysis, and documentation skills, with solid communication for cross functional collaboration.
Compensation & Benefits
- Salary: AED 10,000 – 13,000 per month.
- Benefits: Work visa, annual air tickets, medical insurance, gratuity, paid time off.
Location & Schedule
- Location: Client premises, Dubai, UAE (onsite).
Apply for this job in 1 click
Skip the repetitive application forms
Install the Base Career Chrome Extension and autofill job applications across major job boards with your profile.
Trusted by over 500,000 job seekers on Base Career
More from this employer
More jobs at Cinergie Digital
Senior Technical Engineer – Oracle Solution Architect
Dubai, UAE
Cinergie Digital is seeking a technically strong Oracle Solution Architect with 5-8 years of experience to design scalable solutions, integrate enterprise applications, and support Oracle EBS to Fusion modernization. The
Senior Technical Engineer – Sitecore Solution Assurance Lead
Dubai, UAE
Cinergie Digital is hiring a Senior Technical Engineer (Sitecore) to lead technical implementation and support of an enterprise Sitecore-based CMS in Dubai. The role requires 5-8 years of Sitecore/enterprise CMS engineer
Senior Technical Engineer (Sitecore)
Dubai, UAE
Cinergie Digital is hiring a Senior Technical Engineer (Sitecore) to lead technical implementation and support of an enterprise Sitecore-based CMS in Dubai. The role involves acting as primary technical counterpart to ve
Senior Software Engineer – Airline Pricing & ATPCO
Dubai, UAE
Cinergie Digital is hiring a Senior Software Engineer for airline pricing and revenue management systems. The role focuses on Python backend development, API design, and microservices, with strong ATPCO knowledge require
Project Manager
Dubai, UAE
Cinergie Digital is hiring a Project Manager to lead end-to-end delivery of complex technology projects in the aviation domain, blending Agile and Waterfall methodologies. The role requires PMP or PRINCE2 certification,
Business Analyst
Dubai, UAE
Cinergie Digital is hiring a Business Analyst to support an Order Management System product team in airline retailing and distribution. The role blends requirements work with API analysis, SQL investigation, and observab
Project Manager
Dubai, UAE
Cinergie Digital is hiring a Project Manager to plan, run, and govern IT and software development projects end-to-end in Dubai. The role requires 8+ years of PM experience, PMP certification, and prior hands-on software
Project Manager
Dubai, UAE
The employer is seeking an experienced Project Manager to lead enterprise IT projects and digital transformation initiatives in Dubai. The role requires managing project scope, timelines, budgets, risks, and stakeholder
Senior Technical Engineer – Oracle Solution Architect
Dubai, UAE
Senior Technical Engineer – Sitecore Solution Assurance Lead
Dubai, UAE
Senior Technical Engineer (Sitecore)
Dubai, UAE
Senior Software Engineer – Airline Pricing & ATPCO
Dubai, UAE
Project Manager
Dubai, UAE
Business Analyst
Dubai, UAE
Project Manager
Dubai, UAE
Project Manager
Dubai, UAE