ETL/ODI Developer

Role ETL/ODI Developer

Location Chicago, IL (remote)

Duration 12 months

Must have strong experience ETL Tools, Oracle Data Integrator (1-5 years)

Must have strong experience Oracle SQL, PL/SQL (1-5 years)

Should have strong understanding in BI/data warehouse analysis, design, development & test experience.

Should be able to design, develop and deploy ODI mappings, packages & scenarios.

Experience in writing complex queries, Stored Procedures in Oracle SQL and Oracle PL/SQL

Deep understanding of dimensional data modeling techniques

Experience on working with ODI performance optimization.

Good Team Player

Strong Communication skills

Responsibilities:

Formulates and defines system scope and objectives through research and fact-finding to design, develop, modify, or integrate moderately complex information systems. Devises or modifies application systems and procedures to optimize functional requirements including capacity, operating time, response time, and form of desired results. Designs, codes, tests, debugs, and documents programs, subroutines, and scripts. May serve one or more project team roles, such as project lead, business systems analyst, or technical lead, for small to medium efforts. Competent to work on most phases of applications systems analysis and programming activities. Maintains technical skill set for software languages, databases, platforms, operating systems, utilities and networks needed to support work assignments. Assists in preparing and maintaining application design document. Responds to system failures and performance events by taking appropriate measures to reduce system downtime and eliminate recurrence of problems. May conduct presentations to provide end users with knowledge to maximize their use of developed systems. Provides services to multiple concurrent project, project teams or management staff. Provides guidance and suggestions to less-experienced programmers.

Job Type: Contract

Salary: $70.00 - $75.00 per hour

Experience level:

• 11+ years

Schedule:

• 8 hour shift

Experience:

• ETL Tools, Oracle Data Integrator: 6 years (Preferred)
• Oracle SQL, PL/SQL: 6 years (Preferred)
• BI/data warehouse analysis design, development & test: 4 years (Preferred)

Work Location: On the road