| Oracle Data Integrator|| Remote at Oracle, Arizona, USA |
| Email: [email protected] |
|
From: Ritika Arora, GVR Infotek [email protected] Reply to: [email protected] Job Description - Job Title: Oracle Data Integrator Duration: 6 Months Location: REMOTE Key Responsibilities: Develop and maintain ETL and Integration workflows using ODI, leveraging its declarative design approach and modular Knowledge Modules (KMs) to simplify integration tasks. Design scalable, efficient, and secure data pipelines to support project requirements, ensuring compliance with enterprise data governance policies. Implement and configure middleware solutions to facilitate seamless communication between Oracle systems, SQL Server, and GCP. Optimize middleware configurations and troubleshoot issues to maintain high availability and reliability. Perform in-depth analysis of source and target systems to define data mappings and complex transformation rules. Utilize ODIs mapping components and transformation logic to automate and validate data workflows. Work with database administrators, developers, and business analysts to gather and refine data integration requirements. Create detailed technical documentation of ETL workflows, middleware configurations, and integration processes for ongoing support and scalability. Monitor ODI agents, repositories, and job executions to identify and address performance bottlenecks. Implement best practices for ELT design, including efficient use of database indexes, partitioning, and parallel processing. Qualifications: Bachelors degree in Computer Science, Information Systems, or a related field. Proven experience as an ODI Consultant or in a similar role focusing on ETL and middleware. Expertise in Oracle Data Integrator (ODI), including ODI Studio, Agent, and repository management. Strong understanding of ELT architecture and Knowledge Modules (KM) customization. Hands-on experience with SQL Server and GCP data services, such as BigQuery and Dataflow. Advanced SQL and PL/SQL skills for complex data manipulation and transformation. Familiarity with data modeling, data warehousing concepts, and cloud-based data integration solutions. Experience with middleware tools and integration platforms. Preferred Skills: Experience with Loyalty applications, homegrown or out-of-box software. Knowledge of additional GCP services such as Cloud Storage, Pub/Sub, and Data Catalog. Experience with other ETL tools (e.g., Informatica, Talend) and cloud data platforms. Relevant certifications in ODI, Oracle Databases, or GCP are a plus. Thanks & Regards, Ritika Arora Technical Recruiter | GVR Infotek LLC : 13573 Tabasco Cat Trail, Frisco, TX 75035 Email: [email protected] Keywords: procedural language Texas Oracle Data Integrator|| Remote [email protected] |
| [email protected] View All |
| 01:33 AM 13-Dec-24 |