ETL ODI developer

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

JOB DUTIES :

As ODI Developer, you will be responsible for the following :

• 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, track the progress of tasks, and all development activities.
• Work under supervision.
• Travel and / or relocation to unanticipated client sites throughout the USA is required.

EDUCATION :

Bachelors degree in Computer Science, IT, IS, Engineering (Any), or a closely related field with twelve (12) months of experience in the job offered or as an IT Consultant, Analyst, Programmer, 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 the USA. International travel is not required. The frequency of travel is currently not known as it depends on the client and project requirements that cannot be currently anticipated. Employer provides information technology services to various clients in the USA, and hence implementing projects will require such travel.

Apply Online

Name

Email ID

A valid email address is required.

Phone

A valid phone number is required.

Attach Resume

We are a leading global technology consulting firm specializing in providing IT solutions and business analytics services to diverse industries and clients worldwide.

#J-18808-Ljbffr