What are the responsibilities and job description for the ODI Developer position at Centraprise?
Job Title :ODI Developer/Production Support analyst
Job Location : Bloomfield, CT-06042
Philadelphia, PA 19192
Austin , TX 78758
Plano, TX 75093, USA
Tampa, Florida, 33607
Raleigh, NC
Chattanooga, TN
Sunrise, FL
Minneapolis, MN
New York, NY
Phoenix city, Arizona (Onsite)
Job Type : Full-Time
Job Description:
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 Orace 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.
