Oracle Data Integrator Technical Lead

• Demonstrated extensive IT experience relevant to enterprise data integration and delivery.
• Minimum 4+ years of hands-on Oracle Data Integrator experience.
• Strong working knowledge of Oracle Data Integrator 12c.
• Hands-on expertise in:
  • ODI Mappings
  • Packages and Procedures
  • Knowledge Modules
  • Load Plans and Scenarios
  • Scheduling and Job Monitoring
  • Variables and Sequences
  • Error Handling and Restartability
• Strong SQL skills and good understanding of relational database concepts.
• Good understanding of data warehousing, ETL/ELT concepts, source-to-target mappings, and data integration architecture.
• Hands-on experience with performance tuning and optimization of ODI jobs and SQL.
• Experience in data validation and reconciliation between source and target systems.
• Experience in ODI migration, release, and deployment activities across multiple environments.
• Proven experience across implementation, enhancement, and production support engagements.
• Strong troubleshooting and analytical skills.
• Good communication, technical documentation, and customer-interaction skills.

1. Design, develop, configure, and maintain Oracle Data Integrator (ODI) 12c solutions for enterprise data integration requirements.
2. Develop and maintain ODI mappings, packages, procedures, scenarios, variables, sequences, and load plans.
3. Configure and customize Knowledge Modules (KMs) based on integration and data-processing requirements.
4. Design and manage load plans, scheduling, dependencies, exception handling, and restart/recovery mechanisms.
5. Develop complex ETL/ELT workflows for extracting, transforming, and loading data across heterogeneous source and target systems.
6. Work extensively with SQL for data extraction, transformation, validation, reconciliation, and troublesho oting.
7. Support data warehouse and data integration solutions, including incremental and full-load processing.
8. Perform performance tuning and optimization of ODI mappings, SQL queries, load processes, and batch jobs.
9. Perform source-to-target data validation and reconciliation to ensure completeness and accuracy of data.
10. Handle ODI code migration and deployment across development, test, UAT, and production environments.
11. Participate in implementation, enhancement, testing, deployment, and production-support activities.
12. Conduct root-cause analysis and resolve ODI batch failures, data issues, performance problems, and production incidents.
13. Work closely with business users, database teams, application teams, and other integration stakeholders to understand and deliver requirements.
14. Prepare technical designs, mapping specifications, deployment documents, support documents, and operational procedures.

• Experience integrating ODI with Oracle Database and enterprise applications such as Oracle EBS.
• Good knowledge of PL/SQL and database objects such as procedures, functions, views, and materialized views.
• Experience working with large data volumes and optimizing batch-processing performance.
• Understanding of ODI repository architecture, Master Repository and Work Repository, and ODI Agent configuration.
• Exposure to Linux/Unix scripting and enterprise job-scheduling tools would be advantageous.
• Experience working in global or distributed delivery environments.

Qualifications

BACHELOR OF COMPUTER SCIENCE