Sr.ODI Developer

Location: Jersey City or Boston - LOCALS ONLY

Hybrid 3 days per week

Job Description

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 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 hrough 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