ODI Data Integration Specialist | Oracle ADW & ETL

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

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.