Oracle Developer

2 weeks ago


Hamilton, Ontario, Canada Allergan Full time

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 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 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.


#J-18808-Ljbffr

  • Hamilton, Ontario, Canada Hamilton Health Sciences Full time

    Unit Summary The Population Health Research Institute (PHRI), a joint institute of Hamilton Health Sciences and McMaster University, with over 300 employees working directly with 60 researchers. PHRI conducts clinical research internationally in 102 countries and is a world leader in large, global health and population and health outcomes research. Our...


  • Hamilton, Ontario, Canada Bimbo Bakeries Full time

    Specialist Maintenance Parts and Inventory Bimbo Canada is a market leading producer and distributor of packaged fresh bread and bakery products with brands such as Dempster's, Villaggio, POM, Bon Matin, Ben's, Stonemill, McGavins, Orowheat, Vachon and Takis. Bimbo Canada pursues the goal of creating value by being at the forefront of manufacturing and...

  • Financial Coordinator

    2 weeks ago


    Hamilton, Ontario, Canada TorontoJobs Recruitment Division Full time

    has partnered with a client in the public sector and located in Hamilton to fill their temporary position of Financial Coordinator This position will report to the Director of Finance and Facilities, and has potential to become permanent for the right candidate. JOB RESPONSIBILITIES INCLUDE: Assisting with the preparation and coordination of the annual...

  • Maintenance Planner

    4 weeks ago


    Hamilton, Ontario, Canada Aerotek Full time

    Our client who is a leader in the food and beverage industry is looking for a maintenance planner**Description:**The Maintenance Planner will act as the principal contact for any work that is required and ensures constant communication with the requester within the maintenance department.• Communicates between all facets of a 24/7 manufacturing environment...


  • Hamilton, Ontario, Canada Bimbo Bakeries Full time

    Specialist Maintenance Parts and Inventory req39617Employment Type: RegularLocation: HAMILTON,ON Bimbo Canada is a market leading producer and distributor of packaged fresh bread and bakery products with brands such as Dempster's, Villaggio, POM, Bon Matin, Ben's, Stonemill, McGavins, Orowheat, Vachon and Takis. The company operates 16 bakeries and employs...

  • Maintenance Planner

    1 month ago


    Hamilton, Ontario, Canada Aerotek Full time

    Our client who is a leader in the food and beverage industry is looking for a maintenance planner**Description:**The Maintenance Planner will act as the principal contact for any work that is required and ensures constant communication with the requester within the maintenance department.• Communicates between all facets of a 24/7 manufacturing environment...


  • Hamilton, Ontario, Canada Johnson Controls International Full time

    Unleash your potential with the Johnson Controls team:As a global leader in smart, healthy and sustainable buildings, our mission is to reimagine the performance of buildings to serve people, places and the planet. Join our winning team and pave the way for a bright future. With our extensive reach across various industries worldwide, our teams are uniquely...


  • Hamilton, Ontario, Canada Johnson Controls International Full time

    Unleash your potential with the Johnson Controls teamAs a global leader in smart, healthy and sustainable buildings, our mission is to reimagine the performance of buildings to serve people, places and the planet. Join our winning team and pave the way for a bright future. With our extensive reach across various industries worldwide, our teams are uniquely...


  • Hamilton, Ontario, Canada City of Hamilton Full time

    About the City of HamiltonContribute to the City of Hamilton, one of Canada's largest cities - home to a diverse and strong economy, an active and inclusive community, a robust cultural and dining scene, hundreds of kilometres of hiking trails and natural beauty just minutes from the downtown core, and so much more. Join our diverse team of talented and...


  • Hamilton, Ontario, Canada Stryker Corporation Full time

    Why join Stryker?:Our total rewards package offering includes bonuses, healthcare, insurance benefits, retirement programs, wellness programs, as well as service and performance awards - not to mention various social and recreational activities, all of which are location specific.Know someone at Stryker?:Who we want-Curious learners. People who seek out...


  • Hamilton, Ontario, Canada Allergan Full time

    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...


  • Hamilton, Ontario, Canada Stryker Group Full time

    Why join Stryker?We are proud to be named one the World's Best Workplaces and a Best Workplace for Diversity by Fortune Magazine Learn more about our award-winning organization by visiting Our total rewards package offering includes bonuses, healthcare, insurance benefits, retirement programs, wellness programs, as well as service and performance awards –...

  • Data Analyst

    2 weeks ago


    Hamilton, Ontario, Canada City of New York Full time

    Under the direction of the Executive Vice President for Real Estate Development, the Data Analyst will play an important role in executing NYCHA's ongoing efforts to recapitalize and rehabilitate its stock of public housing apartments. The Data Analyst's quantitative work will be used to inform strategy and enable execution of key initiatives. The Data...

  • Shipping Supervisor

    2 weeks ago


    Hamilton, Ontario, Canada Bimbo Canada Full time

    Shipping Supervisorreq34674Employment Type: RegularLocation: HAMILTON,ON_ Bimbo Canada is a market leading producer and distributor of packaged fresh bread, bakery and snacking products with brands such as Dempster's, Villaggio, POM, Bon Matin, Ben's, Stonemill, McGavins, Oroweat, Vachon and Takis. The company operates 16 bakeries and employs approximately...


  • Hamilton, Ontario, Canada St. Joseph's Healthcare Hamilton Full time

    Position Details:Posting #: 27678Department:DS - Clinical ApplicationsEmployee Type:Regular, Full TimeIf Temporary, Number of Weeks:Union:Non-UnionOpenings Remaining:1Schedule:Work Days: Monday to FridayTime of Day: Days, Stand-byShift: 7.5 hourThis position may be scheduled at any of the following sites: Hybrid - On-site/RemoteApplication Dates:Opening...


  • Hamilton, Ontario, Canada Allergan Full time

    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...

  • Senior Demand Planner

    2 weeks ago


    Hamilton, Ontario, Canada Stryker Full time

    As a member of our Supply Chain team, you will make a daily impact on the lives of others. Apply today and you will get a chance to work with high-functioning, driven people who all have the same mission of making healthcare better. Plus, we have an award-winning culture and were recently named one of the World's Best Workplace by Fortune Who we...


  • Hamilton, Ontario, Canada Allergan Full time

    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...


  • Hamilton, Ontario, Canada City of Hamilton Full time

    SUMMARY OF DUTIES The position requires a strong background in GIS, 3D modelling and visualization to assist with the development of the City's 3D model and analysis. Reporting to the Coordinator, Information Systems & Cartography Planning, the GIS 3D Model and Visualisation Specialist is responsible for developing the City's 3D model as well as...


  • Hamilton, Ontario, Canada Canonical - Jobs Full time

    The role of a Partner Marketing Manager at CanonicalCanonical is looking for a partner marketing manager who will be responsible for developing Canonical co-marketing relationships with silicon vendors (AMD, ARM, Intel, Qualcomm, Mediatek, NVIDIA, ...). Canonical partners with the leading companies in technology across public cloud (Amazon Web Services,...