JOB OPENING NOTICE

Posting Date: 8/27/2024

POSITION:         

ETL ODI developer

Fulltime job, 40 hours per week

Pay/Salary: $132,704.00 year.

NUMBER OF OPENINGS:         

5

LOCATION:      

NANOARK TECHNOLOGY LLC

6385 Old Shady Oak Rd, Suite 250, Eden Prairie, MN 55344

JOB DUTIES:  

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.

EDUCATION: 

Bachelor’s degree in Computer Science/ IT/IS/ Engineering (Any) or closely related field with Twelve (12) months of experience in the job offered or as an IT Consultant or Analyst or Programmer or Developer or related field.

EXPERIENCE:     

Experience of Twelve (12) months working on ODI or Oracle Data Integrator is required. Travel and/or relocation is required to unanticipated client sites within USA. International travel is not required. The frequency of travel is currently not known as it depends on the client and project requirement that cannot be currently anticipated. Employer provides Information technology services to various clients in USA and hence implementing projects will require such travel.