ODI Developer
Company Description
About BCforward
BCforward began as an IT business solutions and staffing firm. Founded in 1998, BCforward has grown with our customers’ needs into a full service personnel solutions organization. BCforward’s headquarters are in Indianapolis, Indiana and also operates delivery centers in 17 locations in North America as well as Hyderabad, India and Puerto Rico. We are currently the largest consulting firm and largest MBE certified firm headquartered in Indiana. With 14+ years of uninterrupted growth, the addition of two brands (Stafforward and PMforward) and a team of more than 1400 resources our teams deliver services for multiple industries from both public and private sectors. BCforward’s team of dedicated staffing professionals has placed thousands of talented people over the past decade, with retention rates that are consistently higher than the industry average.
Job Description
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.
THANKS AND REGARDS,
ASMA KHAN SURI
Additional Information
Must be able to pass a background and drug screen