The position works with Enterprise Architects/Data Architects/Business Units to design, develop, test and implement complex mappings and workflows for multiple business units using Informatica and Oracle Technologies.
Designs and develops Informatica mappings within the framework of the warehouse architecture set by the Data Architects.
Implements complex ETL code using Informatica, PL/SQL, Oracle Workflows and Shell Scripting.
Develops and executes test plans to ensure that the ETL process fulfills data requirements.
Assists in Data Analysis and Data Profiling activities
Provides day-to-day support for operational data warehouse environment.
Ensures compliance with standard software development practices, processes and enterprise standards.
Communicates project/issue status in a reliable and accurate manner through appropriate tools and processes.
Works within IT team to follow the full lifecycle development process working with development and technical operations.
Mentors and helps to develop more junior-level developers.
To perform this job successfully, an individual must be able to perform each essential duty satisfactorily. Below are the minimum requirements of the education, experience, knowledge, and skills required to competently perform in this position. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.
Bachelor’s degree in Computer Science or equivalent experience required.
Three or more years of professional software development experience.
Advanced skills using Informatica.
Experience developing PL/SQL packages and procedures.
Proven knowledge of SQL, PL/SQL and Oracle 10g.
Experience working with dimensional modeling.
Experience developing shell scripts and process monitoring in a Unix environment.
Experience analyzing complex source systems and data structures.
Demonstrated ability to deliver software projects of high complexity and risk.
Strong knowledge of systems development life cycle.
Experience in an operational environment.
Strong inter-personal skills and ability to communicate information clearly, concisely, and effectively both orally and in writing, and be comfortable working in a collaborative, team-centric environment.
We are proud to be an EEO employer M/F/D/V. We maintain a drug-free workplace and perform pre-employment substance abuse testing. Thank you for applying for this outstanding opportunity today.
Who We Are:
About DeVry University
Founded in 1931, DeVry University is one of the largest, private sector universities in North America, with more than 76,000 students enrolled in the United States and Canada. The university’s mission is to foster student learning through high-quality, career-oriented education integrating technology, business, science and the arts. With more than 90 locations, DeVry University delivers practitioner-oriented undergraduate and graduate degree programs onsite and online that meet the needs of a diverse and geographically dispersed student population. Home to five colleges of study, including Business & Management, Engineering & Information Sciences, Health Sciences, Liberal Arts & Sciences, and Media Arts & Technology, DeVry University’s outstanding faculty members, work in the fields that they teach, providing students with real-world experiences that prepare them for high-growth careers.
DeVry University is institutionally accredited by The Higher Learning Commission of the North Central Association of Colleges and Schools, www.ncahlc.org. DeVry University, a part of DeVry Education Group (NYSE: DV), is based in Downers Grove, IL. For more information about DeVry University, find us on Twitter @DeVryUniv, Facebook /DEVRYUNIVERSITY or visit newsroom.devry.edu.
Join Our Talent CommunityHERE
If you are an Alumnus of the DeVry Education Group institutions, please log in to our Alumnus page to apply for opportunities.
If you are a current colleague of any of DeVry Education Group's institutions, please log in to the The DeVry Commons to apply for internal opportunities. Please note that only current employees of DeVry Education Group will be able to log in using this link.