Rutgers, The State University of New Jersey, is seeking a Application Developer-ETL Developer for Business Intell & Data Analytics Systems for OIT-Enterprise Application Services. This position provides development and production support for the Business Intelligence infrastructure including data warehouses, data marts, data models, data services, views, and reports. This role requires the skills to create and maintain 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.
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.
Participates with ingesting data from a variety of university data sources.
Adapts and helps lead standard methodoglies for ETL development.
Works with the functional leads and business owners, to design and develop DB views and shell scripts.
Minimum Education and Experience:
Bachelor’s degree in Computer Science, Information Systems or related technology field or a Bachelor’s degree with relevant experience in system design, development.
A minimum of seven (7) years experience in an analytical and programming environment with emphasis on financial or human resources applications, critical business areas and analytics, ERPs, systems design, data modeling.
Required Knowledge, Skills, and Abilities:
Experience with ETL tools such as Informatica and native PL/SQL programming required.
Additional experience with reporting tools such as Tableau, BI Publisher, OTBI preferred.
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 ten (10) years experience required is seven years in an analytical and programming environment with emphasis on financial or human resources applications, critical business areas and analytics, ERPs, 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.
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 and/or Clinical data.
In addition Informatica Power Center, OTBI, BI Publisher, Tableau, Oracle Warehouse Builder and ETL processes.
Posting Number: 20ST0210
Location: Off Campus
Internal Number: 109977
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.