Oracle Data Warehouse & ODI Engineer

Mandatory : Oracle Data Warehouse & ODI Engineer ( Only for Candidate in UAE & Qatar )

Responsibilities

• B.Tech./ B.E / MCA degree in Computer Science, Engineering or a related stream.
• Design Data warehouse using Oracle Database/Data warehouse
• Experience in designing and developing ODI mappings and troubleshooting ODI data/runtime issues.
• Strong experience in create/modify custom & existing ODI Knowledge Modules
• Strong knowledge of scheduling and setting dependencies using Oracle products.
• Experience with Change Data Capture technologies.
• Strong experience in data cleansing/analysis, unit/integration testing
• Good experience in ODI performance Tuning.
• Design and develop Extract, Transform, and Load (ETL) scripts
• Recommend standardizations or improvements for enterprise data warehouse and data marts
• Assist in preparing work tasks, task duration estimates, and schedules
• Perform routine database administration

Requirements

• 5-7 years minimum of Oracle Database Warehouse & ODI
• Must have some experience working with OBIA, OBIEE and Oracle R12
• Must have some demonstrated experience developing with TOAD, PL/SQL, SQL, load scripts, UNIX scripts, personalizations, workflows is a plus
• Must understand Oracle Applications table structure and APIs
• Experience with configuration management tools and processes
• Experience documenting systems
• Experience in supporting unit and integration testing
• Prior experience in implementing or supporting Oracle applications in a Federal environment is preferred
• Experience with shared service provider is a plus

What you've got?

You'll be familiar with agile practices and have a highly technical background, comfortable discussing detailed technical aspects of system design and implementation, whilst remaining business driven. With 5+ years of systems analysis, technical analysis or business analysis experience, you'll have an expansive toolkit of communication techniques to enable shared, deep understanding of financial and technical concepts by diverse stakeholders with varying backgrounds and needs. In addition, you will have exposure to financial systems or accounting knowledge.