ODI Developer

job summary:
Seeking a highly skilled and experienced Sr. ODI Developer to join the team. The ideal candidate will possess expertise in a range of technologies, including ODI (Oracle Data Integrator), Oracle Data Warehouse, Linux, Python scripting. As a Data Engineer, you will play a pivotal role in designing, developing, and maintaining data solutions.

location: Boston, Massachusetts
job type: Contract to Perm
salary: $65 - 70 per hour
work hours: 8am to 5pm
education: Bachelors


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.

qualifications:
- Degree in Computer Science, Engineering or related technical area

- 7+ years of extensive hands-on experience in ODI, Oracle Datawarehouse, Oracle PL/SQL, Linux, Python scripting, and ODI admin module (ODI Agent setup, logs configuration, certificate installation).

- Must have experience in building Pl/SQL queries for Oracle Server (incl. stored procedures, functions...) and must understand basic principles of data modeling

- Excellent collaborative and communication skills, particularly in high-stress situations

- Experience with scripting Python and Linux scripting, CLE, networking fundamentals (API, IP/ports, SFTP/FTP connectivity)

- High proficiency in development practices: unit testing, Continuous Integration (CI/CD), refactoring, clean code

- Experience with Bitbucket/GIT source control management

- Problem solving skills, able to determine upcoming risks & issues and address them accordingly.

- Ability to interpret and troubleshoot applications using logs.

- Pro-active approach and good communication skills.

- Experience with agile methodologies (Scrum, Kanban) and tools (Jira)

Equal Opportunity Employer: Race, Color, Religion, Sex, Sexual Orientation, Gender Identity, National Origin, Age, Genetic Information, Disability, Protected Veteran Status, or any other legally protected group status.

At Randstad Digital, we welcome people of all abilities and want to ensure that our hiring and interview process meets the needs of all applicants. If you require a reasonable accommodation to make your application or interview experience a great one, please contact [email protected].


Pay offered to a successful candidate will be based on several factors including the candidate's education, work experience, work location, specific job duties, certifications, etc. In addition, Randstad Digital offers a comprehensive benefits package, including: medical, prescription, dental, vision, AD&D, and life insurance offerings, short-term disability, and a 401K plan (all benefits are based on eligibility).

This posting is open for thirty (30) days.

It is unlawful in Massachusetts to require or administer a lie detector test as a condition of employment or continued employment. An employer who violates this law shall be subject to criminal penalties and civil liability.