Job Information
NANOARK TECHNOLOGY LLC ETL ODI Developer in Eden Prairie, Minnesota
As ODI Developer, create SSIS Packages to read the data from PI Systems and load into Oracle Landing area. Create Oracle Stored Procedures to move the data from Landing to Staging with partition exchange. Create Oracle Procedures to calculate aggregations on stage data and load into curated tables. Create ODI Procedures and Packages to run the oracle procedures daily using ODI Load Plan. Create C# Scripting to update the log entries in the SSIS Package. Create python script to read the API data from the PI Systems and load into Oracle Landing tables. Use JIRA tool effectively to maintain project scope, to track the progress of the tasks, all the development activities. Work under supervision. Travel and/or relocation to unanticipated client sites throughout USA is required.
