Consulting Application Developer

Rutgers University; New Jersey; Hybrid; USD 122,000 - 176,000; Full time

Benefits offered by this job

Hybrid work arrangement

Medical benefits

Retirement plan

Educational benefits

Job summary

Rutgers University is seeking a Consulting Application Developer to design, develop, and support enterprise data integration solutions. You will build scalable ETL/data pipelines using ODI and other tools, integrate APIs, and transform data for analytics while collaborating with IT teams and university departments.

The role involves migrating legacy data warehouses to OCI-based architectures, expanding data content, and ensuring data quality and security.

Qualifications

• Experience with enterprise data integration/ETL and ODI or similar tools.
• Strong SQL/PL/SQL development and API integrations (REST/SOAP).
• Automation scripting in Python or shell.

Responsibilities

• Design, develop, and support enterprise data integration solutions across Oracle Cloud Fusion and on-prem systems.
• Build scalable ETL/ELT pipelines and data transformations for analytics and reporting.
• Collaborate with IT teams and university departments to migrate legacy data warehouses and expand content.

Skills

ODI

SQL

PL/SQL

API integrations

Python scripting

Shell scripting

Education

Bachelor's degree in Computer Science, Information Systems, Data Science, or related field

Tools

Oracle Data Integrator (ODI)

Oracle Integration Cloud (OIC)

Informatica

Git

Job description

Rutgers University is hiring a Consulting Application Developer. The role entails designing, developing, and supporting enterprise data integration solutions involving Oracle Cloud Fusion Data Intelligence, on-premises databases, and third-party systems. The developer will build scalable ETL/data pipelines, develop API integrations, and transform data for analytics and reporting while collaborating with IT teams and university departments.

Highlights

• Design, develop, test, and maintain ETL/ELT data pipelines using Oracle Data Integrator (ODI) and hybrid sources.
• Build reliable, scalable data pipelines across Oracle Cloud and on-premises systems, optimized for minimal latency and high throughput.
• Develop ETL/ELT processes using tools such as ODI, Oracle Integration Cloud (OIC), Informatica, and custom Python/PLSQL scripts.
• Support migration of legacy on-premises data warehouse environments to OCI-based architectures and expand data warehouse content.
• Required skills include proficiency in ODI or similar ETL tools, strong SQL and PL/SQL development, API integrations with REST/SOAP, and automation scripting in Python or shell.
• Preferred experience with Oracle Fusion Analytics Warehouse (FAW), Oracle Analytics Cloud (OAC), iPaaS technologies, data warehousing, version control (Git), and data security compliance.
• Minimum qualifications: Bachelor's degree in Computer Science, Information Systems, Data Science, or related field plus seven years of enterprise data integration/ETL experience, or equivalent combination.
• Salary range from $121,608 to $175,737 with flexible compensation depending on qualifications.
• Works within the Enterprise Application Service department in Rutgers' Office of Information Technology collaborating across teams and university departments.
• Full-time exempt position with potential hybrid work arrangement and comprehensive benefits including medical, retirement, and educational benefits.