What are the responsibilities and job description for the Oracle Data Integrator Developer position at Centraprise Corp?
Job Details
Position : Oracle Data Integrator Developer
Location : Bloomfield, CT / Austin, TX
Duration : Fulltime Permanent
Day 1 Onsite
Position Description:
Years of exp Required: 8-20 Years
Technical / Functional Skills:
- DWH support experience using ODI.
- Should have experience in developing ETL processes - ETL control tables, error logging, auditing etc. Should be able to implement reusability, parameterization, workflow design, etc.
- Knowledge of ODI Master and work repository
- Setting up topology, building objects in Designer, Monitoring Operator, different type of KMs, Agents etc
- Using ODI mappings, error handling, automation using ODI, Load plans, Migration of Objects
- Design and develop complex mappings, Process Flows and ETL scripts
- Must be well versed and hands-on in using and customizing Knowledge Modules (KM)
- Experience of performance tuning of mappings
- Ability to design ETL unit test cases and debug ETL Mappings
- Expertise in developing Load Plans, Scheduling Jobs
- Ability to design data quality and reconciliation framework using ODI
- Integrate ODI with multiple Source / Target
- Experience on Error recycling / management using ODI,PL/SQL
- Expertise in database development (SQL/ PLSQL) for PL/SQL based applications.
- Experience in SQL tuning and optimization using explain plan and Sql trace files.
- Strong knowledge of ELT/ETL concepts, design and coding
- Partitioning and Indexing strategy for optimal performance
Experience Required:
- Overall experience of 8 Years
- At least 2 to 3 Implementation projects using ODI
- Resource must have experience in Oracle EBS knowledge
- Should possess good consulting & communication skills.
- Must have ODI work experience
- Having OIC knowledge will have additional advantage.
Roles & Responsibilities:
- Setting up topology, building objects in Designer, Monitoring Operator, different type of KMs, Agents etc
- Using ODI mappings, error handling, automation using ODI, Load plans, Migration of Objects
- Design and develop complex mappings, Process Flows and ETL scripts
- Must be well versed and hands-on in using and customizing Knowledge Modules (KM)
- Experience of performance tuning of mappings
- Ability to design ETL unit test cases and debug ETL Mappings
- Expertise in developing Load Plans, Scheduling Jobs
- Ability to design data quality and reconciliation framework using ODI
- Integrate ODI with multiple Source / Target
- Experience on Error recycling / management using ODI,PL/SQL
- Expertise in database development (SQL/ PLSQL) for PL/SQL based applications.
- Experience in SQL tuning and optimization using explain plan and Sql trace files.
- Strong knowledge of ELT/ETL concepts, design and coding
- Partitioning and Indexing strategy for optimal performance
Generic Managerial Skills:
- Maintain and establish effective working relationships with co-workers and other developers.
- Excellent interpersonal, communication and organizational skills are essential to perform the tasks.
- Good communication with team and customer
- Perform a wide variety of duties and responsibilities with accuracy
Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.
