| Company | Deloitte |
| Job Title | Consultant – Oracle Analytics Cloud Service / FAW, ODI |
| Job Requisition ID | 112909 |
| Location | Hyderabad |
| Entity | Deloitte Touche Tohmatsu India LLP |
| Practice | Enterprise Technology & Performance (ET&P) |
| Role | Oracle Data Integrator (ODI) Developer |
| Experience | 5–8 Years hands-on ODI development |
| Qualification | Bachelor’s Degree in Computer Science, IT, Engineering or related field |
| ODI | ODI 11g / ODI 12c |
| ETL | Design, develop and maintain enterprise ETL and data integration solutions |
| ODI Components | Interfaces/Mappings, Packages, Procedures, Variables, Knowledge Modules, Load Plans and Scenarios |
| Data Integration | Build workflows for enterprise data warehouses and reporting solutions |
| Data Mapping | Source-to-target mapping, data transformation and validation |
| SQL | Strong Oracle SQL skills |
| PL/SQL | Packages, procedures, functions and triggers |
| Oracle Database | Oracle Database 12c/19c or later |
| Knowledge Modules | LKM, IKM, CKM and JKM |
| Performance Tuning | Optimize ODI mappings, SQL queries and database performance |
| Data Quality | Data validation, reconciliation and quality management |
| Troubleshooting | Resolve ETL failures, performance issues and data quality problems |
| Data Migration | Support migration, reconciliation and production deployments |
| Production Support | Incident resolution and root cause analysis |
| Shell Scripting | Unix/Linux shell scripting |
| Version Control | Git or other version control tools |
| Agile | Agile/Scrum development environment |
| Documentation | Technical design documents, deployment guides and operational documentation |
| Collaboration | Work with business analysts, architects and cross-functional teams |
| Cloud | Oracle Autonomous Data Warehouse (ADW) and Oracle Cloud Infrastructure (OCI) |
| Oracle Integration | Oracle Integration Cloud (OIC) |
| Analytics | Oracle Analytics Cloud (OAC) / OBIEE |
| Real-Time Integration | Oracle GoldenGate / ODI |
| Data Governance | Familiarity with data governance and data quality tools |
| Certification | Oracle ODI certification preferred |
| Soft Skills | Analytical thinking, problem-solving, communication and stakeholder management |
| Key Skills | Oracle ODI, SQL, PL/SQL, ETL, Data Warehousing, Oracle Database, Data Integration |
| Ideal Candidate | ODI Developer with 5–8 years of hands-on experience, strong Oracle SQL/PL-SQL expertise and experience in enterprise ETL, data warehousing and ODI performance optimization |
