Consultant | Oracle Analytics Cloud Service / FAW, ODI | Hyderabad | Oracle

Deloitte

5–8 yrs Hyderabad Full Time Work from office
Deloitte logo
Posted : yesterday
Actively hiring

Job description

Join our dynamic team as an Oracle Data Integrator (ODI) Consultant in Hyderabad. This role focuses on leveraging enterprise technology to drive functional excellence and innovation. We are seeking experienced professionals to design, develop, and maintain robust data integration solutions.

This is an exciting opportunity to work with cutting-edge Oracle technologies and contribute to impactful projects. You will be instrumental in building scalable ETL processes and ensuring high-quality data delivery for reporting and analytical needs.

Responsibilities

Key responsibilities include architecting and implementing ETL solutions using Oracle Data Integrator (ODI), developing complex ODI components such as Interfaces, Packages, and Load Plans, and performing source-to-target mapping and data transformation.

You will also be tasked with optimizing SQL queries and PL/SQL code, troubleshooting ETL failures and performance bottlenecks, and supporting data migration and production deployment activities. Collaboration with business analysts and cross-functional teams to meet business requirements is essential, alongside contributing to technical documentation and providing production support.

Qualifications

We are looking for candidates with 5-8 years of comprehensive experience in Oracle Data Integrator (ODI) development, specifically with ODI 11g or 12c. A strong command of Oracle SQL and PL/SQL, coupled with experience in Oracle Database 12c/19c or later, is crucial.

Essential skills include a solid understanding of ETL concepts, data integration, and data warehousing methodologies. Familiarity with ODI Knowledge Modules, Load Plans, Packages, and performance tuning is required. Experience with Unix/Linux shell scripting and version control tools like Git, within an Agile/Scrum framework, is also necessary. A Bachelor's degree in a relevant field is expected.

Essential Skills

Oracle Data Integrator (ODI)ODI 11gODI 12cOracle SQLPL/SQLOracle Database 12cOracle Database 19cETLData IntegrationData WarehousingODI Knowledge ModulesLoad PlansPackagesVariablesProceduresScenariosPerformance TuningData QualityData ValidationReconciliationUnix/Linux Shell ScriptingGitAgile/Scrum

Good to Have

Oracle Autonomous Data Warehouse (ADW)Oracle Cloud Infrastructure (OCI)Oracle Integration Cloud (OIC)Oracle Analytics Cloud (OAC)OBIEEOracle GoldenGateCloud Data IntegrationData Governance

Highlights

  • Actively hiring

More Details

RoleConsultant | Oracle Analytics Cloud Service / FAW, ODI | Hyderabad | Oracle
IndustryInformation Technology & Services
DepartmentData Engineering, Software Development
Employment TypeFull Time, Work from office

About the Company

Deloitte logo

Deloitte

Information Technology & Services

Consultant | Oracle Analytics Cloud Service / FAW, ODI | Hyderabad | Oracle at Deloitte | SkillMX | SkillMX