Oracle Developer

    • Abbvie
  • North Chicago, IL
  • Posted 44 days ago | Updated 10 hours ago

Overview

On Site
Full Time

Skills

Oracle
IMPACT
Immunology
Neuroscience
Facebook
YouTube
LinkedIn
Data quality
Design
Analytical skill
Performance tuning
Informatica
Cloud computing
Microsoft Azure
Google Cloud Platform
Google Cloud
Computer science
Information Technology
Data warehouse
Extract
transform
load
Database
PostgreSQL
Teradata
Data modeling
Data marts
Toad
ERwin
SQL
Shell
Python
Java
Scripting
Data processing
Reporting
Data
Business intelligence
Qlikview
IBM Cognos
TIBCO Spotfire
Statistics
SAS
R
Software development
Agile
PL/SQL
Unix
Shell scripting
XML
JSON
Version control
GitHub
Amazon Web Services
Microsoft
Microsoft TFS
Oracle Linux
Insurance
Innovation
Policies

Job Details

Company Description

AbbVie's mission is to discover and deliver innovative medicines and solutions that solve serious health issues today and address the medical challenges of tomorrow. We strive to have a remarkable impact on people's lives across several key therapeutic areas - immunology, oncology, neuroscience, and eye care - and products and services in our Allergan Aesthetics portfolio. For more information about AbbVie, please visit us at Follow @abbvie on X, Facebook, Instagram, YouTube and LinkedIn.

Job Description

Key Responsibilities

  • Design & develop data warehouse applications & ETL jobs utilizing databases such as Oracle, SQL Server, No SQL, Postgres, Teradata, etc.
  • Responsible for understanding end-to end operational data warehouses, including system integrations, data quality & harmonization rules, understanding of downstream information.
  • Design data model for data marts & warehouses using TOAD, Erwin data modeler & SQL Developer tools.
  • Utilize advanced analytical SQL functions and performance tuning SQL queries.
  • Develop Unix shell scripts, Python & Java scripts for file/data processing activities.
  • Responsible for reporting & visualizing data using business intelligence tools such as QlikView, Cognos, Spotfire, etc., & using statistics coding tools (e.g. SAS, R, etc.).
  • Employ experience in developing & building enterprise data warehouse by ETL jobs using PL/SQL, Informatica.
  • Employ software development experience following Agile models & utilizing tools such as Oracle SQL, PL/SQL, Unix Shell Scripting, XML, & JSON.
  • Employ experience using version control systems such as GitHub, AWS CodeCommit, & Microsoft Team Foundation Server.
  • Act as a dedicated team player & interface with stakeholders from variety of internal IT disciplines (i.e. DBAs, architects, data scientists, infrastructure teams, etc.).
  • Responsible for maintaining cloud knowledge & exposure in AWS, Azure & Google Cloud Platform.

Qualifications

Must possess a Bachelor's degree or foreign academic equivalent in Computer Science, Information Technology or a highly related field of study with at 3 years of related experience in the following:

  1. designing and developing data warehouse applications & ETL jobs utilizing databases such as Oracle, SQL Server, No SQL, Postgres, Teradata, etc.;
  2. designing data model for data marts & warehouses using TOAD, Erwin data modeler & SQL Developer tools;
  3. developing Unix shell scripts, Python & Java scripts for file/data processing activities;
  4. reporting & visualizing data using business intelligence tools such as QlikView, Cognos, Spotfire, etc., & using statistics coding tools (e.g. SAS, R, etc.);
  5. software development experience following Agile models & utilizing tools such as Oracle SQL, PL/SQL, Unix Shell Scripting, XML, & JSON; &
  6. version control systems such as GitHub, AWS CodeCommit, & Microsoft Team Foundation Server.


Apply online at Refer to Req ID: REF26014H.

Additional Information

We offer a comprehensive package of benefits including paid time off (vacation, holidays, sick), medical/dental/vision insurance and 401(k) to eligible employees. This job is eligible to participate in our short-term and long-term incentive programs.

AbbVie is committed to operating with integrity, driving innovation, transforming lives, serving our community and embracing diversity and inclusion. It is AbbVie's policy to employ qualified persons of the greatest ability without discrimination against any employee or applicant for employment because of race, color, religion, national origin, age, sex (including pregnancy), physical or mental disability, medical condition, genetic information, gender identity or expression, sexual orientation, marital status, status as a protected veteran, or any other legally protected group status.
Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.