Overview
Skills
Job Details
Location: Seattle, WA
Desirable Skills: Anaplan and Oracle 19C database optimization
Competencies: Oracle Data Integrator (ODI)
Role Description:
Develop ETL processes using Oracle Data Integrator.
Collaborate with data architects and analysis to translate data requirements into effective ODI solutions.
Optimize SQL queries and ODI processes for performance efficiency.
Work closely with cross-functional teams to integrate data across systems.
Understand the business requirements, translate to technical requirements
Monitor and maintain ODI jobs, workflows, patching and upgrades Interact with Business and IT team members to get clarifications on requirements implementation aspects.
Optimizing execution time of.
Essential Skills:
Strong experience in ODI loading, transforming data to Hyperion Modules through ODI technology (Essbase/Planning,HFM,FDMEE/Nifi and other downstream external systems) Odi expertise in maintaining multiple repositories in each environment User/
Roles maintenance in ODI security manager Nifi tool streaming expertise in datasets, rest based API calls and Web based authentication
Strong experience in designing, developing and Implementing data integration solutions using Oracle Data Integrator (ODI).
Experience in creating packages, load plans, scenarios, Logical and physical data stores,various technologies, performance tuning and optimization of ODI processes.
Excellent problem-solving and troubleshooting skills with a focus on data accuracy and integrity.
Strong experience in Knowledge modules, development and implementation of Business Intelligence and Data warehousing solutions using ETL tools.
Knowledge of Analysis Design, Customization, Implementation Maintenance of ODI.
Experience extracting data from various sources, including databases, file systems, and APIs.
Proficient in SQL, PL/SQL, and other relevant programming. Strong experience in ODI 11g/12c, Oracle and pathing/upgrades.
Participation in meetings with the stakeholders to follow up on data integration requests.