Job Details

Email to Friend Save Back

Oracle Developer

CHICAGO-60603, IL, US
09/12/2018

-

Required Skills

Linux

Company

Infinity Consulting Solutions, Inc

Experience

Job Description

Skills:

Extensive experience with designing, developing, implementing, and maintaining complex relational database and data warehouse database applications

Extensive knowledge of /experience with analyzing large and complex dataset and quickly
resolve all issues with business

Extensive experience with version control and continuous delivery

Business knowledge of financial data warehouse data model with emphasis on business data relationships.

Technical Requirements:

10 + year’s hands-on experience of Oracle (including 11g, 12g) environment.

8+ years of hands on PL/SQL development experience with strong aptitude for enhancing and automating queries (advanced T-SQL) from various data sources such as relational databases, data warehouse or flat files.

8+ years of hands on experience in Oracle performance tuning - analyzing query plans and query tuning, partitioning, optimizer hints. Strong knowledge on Oracle Database administration issues (i.e. schema, user, and security).

Extensive experience with designing, implementing and tuning ETL processes involving large amounts of data, stored procedures and triggers. Experience using REF cursors, collections, DBMS packages.

Oracle Data Warehouse/Data Mart experience, strong knowledge with large database development and other RDBMS including SQL Server. Experience with Oracle RAC and/or
Exadata a major plus.

Hands-on experience with job scheduling tools such as UC4.

Extensive knowledge of /experience with Tableau and its advanced features a big plus

Working knowledge of UNIX, Linux and Windows is essential

Experience with version control and automatic deployment using tools like GIT, Jenkins, Liquibase, XL-Deploy

Excellent written and verbal communications skills, ability to present and explain technical information

Experience with Java coding and application development with SDLC a major plus

Experience and able to work with Agile environment and drive projects forward within team setting

Must be organized, detail-oriented, self-motivated, disciplined, professional, and a team player to multiple tasks at one time, in a fast pace environment handling multiple demands