143 applicants

Company

Original Job Post

AbbVie · 3 days ago

Oracle Developer

North Chicago, IL

Full-time

Onsite

Entry, Mid Level

3+ years exp

Wonder how qualified you are to the job?

Maximize your interview chances

BiotechnologyHealth Care

H1B Sponsorship

Comp. & Benefits

Insider Connection @AbbVie

Discover valuable connections within the company who might provide insights and potential referrals, giving your job application an inside edge.

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 a variety of internal IT disciplines (i.e. DBAs, architects, data scientists, infrastructure teams, etc.).

Responsible for maintaining cloud knowledge & exposure in AWS, Azure & GCP.

Qualification

Find out how your skills align with this job's requirements. If anything seems off, you can easily click on the tags to select or unselect skills to reflect your actual expertise.

ETLData ModelingUnix Shell ScriptingPythonJavaBusiness IntelligenceStatisticsAgileOracle SQLPL/SQLXMLJSONGitHubAWSMicrosoft Team Foundation Server

Required

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

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

Benefits

Paid time off (vacation, holidays, sick)

Medical/dental/vision insurance

401(k)

Short-term and long-term incentive programs

Company

AbbVie

Glassdoor

3.9

AbbVie is a pharmaceutical company that discovers, develops, and markets medicines.

Founded in 2013

North Chicago, Illinois, USA

10,001+ employees

http://www.abbvie.com

H1B Sponsorship

AbbVie has a track record of offering H1B sponsorships. Please note that this does not guarantee sponsorship for this specific role. Below presents additional info for your reference. (Data Powered by US Department of Labor)

Distribution of Different Job Fields Receiving Sponsorship

Trends of Total Sponsorships

2023 (155)

2022 (299)

2021 (194)

2020 (197)