Logo
Diverse Lynx

ODI Consultant

Diverse Lynx, Seattle, Washington, us, 98127

Save Job

Job Role: - ODI Consultant

Location: - Seattle, WA - Onsite

Type of Hire - Long Term Contract

Job 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 interfaces by implementing best practices. Roles & Responsibilities:

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.

Diverse Lynx LLC is an Equal Employment Opportunity employer. All qualified applicants will receive due consideration for employment without any discrimination. All applicants will be evaluated solely on the basis of their ability, competence and their proven capability to perform the functions outlined in the corresponding role. We promote and support a diverse workforce across all levels in the company.