Data Integration / ETL Developer (Oracle Cloud Data Integration)
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.