Oracle Data Integrator Developer (ODI)

Position: Oracle Data Integrator Developer (ODI)

Location: Boston MA / Jersey City NJ (Hybrid)

Duration: Long term contract

Tope Must haves:

• ETL/ELT
• Oracle Data Integrator (ODI)
• PL/SQL coding
• 10 years experience
• Knowledge on how to be an admin side of things (not day to day but is able to do that)
• Scripting Python & Unix Scripting

Role Overview:

Seeking a highly skilled and experienced Sr. ODI Developer to join our Private Banking Systems team. The ideal candidate will possess expertise in a range of technologies including ODI (Oracle Data Integrator) Oracle Data Warehouse Linux Python scripting and have a deep understanding of the Banking domain is a big plus. As a ODI Data Engineer you will play a pivotal role in designing developing and maintaining data solutions.

Key Responsibilities:

• Build ODI mappings/interfaces packages procedures scenarios topology configuration ODI Agent and load plans to integrate data from multiple enterprise systems.
• Expertise in building Pl/SQL queries procedures data loading process ensuring high-performance and scalability to meet the evolving data needs of the various applications.
• Design develop and maintain ETL/ELT pipelines using Oracle Data Integrator (ODI).
• Collaborate effectively with cross-functional teams including other data engineers DBA group analysts and business stakeholders to understand data requirements and deliver solutions.
• Monitor and troubleshoot RMJ jobs ODI workflows sessions agents and data pipelines on Linux environments.
• Perform root cause analysis for failures related to ODI workflows RMJ jobs network connectivity API integrations and file transfers.
• Optimize ETL workflows to improve reliability performance and scalability.
• Use scripting and automation tools to support data processing and operational workflows.
• Work in Linux/Unix environments using command-line tools and shell scripts for job automation and troubleshooting.
• Maintain comprehensive documentation of data processes configurations and best practices.
• Participate in walk-throughs which review program specifications source code and all technical supporting documentation including screens/reports.
• Provide feedback in accordance with team standards and guidelines.
• Participate in implementation of changes enhancements and newly developed programs.
• Conduct technical research and provide recommendations develop proofs of concept or prototypes contributing to technical design of applications.
• Helping to identify coding patterns and anti-patterns and enforce implementation of the patterns through code reviews.
• Quickly resolving issues encountered by business lines in the production environment maintaining a helpful high touch approach to working with business users performing root cause analysis technology evaluation and performance tuning.