Job Description :
Oracle Database Developer
Location: Chicago, IL
Duration: CTH

Experienced, self-motivated technical developers who have experience with Oracle SQL and ETL experience are needed to join a new development team in a well-known insurance industry client. Currently, this new development team is implementing an accounting hub (Aptitude) into their environment. You will receive training in a new technology that can help further your career. Your current Oracle SQL database expertise is what we require today. Eight (8) team member positions are available.

Create database objects to represent business events
Write Business Processes / Business Rules
Set up target definitions to match GL and data source requirements
Enforce best technical practices
Set-up development, test and production environments
Manage the process of migrating product related objects from one environment to another
Perform performance analysis and tuning of the processes and database objects
Develop queries and reports as required
Mentoring and knowledge transfer to other staff
Liaise with client DBAs and infrastructure teams on database / UNIX settings
Perform handover, transfer of knowledge to technical development and/or production support staff

Preferred Experience:
Oracle RDBMS development
Development experience on databases, custom SQL Scripts/stored procedures
Technical bias with business awareness
Exposure to Finance or accounting systems, processes and data analysis.
Design and implementation experience on ETL / Data Integration tools (e.g. Informatica, SSIS, IBM Data Stage)
Experienced with the full project life cycle
Proven experience within a fast-paced environment
Demonstrable experience of working in an application development role within a project team environment
Strong influencing and leadership skills
Experience in Data Warehouses / Reporting Data Marts an advantage
Agile/Scrum delivery methodology experience a plus
Experience with designing Financial Systems / Accounting / General Ledger Projects is an advantage

Technical skills:
Database skills: Oracle v12 (complex Joins, encapsulated SQL queries, indexing, nested loops, etc
ETL (Facts, Dimensions), BI
Oracle SQL, XML
Basic Unix
Some exposure to Java, C#, .net or XML is helpful but not required
Accounting Hub or Aptitude Studio exposure is helpful but not required
Data Schema Design

Soft Skills:
Technically minded
Analytical skills
Presentation skills
Exceptional communication skills (written and oral)