ODI Developer with Data Integration Expertise

- Develop ODI mappings, interfaces, packages, procedures, scenarios, topology configurations, ODI agent setups, and load plans to seamlessly integrate data from various enterprise systems - Create performant PL/SQL queries and procedures while managing data loading processes that adapt to the dynamic requirements of diverse applications - Design, develop, and sustain ETL/ELT pipelines utilizing Oracle Data Integrator (ODI) - Collaborate with cross-disciplinary teams including data engineers, DBAs, analysts, and business stakeholders to comprehend requirements and provide effective solutions - Monitor and resolve issues within RMJ jobs, ODI workflows, sessions, agents, and data pipelines running in Linux environments - Conduct root cause analysis for failures linked to ODI workflows, RMJ jobs, network issues, API integrations, and file transfers - Enhance ETL workflows to bolster reliability, performance, and scalability - Leverage scripting and automation tools for data processing and operational workflows - Operate within Linux/Unix environments, utilizing command-line tools and shell scripts for task automation and troubleshooting - Keep detailed documentation of data processes, configurations, and best practices - Engage in program specification reviews, source code assessments, and technical documentation evaluations, providing feedback as per team standards - Support the implementation of changes, enhancements, and new program developments - Undertake technical research, offer insights, build proofs of concept or prototypes, and contribute to the design of applications - Identify coding patterns and anti-patterns while ensuring adherence to best practices through code reviews - Address issues faced by business units in the production environment promptly, maintaining a supportive approach while conducting root cause analyses, technology evaluations, and performance optimizations