Develop, test, and deploy ETL processes using Oracle Data Integrator (ODI) to support data integration and transformation requirements.
Design and implement data extraction, transformation, and load (ETL) procedures from multiple data sources, including relational databases, flat files, and APIs.
Optimize ODI mappings and scenarios to enhance performance and scalability of ETL processes.
Collaborate with data architects and analysts to define and implement ETL solutions for business intelligence and data warehousing projects.
Monitor, troubleshoot, and resolve data integration issues, ensuring data accuracy and integrity.
Develop technical documentation for all ODI processes, including mappings, scenarios, and workflows.
Participate in code reviews, ensuring adherence to best practices and coding standards.
Work with stakeholders to gather and define data integration requirements and ensure the proper implementation of business logic. Required Skills and Qualifications :
Proven experience in Oracle Data Integrator (ODI) development, with hands-on expertise in version [mention version].
Strong understanding of ETL concepts, including data modeling, transformations, and data quality.
Proficiency in SQL and PL/SQL, with the ability to write complex queries and stored procedures.
Familiarity with relational databases (Oracle, SQL Server, etc.) and data warehousing principles.
Experience with ODI components, including knowledge modules (KM), interfaces, packages, and scenarios.
Solid understanding of performance tuning, error handling, and troubleshooting in ODI.
Strong problem-solving and analytical skills, with attention to detail.