Consulting Application Developer

Rutgers University; New Brunswick (NJ); Hybrid; USD 122,000 - 176,000; Full time

Benefits offered by this job

Medical, dental and vision coverage

Paid vacation and holidays

Retirement benefits (defined contrib.)

Educational benefits

Life insurance

Job summary

Rutgers University is seeking a Consulting Application Developer to design, build, and support enterprise data integration solutions. You will create scalable ETL/ELT pipelines moving data between Oracle Cloud Fusion Data Intelligence, Fusion applications, on-prem databases, and third-party systems for analytics and reporting.

You will work across teams to migrate legacy data warehouses to OCI-based architectures and expand the data warehouse with new data domains, while ensuring security and

Qualifications

• 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.

Responsibilities

• 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 ODI, OIC, Informatica, or Python/PLSQL scripts.

Skills

SQL

PL/SQL

REST APIs

Python

Shell scripting

Data quality controls

Documentation

collaborative work

Education

Bachelor's degree in Computer Science, Information Systems, Data Science

Tools

Oracle Data Integrator (ODI)

Informatica

Oracle Integration Cloud (OIC)

ODI administration/topology

Oracle Fusion Data Intelligence (FDI)

Fusion Analytics Warehouse (FAW)

Oracle Analytics Cloud (OAC)

Job description

Position Details

Recruitment/Posting Title: Consulting Application Developer

Job Category: Staff & Executive - Healthcare

Department: Enterprise Application Service

Overview: Rutgers, The State University of New Jersey, is a leading national research university and the State of New Jersey's preeminent, comprehensive public institution of higher education. As one of the largest employers in the State of New Jersey, Rutgers University is committed not only to the students and the State that we serve, but also to the faculty and staff who work on our campuses. For two consecutive years, Rutgers is ranked on Forbes' list of America's Best Large Employers. Rutgers holds #64 of 500 employers and is the #1 New Jersey employer on the publication's 2023 list. Rutgers' commitment to its employees includes maintaining and fostering a safe, diverse, and respectful workplace environment, creating employment opportunities for our nation's military veterans, and ensuring accessibility and accommodation for individuals with disabilities.

Posting Summary: Rutgers, The State University of New Jersey, is seeking a Consulting Application Developer in the Enterprise Applications and Research Computing (EARC) - Data Management within the Office of Information Technology (OIT). 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.

• 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.

FLSA: Exempt

Grade: 37S

Minimum Salary: 121608.000

Mid Range Salary: 147221.000

Maximum Salary: 175737.000

Offer Information: The final salary offer may be determined by several factors, including, but not limited to, the candidate's qualifications, experience, and expertise, and availability of department or grant funds to support the position. We also take into consideration market benchmarks, if and when appropriate, and internal equity to ensure fair compensation relative to the university's broader compensation structure. We are committed to offering competitive and flexible compensation packages to attract and retain top talent.

Benefits: Rutgers provides a comprehensive benefits package to eligible employees. The specific benefits vary based on the position and may include:

• Medical, prescription drug, and dental coverage
• Paid vacation, holidays, and various leave programs
• Competitive retirement benefits, including defined contribution plans and voluntary tax‑deferred savings options
• Employee and dependent educational benefits (when applicable)
• Life insurance coverage
• Employee discount programs

Position Status: Full Time

Standard Hours: 37.50

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

Terms of Appointment: Staff - 12 month

Position Pension Eligibility: ABP

Qualifications

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.

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.

Preferred Qualifications:

• 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.

Physical Demands and Work Environment

PHYSICAL DEMANDS:

• Standing, sitting, walking, talking or hearing.
• No special vision requirements.

WORK ENVIRONMENT:

• Office environment.
• Moderate Noise.

Posting Details

Posting Number: 26ST1991

Regional Campus: Rutgers Biomedical and Health Sciences (RBHS)

Home Location Campus: Off Campus

City: Somerset

State: NJ

Pre-employment Screenings

All offers of employment are contingent upon successful completion of all pre-employment screenings.

Immunization Requirements

Under Policy 100.3.1 Immunization Policy for Covered Individuals, if employment will commence during Flu Season, Rutgers University may require certain prospective employees to provide proof that they are vaccinated against Seasonal Influenza for the current Flu Season, unless the University has granted the individual a medical or religious exemption. Additional infection control and safety policies may apply. Prospective employees should speak with their hiring manager to determine which policies apply to the role or position for which they are applying. Failure to provide proof of vaccination for any required vaccines or obtain a medical or religious exemption from the University will result in rescission of a candidate's offer of employment or disciplinary action up to and including termination.

Equal Employment Opportunity Statement

It is university policy to provide equal employment opportunity to all its employees and applicants for employment regardless of their race, creed, color, national origin, age, ancestry, nationality, marital or domestic partnership or civil union status, sex, pregnancy, gender identity or expression, disability status, liability for military service, protected veteran status, affectional or sexual orientation, atypical cellular or blood trait, genetic information (including the refusal to submit to genetic testing), or any other category protected by law. As an institution, we encourage all qualified applicants to apply. For additional information please see the Non-Discrimination Statement at the following web address: http://uhr.rutgers.edu/non-discrimination-statement