Responsibilities: - Design, build, and support integrations using ODI to implement data and master data flows across multiple systems and technologies such as Oracle, Hyperion Planning, Essbase, DRM, and HFM - Provide technical expertise during requirements gathering and analysis, document technical designs and support manuals, and drive test and deployment processes - Identify, design, develop, and implement fixes and enhancements to existing production integrations Minimum qualifications: - BS/BA degree (In lieu of degree, 4 years of relevant work experience) - Strong scripting skills (Borne Shell, Python, etc.) - Strong relational database modeling (SQL Server, Oracle, MySQL) - 4+ years of hands-on ODI development experience (or 6 years of relevant experience with similar tools e.g. Informatica) - 4+ years Data Warehouse experience - Expertise using Topology, Knowledge Modules, Change Data Capture, Metadata, Web Services and SOA. - Expertise in Advanced PL/SQL - Expertise building ETL processes from scratch - Experience in performance tuning, partitioning strategies. Preferred qualifications: - BS/BA in Information Systems or Computer Science - Experience designing, building, and supporting data integrations that involve highly sensitive financial data - Exposure to OLAP/BI tools such as: Hyperion EPM suite and OBIEE - Good understanding of oracle database such as partitioning, materialized view, explain plan etc - Good understanding of protocols (e.g. SFTP, HTTPS, SOAP) and system integration methods (e.g. Web Service, REST service) - Experience in Oracle BI Application such as financial analytics
Key Skills: