Job Description Overview
  • Skill: ODI 12G, ETL Workflow Design, ETL Process Development, Data Integration, ODI Interfaces, ODI Procedures, ODI Packages, Batch Processing, Real-time Data Processing, Data Accuracy, Data Integrity, Data Security, Data Quality Checks, Data Validation, Oracle Databases (Oracle 11g/12c), SQL, Complex SQL Queries, Database Procedures, Data Transformation, Data Migration, Version Control (Git, SVN), Collaborative Environment, Agile Development, Data Modeling, Troubleshooting, Problem-Solving, Communication Skills, Collaboration Skills.
  • Location: Remote
  • Experience: 8

We are seeking an experienced ODI (Oracle Data Integrator) Developer to join our team and take ownership of designing and implementing data integration solutions. The ideal candidate will have at least 5 years of hands-on experience working with ODI, building ETL processes, and managing data pipelines. If you're passionate about working with Oracle's integration technologies and want to make a significant impact in a dynamic, fast-paced environment, we’d love to hear from you!

Key Responsibilities:

  • Design, develop, and maintain ETL workflows using Oracle Data Integrator (ODI) to extract, transform, and load data from various source systems to target databases.
  • Build and optimize ODI interfacesprocedures, and packages for seamless data integration.
  • Collaborate with business and technical teams to understand data requirements and ensure solutions meet data governance and business needs.
  • Develop and maintain data integration jobs for batch processing and real-time data processing workflows.
  • Troubleshoot, optimize, and monitor ODI jobs and processes to ensure performance, scalability, and reliability.
  • Ensure data accuracy, integrity, and security across all data integrations and pipelines.
  • Implement and manage data quality checks and validations to ensure high-quality data is transferred to target systems.
  • Document ETL processes, designs, and coding standards to ensure maintainability and knowledge sharing.
  • Work closely with database administrators (DBAs) to ensure efficient performance and resource management in target systems.
  • Participate in code reviews and contribute to best practices in the development and integration processes.

Required Skills & Qualifications:

  • 5+ years of experience in data integration and ETL development using Oracle Data Integrator (ODI).
  • Solid knowledge of Oracle databases (Oracle 11g/12c, SQL) and proficiency in writing complex SQL queries and database procedures.
  • Experience working with data transformation and data migration projects using ODI.
  • Hands-on experience in building and deploying ODI procedurespackages, and integrations.
  • Strong understanding of ETL concepts, data integration, and data warehousing processes.
  • Familiarity with version control systems (e.g., GitSVN) and the ability to work in a collaborative, agile environment.
  • Knowledge of data modeling concepts and practices.
  • Excellent problem-solving skills and ability to troubleshoot complex ETL issues.
  • Strong communication and collaboration skills with the ability to work closely with both technical and non-technical teams.