Contract ODI ETL Developer - Hybrid Onsite in Boston, MA OR Jersey City, NJ - US
Yoh, A Day & Zimmermann Company, Jersey City, NJ, United States
Overview
Contract ODI Developer – Hybrid Onsite in Jersey City, NJ or Boston, MA. USC or GC only (No Visas). Location: Boston, MA or Jersey City, NJ. Hybrid: 3 days on site. Potential convert: Yes, USC/GC only, no exceptions. WILL NOT SPONSOR.
Key Responsibilities
Build ODI mappings/interfaces, packages, procedures, scenarios, topology configuration, ODI Agent and load plans to integrate data from multiple enterprise systems.
Develop and optimize PL/SQL queries, procedures, and data loading processes to ensure high performance and scalability.
Design, develop, and maintain ETL/ELT pipelines using Oracle Data Integrator (ODI).
Collaborate with cross-functional teams 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, network connectivity, API integrations, and file transfers.
Optimize ETL workflows for reliability, performance, and scalability.
Use scripting and automation tools to support data processing and operational workflows.
Work in Linux/Unix environments with command-line tools and shell scripts for automation and troubleshooting.
Maintain comprehensive documentation of data processes, configurations, and best practices.
Participate in reviews of program specifications, source code, and technical supporting documentation; provide feedback per team standards.
Support implementation of changes, enhancements, and newly developed programs.
Conduct technical research, develop proofs of concept, and contribute to technical design of applications.
Identify coding patterns and anti-patterns and enforce them through code reviews.
Respond to production issues with a proactive, high‑touch approach to business users, including root cause analysis, technology evaluation, and performance tuning.
Qualifications
Degree in Computer Science, Engineering or related technical area.
7+ years of hands-on experience in ODI, Oracle Data Warehouse, Oracle PL/SQL, Linux, Python scripting, and ODI admin module (ODI Agent setup, logs configuration, certificate installation).
Experience building PL/SQL queries for Oracle Server (stored procedures, functions) and understanding of basic data modeling principles.
Excellent collaboration and communication skills, particularly in high-stress situations.
Experience with Python scripting and Linux scripting; knowledge of API, IP/ports, SFTP/FTP connectivity.
Strong development practices: unit testing, CI/CD, refactoring, clean code.
Experience with Bitbucket/GIT source control management.
Problem-solving skills with the ability to identify risks and issues and address them.
Ability to interpret and troubleshoot applications using logs.
Proactive approach and good communication skills; experience with agile methodologies (Scrum, Kanban) and Jira.
Nice to Have
Private Banking domain experience; financial services industry background.
Experience with FIS AddVantage, CRD, CRM Pivotal.
Experience with Apache Airflow for workflow orchestration.
Knowledge of dbt (Data Build Tool) for modern data transformations.
Exposure to cloud data platforms or hybrid data architectures.
Key Competencies
Strong analytical and problem-solving skills.
Ability to work with large-scale enterprise data environments.
Excellent collaboration and communication skills.
Ability to manage multiple priorities in a fast-paced environment.
Commitment to continuous learning and technology innovation.
Estimated Rates
Estimated Min Rate : $55.00
Estimated Max Rate : $72.00
What’s In It for You?
Yoh is an equal opportunity employer. Benefits eligibility is in accordance with applicable laws and client requirements. Benefits include: Medical, Prescription, Dental & Vision; Health Savings Account (HSA); Life & Disability Insurance; MetLife Voluntary Benefits; Employee Assistance Program (EAP); 401K; Direct Deposit & weekly ePayroll; Referral Bonus Programs; Certification and training opportunities.
Notes
Note: Any pay ranges displayed are estimations. Actual pay is determined by experience and qualifications. All qualified applicants are welcome to apply. Yoh, a Day & Zimmermann company, is an Equal Opportunity Employer. For accommodations in the application process, visit https://www.yoh.com/applicants-with-disabilities.
#J-18808-Ljbffr
Contract ODI Developer – Hybrid Onsite in Jersey City, NJ or Boston, MA. USC or GC only (No Visas). Location: Boston, MA or Jersey City, NJ. Hybrid: 3 days on site. Potential convert: Yes, USC/GC only, no exceptions. WILL NOT SPONSOR.
Key Responsibilities
Build ODI mappings/interfaces, packages, procedures, scenarios, topology configuration, ODI Agent and load plans to integrate data from multiple enterprise systems.
Develop and optimize PL/SQL queries, procedures, and data loading processes to ensure high performance and scalability.
Design, develop, and maintain ETL/ELT pipelines using Oracle Data Integrator (ODI).
Collaborate with cross-functional teams 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, network connectivity, API integrations, and file transfers.
Optimize ETL workflows for reliability, performance, and scalability.
Use scripting and automation tools to support data processing and operational workflows.
Work in Linux/Unix environments with command-line tools and shell scripts for automation and troubleshooting.
Maintain comprehensive documentation of data processes, configurations, and best practices.
Participate in reviews of program specifications, source code, and technical supporting documentation; provide feedback per team standards.
Support implementation of changes, enhancements, and newly developed programs.
Conduct technical research, develop proofs of concept, and contribute to technical design of applications.
Identify coding patterns and anti-patterns and enforce them through code reviews.
Respond to production issues with a proactive, high‑touch approach to business users, including root cause analysis, technology evaluation, and performance tuning.
Qualifications
Degree in Computer Science, Engineering or related technical area.
7+ years of hands-on experience in ODI, Oracle Data Warehouse, Oracle PL/SQL, Linux, Python scripting, and ODI admin module (ODI Agent setup, logs configuration, certificate installation).
Experience building PL/SQL queries for Oracle Server (stored procedures, functions) and understanding of basic data modeling principles.
Excellent collaboration and communication skills, particularly in high-stress situations.
Experience with Python scripting and Linux scripting; knowledge of API, IP/ports, SFTP/FTP connectivity.
Strong development practices: unit testing, CI/CD, refactoring, clean code.
Experience with Bitbucket/GIT source control management.
Problem-solving skills with the ability to identify risks and issues and address them.
Ability to interpret and troubleshoot applications using logs.
Proactive approach and good communication skills; experience with agile methodologies (Scrum, Kanban) and Jira.
Nice to Have
Private Banking domain experience; financial services industry background.
Experience with FIS AddVantage, CRD, CRM Pivotal.
Experience with Apache Airflow for workflow orchestration.
Knowledge of dbt (Data Build Tool) for modern data transformations.
Exposure to cloud data platforms or hybrid data architectures.
Key Competencies
Strong analytical and problem-solving skills.
Ability to work with large-scale enterprise data environments.
Excellent collaboration and communication skills.
Ability to manage multiple priorities in a fast-paced environment.
Commitment to continuous learning and technology innovation.
Estimated Rates
Estimated Min Rate : $55.00
Estimated Max Rate : $72.00
What’s In It for You?
Yoh is an equal opportunity employer. Benefits eligibility is in accordance with applicable laws and client requirements. Benefits include: Medical, Prescription, Dental & Vision; Health Savings Account (HSA); Life & Disability Insurance; MetLife Voluntary Benefits; Employee Assistance Program (EAP); 401K; Direct Deposit & weekly ePayroll; Referral Bonus Programs; Certification and training opportunities.
Notes
Note: Any pay ranges displayed are estimations. Actual pay is determined by experience and qualifications. All qualified applicants are welcome to apply. Yoh, a Day & Zimmermann company, is an Equal Opportunity Employer. For accommodations in the application process, visit https://www.yoh.com/applicants-with-disabilities.
#J-18808-Ljbffr