at AbbVie US LLC in North Chicago, Illinois, United States
Job Description
Oracle Developer, AbbVie Inc., North Chicago, IL. Design & develop data warehouse applications & ETL jobs utilizing databases such as Oracle, SQL Server, No SQL, Postgres, Teradata, etc. Responsible for understanding end-toend 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: (i) designing and developing data warehouse applications & ETL jobs utilizing databases such as Oracle, SQL Server, No SQL, Postgres, Teradata, etc.; (ii) designing data model for data marts & warehouses using TOAD, Erwin data modeler & SQL Developer tools; (iii) developing Unix shell scripts, Python & Java scripts for file/data processing activities; (iv) reporting & visualizing data using business intelligence tools such as QlikView, Cognos, Spotfire, etc., & using statistics coding tools (e.g. SAS, R, etc.); (v) software development experience following Agile models & utilizing tools such as Oracle SQL, PL/SQL, Unix Shell Scripting, XML, & JSON; & (vi) version control systems such as GitHub, AWS CodeCommit, & Microsoft Team Foundation Server. Apply online at https://careers.abbvie.com/en & reference REF26014H.
