Oracle Developer
- Employer
- AbbVie
- Location
- North Chicago, IL
- Start date
- Sep 23, 2024
View more categoriesView less categories
- Discipline
- Information Technology, Business/Data Analytics, Database Administration, Software Development
- Required Education
- Bachelors Degree
- Position Type
- Full time
- Hotbed
- BioMidwest, Best Places to Work
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 atwww.abbvie.com. Follow @abbvie onX,Facebook,Instagram,YouTubeandLinkedIn.
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 & GCP.
Qualifications
Must possess a Bachelors 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:
- designing and developing data warehouse applications & ETL jobs utilizing databases such as Oracle, SQL Server, No SQL, Postgres, Teradata, etc.;
- designing data model for data marts & warehouses using TOAD, Erwin data modeler & SQL Developer tools;
- developing Unix shell scripts, Python & Java scripts for file/data processing activities;
- reporting & visualizing data using business intelligence tools such as QlikView, Cognos, Spotfire, etc., & using statistics coding tools (e.g. SAS, R, etc.);
- software development experience following Agile models & utilizing tools such as Oracle SQL, PL/SQL, Unix Shell Scripting, XML, & JSON; &
- version control systems such as GitHub, AWS CodeCommit, & Microsoft Team Foundation Server.
Apply online at https://careers.abbvie.com/en. 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 an equal opportunity employer and is committed to operating with integrity, driving innovation, transforming lives, serving our community and embracing diversity and inclusion. It is AbbVies 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.
US & Puerto Rico only - to learn more, visithttps://www.abbvie.com/join-us/equal-employment-opportunity-employer.html
US & Puerto Rico applicants seeking a reasonable accommodation, click here to learn more:
https://www.abbvie.com/join-us/reasonable-accommodations.html
Company
AbbVie’s mission is to discover and deliver innovative medicines 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, eye care, virology, women’s health and gastroenterology, in addition to products and services across its Allergan Aesthetics portfolio. For more information about AbbVie, please visit us at www.abbvie.com. Follow @abbvie on Twitter, Facebook, Instagram, and YouTube.
Stock Symbol: ABBV
Stock Exchange: NYSE
- Website
- http://www.abbvie.com/
- Phone
- 1-800-255-5162
- Location
-
1 North Waukegan Road
North Chicago
Illinois
60064
United States
Get job alerts
Create a job alert and receive personalized job recommendations straight to your inbox.
Create alert