Oracle Data Integrator Specialist; ODI Mastek

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.

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 `za`.

• 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.

• 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.

• 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.

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

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.