Rutgers, The State University of New Jersey, is seeking an Application Developer-ETL Developer for Business Intel & Data Analytics Systems for OIT-Enterprise Application Services. This position is under the direction of the Data Architect and provides development and production support for the Business Intelligence infrastructure including data warehouses, data marts, data models, views, and reports. The Application Developer is knowledgeable in reporting tools, decision support systems, data modeling, data design and ETL processing, preferably experienced in Oracle Financial Cloud ERP and/or Oracle HCM.
Among the key duties of this position are the following:
Responsible for analysis, planning, design, development, implementation, and maintenance in support of University central and departmental standardized ETL and report processes as well as integration with both internal and external data partners.
With minimal supervision, this position develops processes for data integrations.
Involved with ingesting data from Oracle Financial Cloud and other university data sources.
Adapts standard methodoglies for ETL development.
Creates the ETL workflows/processes for a myriad of datasources including cloud sources, creating source to target specifications from business requirements and completing development of ETL processes using Oracle PL/SQL, Informatica. OWB or any other ETL tools.
Works with the functional leads and business owners, this position designs and develops DB views and shell scripts.
Minimum Education and Experience:
Requires a bachelor’s degree in computer science, information systems or related technology field or an equivalent combination of education and/or experience.
A minimum of three (3) years experience in an analytical and programming environment with emphasis on financial or human resources applications, business areas and analytics, Oracle Financial Cloud ERP, systems design, data modeling.
Required Knowledge, Skills, and Abilities:
Experience with ETL tools (ex. Informatica) and native PL/SQL programming
Customer service mindset, profession courtesy, respect and consistent positive communications to team members and clients is essential to delivering great work experiences. These behaviors are expected throughout our team.
Experience with data modeling for reporting.
Curiosity and aptitude for leveraging big-data technolgies.
Ability to understand complex, integrated state of the art business intelligence and report data modeling
Ability to understand complex user authentication and data access authorization security models
Excellent written, oral, and interpersonal skills and the ability to foster working relationships with users and peers.
Excellent technical documentation, analytical and research skills
Prefers five (5) years experience in an analytical and programming environment with emphasis on financial or human resources applications, business areas and analytics, Oracle Financial Cloud ERP, systems design, data modeling.
Peoplesoft or Oracle Financial ERP experience, Oracle Application Development Framework (ADF), PLSQL, JAVA programming, File Based Data Import skills, Web Services, and/or PaaS.
Additionally, experience with reporting tools such as Tableau, BI Publisher, OTBI preferred
Posting Number: 19ST3880
Location: Off Campus
Internal Number: 98387
About Rutgers University
Rutgers, The State University of New Jersey, is a leading national public research university and the state's preeminent, comprehensive public institution of higher education. Rutgers is dedicated to teaching that meets the highest standards of excellence; to conducting research that breaks new ground; and to turning knowledge into solutions for local, national, and global communities. As it was at our founding in 1766, the heart of our mission is preparing students to become productive members of society and good citizens of the world. Rutgers teaches across the full educational spectrum: preschool to precollege; undergraduate to graduate and postdoctoral; and continuing education for professional and personal advancement. Rutgers is New Jersey's land-grant institution and one of the nation's foremost research universities, and as such, we educate, make discoveries, serve as an engine of economic growth, and generate ideas for improving people's lives.