Previous Job
Previous
Oracle Developer
Ref No.: 18-05740
Location: Chicago, Illinois
Position Type:Contract
Pay Rate : $ 700.00 - 750.00 /Day
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