Data Integration / ETL Developer (Oracle Cloud Data Integration) at Datamatics Technologies

Karachi Division, Sindh, Pakistan -

Full Time

Start Date

Immediate

Expiry Date

06 Jun, 26

Salary

0.0

Posted On

09 Mar, 26

Experience

5 year(s) or above

Remote Job

Yes

Telecommute

Yes

Sponsor Visa

Skills

Oracle Cloud Data Integration, ETL, Data Ingestion, Data Transformation, SQL, Data Pipelines, Analytics, Reporting, Data Mappings, Data Cleansing, Troubleshooting, Data Governance, Data Modelling, Data Warehousing, Performance Optimization, Scalability

Industry

IT Services and IT Consulting

Description

Job Title: Data Integration / ETL Developer (Oracle Cloud Data Integration) Location: Offshore Experience: 5+ Years Job Summary 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 Responsibilities Develop 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. Required Skills & Qualifications 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. Preferred Qualifications 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.

Responsibilities

The developer will be responsible for designing and building scalable ETL workflows using Oracle Cloud Data Integration to ingest and transform large datasets for enterprise analytics and reporting solutions. Key tasks include developing data mappings, supporting data preparation, and collaborating with BI teams to meet reporting needs.