| ODI DIH Developer at Remote, Remote, USA |
| Email: [email protected] |
|
http://bit.ly/4ey8w48 https://jobs.nvoids.com/job_details.jsp?id=2269451&uid= ODI DIH Developer Mount Laurel NJ TCS Key Responsibilities: Design and develop ETL/ELT solutions using Oracle Data Integrator (ODI) and Data Integrator Hub (DIH). Optimize data extraction, transformation, and loading (ETL) processes for efficiency and scalability. Write and optimize complex PL/SQL scripts, stored procedures, functions, and packages. Perform Oracle performance tuning to enhance query execution and database efficiency. Implement data validation, error handling, and exception management in ODI/DIH processes. Collaborate with DBAs, data engineers, and business analysts to ensure data integrity and accuracy. Troubleshoot and resolve issues related to ETL jobs, database performance, and data inconsistencies. Work on real-time and batch data integration solutions for large-scale enterprise systems. Maintain technical documentation for ODI/DIH workflows, procedures, and best practices. Required Skills: Strong experience with Oracle Data Integrator (ODI) and Data Integrator Hub (DIH). Proficiency in Oracle PL/SQL, including stored procedures, triggers, views, and functions. Expertise in Oracle Performance Tuning, including query optimization, indexing, partitioning, and explain plans. Hands-on experience in ETL/ELT process design and implementation. Knowledge of data warehousing concepts, dimensional modeling, and data integration best practices. Experience with Oracle database technologies, including Oracle 12c/19c. Familiarity with job scheduling tools (Control-M, Autosys, or similar). Strong problem-solving skills with the ability to troubleshoot database and integration issues. -- Keywords: information technology procedural language New Jersey ODI DIH Developer [email protected] http://bit.ly/4ey8w48 https://jobs.nvoids.com/job_details.jsp?id=2269451&uid= |
| [email protected] View All |
| 10:45 PM 19-Mar-25 |