Job Title: Data Integration / ETL Developer (Oracle Cloud Data Integration)
Location: Offshore
Experience: 5+ Years
We are seeking an experienced Data Integration / ETL Developer responsible for designing and developing data ingestion and transformation pipelines to support enterprise analytics and reporting solutions. The ideal candidate will work with large datasets and build scalable ETL workflows that feed data into the analytics layer used for dashboards and business intelligence reports.
The role requires strong expertise in Oracle Cloud Data Integration (OCI Data Integration) or similar ETL platforms, along with advanced SQL and data transformation skills. The candidate will collaborate closely with BI developers and analysts to ensure that data structures and pipelines effectively support reporting and analytics requirements.
Key ResponsibilitiesDevelop and maintain data ingestion and transformation pipelines using Oracle Cloud Data Integration.
Design and implement ETL workflows to extract, transform, and load data into the analytics data layer.
Build and maintain data mappings and transformation logic to support business reporting requirements.
Support data preparation, cleansing, and dataset creation for dashboards and analytics solutions.
Troubleshoot and resolve data pipeline issues, failures, and data availability problems.
Collaborate with BI developers and analysts to ensure data structures support reporting and dashboard requirements.
Optimize ETL pipelines for performance, reliability, and scalability.
Ensure proper documentation of data pipelines, mappings, and transformation rules.
Follow data governance and best practices for data integration and quality management.
Hands-on experience with Oracle Cloud Data Integration (OCI DI) or similar ETL tools.
Strong proficiency in SQL and data transformation techniques.
Experience designing and developing ETL pipelines for analytics and reporting solutions.
Knowledge of data modelling concepts and data warehousing principles.
Ability to work with large datasets and complex data transformation logic.
Strong troubleshooting and problem-solving skills.
Good collaboration skills to work with BI developers, analysts, and data teams.
Experience with cloud-based data platforms and analytics environments.
Familiarity with data warehousing architectures such as star schema and dimensional modelling.
Exposure to Agile or iterative data engineering development practices.
Top Skills
What We Do
Datamatics Technologies (DMT) was established in Dubai. We specialize in providing onsite and offshore professional services, covering the full spectrum of Data Analytics and Data Science domains.
Our experience of working with diverse industry sectors such as Telecoms, Finance, Government and Manufacturing, across multiple regions enables us to engage and deliver for our clients with confidence.
We can offer our full portfolio of services through resource augmentation, managed services, both on T&M or fixed price financial arrangements. Through our end-to-end managed services offering we enable our clients to cut down costs, increase profitability and focus on value addition to their core business activities.
Our project and delivery management team are certified in Agile, PMI and ITIL to ensure the planning and execution are carried out using industry best practices.
We are working with our clients across Middle East and Africa Region.
