> Markdown version of [/jobs/ext/3819230-consulting-application-developer](https://www.wearedevelopers.com/jobs/ext/3819230-consulting-application-developer). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md). --- # Consulting Application Developer - **Company:** Rutgers University - **Location:** New Brunswick, NJ, United States - **Experience:** Expert - **Contract:** Permanent contract - **Skills:** Application Programming Interfaces (APIs), Data Analysis, Application Integration Architecture, Software Applications, Audit Trail, Automation of Tests, Cloud Computing, Information Systems, Databases, Continuous Integration, Data Integration, Extract Transform Load (ETL), Data Security, Data Warehousing, Relational Databases, Database Queries, Dimensional Modeling, Data Intelligence, JSON, Python (Programming Language), Oracle Data Service Integrator, Oracle (Applications), Performance Tuning, Query Optimization, Runbook, PL-SQL, Oracle Fusion Middleware, Extensible Markup Language (XML), Data Logging, SOAPAPI, Git, Information Technology, People Soft, Enterprise Integration, Data Management, Oracle Analytics Cloud, Oracle Integration, Oracle Cloud Infrastructure, Software Version Control, Data Pipelines, Api Management - **Published:** October 18, 2026 - **Apply:** https://jobs.localjobnetwork.com/apply/add/88641444/1 ## About the Role Minimum Education and Experience * Bachelor's degree in Computer Science, Information Systems, Data Science, or a related field is required. * Seven (7) years of hands-on experience designing, developing, and supporting data integrations/ETL/ELT pipelines in an enterprise environment is required. * Equivalent experience, education and/or training may be substituted for the education requirements. Certifications/Licenses Required Knowledge, Skills, and Abilities * Proficiency with Oracle Data Integrator (ODI) (or comparable enterprise ETL tool such as Informatica) including job orchestration, scheduling, error handling, and restart ability. * Strong SQL skills and demonstrated PL/SQL development experience. * Experience integrating data from multiple sources (cloud applications, relational databases, flat files, and/or APIs) and implementing transformation logic. * Experience developing scripts for automation (Python and/or shell) and working with REST/SOAP APIs (including JSON/XML parsing). * Demonstrated experience implementing data quality controls (validation rules, reconciliation, logging, and monitoring). * Ability to write technical documentation (data mappings, runbooks, operational procedures) and follow change management practices. * Ability to work collaboratively across functional teams and to manage multiple priorities with minimal supervision., * Experience with Oracle Fusion Data Intelligence (FDI)/Fusion Analytics Warehouse (FAW) and/or Oracle Analytics Cloud (OAC) and supporting analytics subject areas. * Experience integrating data from Oracle Fusion applications (e.g., Financials, HCM, SCM) using APIs and/or extract mechanisms. * Experience with Oracle Integration Cloud (OIC) or similar iPaaS technology for application integration and orchestration. * Hands-on experience with ODI administration/topology (agents, load plans, schedules, environments) and production job monitoring/troubleshooting. * Experience with data warehousing and dimensional modeling, including large-volume performance optimization (indexing, partitioning, query tuning). * Experience with version control and modern delivery practices (Git, CI/CD, automated testing) for data/integration code. * Experience implementing monitoring/observability and alerting for data pipelines (logs, dashboards, SLA tracking). * Knowledge of data security and compliance practices (least privilege, credential/secret management, audit logging). * Experience in higher education data domains and institutional reporting practices. Equipment Utilized Physical Demands and Work Environment PHYSICAL DEMANDS: * Standing, sitting, walking, talking or hearing. * No special vision requirements. ## Description Under the direction of the Director of IT, Consulting Application Developer, will be responsible for designing, developing, and supporting enterprise data integration solutions that facilitate the movement of data between Oracle Cloud Fusion Data Intelligence (FDI), Oracle Fusion Applications, on-premises databases and third-party systems. This role focuses on building scalable ETL/data pipelines, developing API integrations, and transforming complex data into reliable datasets for analytics and operational reporting. The position will work closely with project teams implementing new cloud enterprise systems both Oracle and other third parties, to integrate with them to meet data warehouse needs and their use for reporting, both centrally developed and unit self-service reporting. In addition, this role will provide support in migrating legacy on-premises data warehouse environments data into OCI-based architectures and custom schemas within ADW. Also, expanding the data warehouse with additional data across various business and system domains. This position collaborates within the centralized Office of Information Technology (OIT) Data management and Reporting team, across other OIT teams, and with university administrative and campus departments to deliver secure, scalable, and well-governed enterprise data solutions. Among the key duties of this position are the following: * Design, develop, test and maintain ETL/ELT data pipelines (ODI & Hybrid Sources). * Build and support reliable, scalable ETL/ELT pipelines across Oracle Cloud and on-prem systems. * Optimized data movement with minimal latency and high throughput. * Standardized, reusable integration patterns. * Develop ETL/ELT processes using tools such as Oracle Data Integrator (ODI), Oracle Integration Cloud (OIC), Informatica, or custom Python/PLSQL scripts., Working Hours Standard Hours 37.50 Daily Work Shift Work Arrangement Consistent with the current application of Rutgers Policy 60.3.22 or the applicable provisions of relevant collective negotiations agreements, this position may be eligible for a hybrid work arrangement. Flexible work arrangements are not permanent, are subject to change or discontinuation, and contingent on the employee receiving approval in the FlexWork@RU Application System. Union Description HPAE 5094 Payroll Designation PeopleSoft Seniority Unit Terms of Appointment Staff - 12 month Position Pension Eligibility ABP