ODI Developer

As an experienced ODI Developer with expertise in Oracle Data Integrator (ODI) and Oracle database technologies, your role will involve designing, developing, optimizing, and supporting enterprise ETL solutions. Key Responsibilities: - Design, develop, modify, and maintain ODI 11g/12c mappings, packages, procedures, and load plans. - Develop and optimize ETL processes to ensure high performance and scalability. - Write complex SQL and PL/SQL code, including stored procedures, functions, indexes, and partitions. - Perform full and incremental data loads while ensuring data integrity and quality. - Conduct data profiling, validation, and reconciliation activities. - Troubleshoot and resolve data integration and ETL-related issues. - Collaborate with business and technical teams to understand data requirements. - Maintain technical documentation for ETL workflows, mappings, and data processes. - Support production deployments and ongoing maintenance activities. Required Skills: - Strong experience with Oracle Data Integrator (ODI) 11g/12c. - Expertise in Oracle SQL and PL/SQL development. - Hands-on experience in ETL design, development, and performance tuning. - Strong understanding of Oracle database concepts, including indexing and partitioning. - Experience with data warehousing and data integration projects. - Ability to analyze and resolve complex data and ETL issues. - Experience working in Agile/Scrum environments. Preferred Skills: - Exposure to large-scale data migration or data warehouse projects. - Experience with Oracle performance tuning and optimization techniques. As an experienced ODI Developer with expertise in Oracle Data Integrator (ODI) and Oracle database technologies, your role will involve designing, developing, optimizing, and supporting enterprise ETL solutions. Key Responsibilities: - Design, develop, modify, and maintain ODI 11g/12c mappings, packages, procedures, and load plans. - Develop and optimize ETL processes to ensure high performance and scalability. - Write complex SQL and PL/SQL code, including stored procedures, functions, indexes, and partitions. - Perform full and incremental data loads while ensuring data integrity and quality. - Conduct data profiling, validation, and reconciliation activities. - Troubleshoot and resolve data integration and ETL-related issues. - Collaborate with business and technical teams to understand data requirements. - Maintain technical documentation for ETL workflows, mappings, and data processes. - Support production deployments and ongoing maintenance activities. Required Skills: - Strong experience with Oracle Data Integrator (ODI) 11g/12c. - Expertise in Oracle SQL and PL/SQL development. - Hands-on experience in ETL design, development, and performance tuning. - Strong understanding of Oracle database concepts, including indexing and partitioning. - Experience with data warehousing and data integration projects. - Ability to analyze and resolve complex data and ETL issues. - Experience working in Agile/Scrum environments. Preferred Skills: - Exposure to large-scale data migration or data warehouse projects. - Experience with Oracle performance tuning and optimization techniques.