Oracle Developer - AbbVie

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 www.abbvie.com. Follow @abbvie on X, Facebook, Instagram, YouTube and LinkedIn.

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.

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 https://careers.abbvie.com/en. Refer to Req ID: REF26014H. 

----------------------------------------------------------------------------

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.