JOB DESCRIPTION:
IOTE Technologies, We are currently seeking a highly skilled Oracle Data Integrator with a minimum of 4+ years of experience to join our esteemed client’s team. The position is based in India, and As part of this role, you will be involved in cutting-edge projects, offering a stimulating professional environment.
Position : Oracle Data Integrator [ODI]
Experience : Minimum 4+ years
Location : Remote
Start Date : Immediate
Mode of Work : Contract
Responsibilities:
- Requirement gathering and design of enhancements by interacting with the business users.
- Expertise in working with Oracle Data Integrator 11g/12c.
- Design and develop data ingestion (ETL) and reporting component using ODI, OBI & OAC.
- Optimize performance of ETL jobs and Dashboards on OBIEE & OAC.
- Implement ETL & Reporting enhancement & Troubleshoot ETL (on ODI) production failure.
- Fix ETL & Reporting bugs & Handle issues reported by User.
- Experience in architecting data-related solutions, developing data warehouses, developing ELT/ETL jobs, Performance tuning and identifying bottlenecks in the process flow.
- Configured and setup ODI, Master Repository, Work Repository, Projects, Models, Sources, Targets, Packages, Knowledge Modules, Interfaces, Scenarios, Load plans, and Metadata.
- Experience using Dimensional Data modelling, Star Join Schema modelling, Snow-Flake modelling experience using Normalization, Fact and Dimensions Tables, Physical and Logical Data Modelling.
- Monitor Production Job and Elicit & understand Users requirement.
- Strong experience in migration projects.
- Experience in data warehouse design, creating star schemas and in writing PL/SQL, SQL.
- Experience in BI Publisher, Interactive Dashboards and in creating multiple reporting views like Tiles, Gauge view, pivot tables, charts, and prompts in the OBIEE web catalogue and reporting.
- Ability to develop and maintain data warehouse mappings.
- Ability to develop ETL solutions and automate data loading processes.
Desired Skills:
- 6+ years of BI experience.
- 4+ years of experience on ODI, OBI, OAC & SQL (minimum 3+ year experience on each of the tool mentioned).
- Good understanding of Oracle BI apps.
Qualifications:
- Bachelor’s degree / Master Degree in Computer Science, Information Technology, or a related field.
Why Join Us?
- Collaborate with cutting-edge technologies.
- Contribute to impactful projects in the Middle East.
- Exciting opportunities for professional growth and development.
- Competitive compensation package.
Apply Now!
Apply now to become an integral part of our innovative team at IOTE Technologies as a Oracle Data Integrator.
Send your updated resume and a brief cover letter to hr@iotetech.com or sbperuka@iotetech.com to join our dynamic team!