Senior Oracle Data Integrator (ODI) Developer

Connvertex Technologies Inc.

Job Location:

Boston, MA - USA

Monthly Salary: Not Disclosed

Posted on: 30+ days ago

Vacancies: 1 Vacancy

Job Summary

Tope Must have skills:

ETL/ELT
Oracle Data Integrator (ODI)
PL/SQL coding
7-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.

Tope Must have skills: ETL/ELT Oracle Data Integrator (ODI) PL/SQL coding 7-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...

Tope Must have skills:

ETL/ELT
Oracle Data Integrator (ODI)
PL/SQL coding
7-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

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.