Oracle Data Integrator Specialist (ODI) | Mastek | Manama, Bahrain

Tech Junction Ltd; Manama; On-site; BHD 18,000 - 30,000; Full time

Job summary

Tech Junction Ltd. seeks an Oracle Data Integrator Specialist (ODI) in Manama, Bahrain, to design, develop, and maintain complex ETL/ELT pipelines and data warehousing solutions. You will work with ODI, PL/SQL, and OTBI, delivering robust data integration and BI support in enterprise environments.

The role requires at least 5 years of ODI experience, strong PL/SQL skills, and expertise in star/snowflake schema modeling, with on-site residency in Bahrain. Immediate resume submission is encouraged.

Qualifications

• Bachelor’s degree in Computer Science, Information Technology, Software Engineering, or a related discipline.
• Minimum of 5+ years of professional database development and ETL engineering experience.
• Hands-on ODI development, configuration, and support.
• Strong PL/SQL programming and advanced querying.
• Experience designing Star and Snowflake schemas for enterprise data warehousing.
• Experience in ETL/ELT design, development, and troubleshooting.
• Familiarity with OTBI reporting.
• On-site residency/authorization in Manama, Bahrain.

Responsibilities

• Design, develop, test, and support ETL/ELT data pipelines using ODI.
• Administer and optimize ADW/AIDP environments and cloud data stores.
• Write optimized PL/SQL packages, procedures, triggers, and queries.
• Architect dimensional data models with Star and Snowflake schemas.
• Support OTBI and analytics tools; troubleshoot bottlenecks.
• Collaborate with business analysts, DBAs, and reporting teams.
• Ensure data governance, security baselines, and backups.
• Create technical specs, data mappings, and runbooks.
• Participate in agile sprints, code reviews, and migrations.

Skills

PL/SQL programming

Analytical problem-solving

Cross-functional collaboration

Data modeling

ETL/ELT design

Education

Bachelor’s degree in Computer Science / IT / Software Engineering

Tools

Oracle Data Integrator (ODI)

OTBI

Oracle Autonomous Data Warehouse (ADW/AIDP)

Oracle Cloud Infrastructure (OCI)

Job description

Position Summary

We are seeking an exceptionally skilled and experienced Oracle Data Integrator Specialist (ODI) to join our technology team on a permanent basis in Manama, Bahrain, via Mastek. In this critical data engineering and integration role, you will be responsible for designing, developing, and supporting complex ETL/ELT pipelines, data warehousing architectures, and reporting solutions. The ideal candidate will bring a minimum of 5 years of professional experience in Oracle Autonomous Data Warehouse environments, hands‑on ODI development expertise, strong PL/SQL programming skills, and deep familiarity with dimensional data modeling (Star and Snowflake schemas). If you possess a distinguished background in enterprise Oracle data engineering, we invite you to apply.

Detailed Job Description

As an Oracle Data Integrator Specialist (ODI) in Manama, Bahrain, you will serve as the principal technical authority responsible for building and optimizing enterprise data integration frameworks and data warehouses. Your daily responsibilities will encompass designing and implementing robust ETL/ELT data pipelines using Oracle Data Integrator (ODI), writing advanced PL/SQL scripts, constructing Star and Snowflake database schemas, and supporting Oracle Autonomous Data Warehouse (ADW/AIDP) platforms. You will also collaborate with BI reporting teams utilizing tools like Oracle Transactional Business Intelligence (OTBI), troubleshoot data integration bottlenecks, and ensure data integrity across enterprise applications. Candidates are required to submit their updated resume via email to Mohammed Zahoor at `[e-mail]`.

Key Responsibilities

• Design, develop, test, and support robust ETL/ELT data pipelines using Oracle Data Integrator (ODI).
• Administer and optimize Oracle Autonomous Data Warehouse (ADW/AIDP) environments and cloud data stores.
• Write highly optimized PL/SQL packages, stored procedures, triggers, and complex database queries.
• Architect and implement dimensional data models incorporating Star and Snowflake schema design principles.
• Support and configure reporting solutions and analytics tools including Oracle Transactional Business Intelligence (OTBI).
• Troubleshoot data integration errors, performance bottlenecks, and pipeline scheduling failures.
• Collaborate proactively with business analysts, database administrators, and enterprise reporting teams.
• Ensure strict adherence to data governance, security baselines, and database backup standards.
• Author comprehensive technical specifications, data mapping documents, and operational runbooks.
• Participate in agile sprint planning, code reviews, and cross-functional technical migrations.

Required Qualifications & Skills

• Bachelor’s degree in Computer Science, Information Technology, Software Engineering, or a related discipline.
• Minimum of 5+ years of professional database development and ETL engineering experience.
• Hands‑on practical expertise with Oracle Data Integrator (ODI) development, configuration, and support.
• Strong programming proficiency in PL/SQL and advanced database querying.
• Proven experience designing Star and Snowflake database schemas for enterprise data warehousing.
• Experience in ETL/ELT design, development, and advanced troubleshooting.
• Working familiarity with reporting and analytics tools such as OTBI.
• Outstanding analytical problem‑solving, performance tuning, and cross‑functional communication capabilities.
• Mandatory residency/work authorization: Ability to operate on‑site in Manama, Bahrain.

Nice-to-Have Skills

• Professional certifications such as Oracle Autonomous Database Certified Specialist or Oracle Data Integrator Certified Implementation Expert.
• Prior experience with Oracle Cloud Infrastructure (OCI) database services and autonomous data warehouse management.
• Familiarity with modern data pipeline orchestration and cloud data migration tools.
• Immediate availability for professional mobilization in Bahrain.

Application Information

• Salary/Rate: Competitive market rate
• Deadline: Immediate
• Notice Period: 30 to 60 Days
• Contract Duration: Permanent (Manama, Bahrain)

Recruitment Pro Tip

When applying for this Oracle Data Integrator Specialist position with Mastek, ensure your resume explicitly highlights your hands‑on ODI development projects, your PL/SQL tuning capabilities, and your Oracle Autonomous Data Warehouse experience.