Oracle/ETL Consultant Job at DONNELLY & MOORE, New York, NY

bzRORUovOHdJclU4T3dkSWNtRUlObWw4dFE9PQ==
  • DONNELLY & MOORE
  • New York, NY

Job Description

Job Title

The primary responsibility for this position is to work on a team that is integrating CGI ARMS software with existing applications. This role includes but not limited to:

  • Working with various vendors and teams to design and develop interfaces to integrate with various applications and databases including Oracle, SQL Server, DB2, Mainframe systems, etc.
  • Learning new technologies and show agility in being able to adapt to project needs as they may change
  • Providing technical support for user acceptance testing
  • Translate business analyst requirements into technical design and implementation
  • Design & Develop complex queries for reports and analysis

Required Skills:

  • Strong experience with SQL, PL/SQL Oracle 11+, SQL Server 2008+, Database Functions, Stored Procedures
  • Experience with business requirement gathering and analysis
  • Understanding of Business Analysis for dimensional data models
  • Experience with ETL development
  • Experience working with ETL and data profiling tools such as Informatica and SSIS
  • Strong knowledge of Oracle Database Performance Tuning
  • Experience with Data Warehousing Modeling concepts
  • Experience with business intelligence solutions
  • Experience with Agile Development methodology
  • Experience with systems analysis, documentation and specification writing
  • The candidate must be focused, hard-working and willing to perform analysis at both high and low levels
  • Ability to present information in a clear and logical manner is required
  • He or she must have strong communication and interpersonal skills

The following skills will be considered a plus but not required:

  • Understanding Data mining concepts
  • Experience with Data conversions
  • Experience with Cross table data validation
  • Experience integrating with CGI ARM, BizTalk and DB2
  • Experience working with both Distributed and Mainframe applications
  • Experience with Tableau
  • Experience Oracle WebLogic server and WebSphere MQ Server 7+
  • Knowledge of Oracle Business Intelligence Applications 7.9.6.4 a plus
  • Experience working with OBIEE 11+

Job Tags

Similar Jobs

Enhanced Payment Systems

Appointment Setter Job at Enhanced Payment Systems

 ...Appointment Setter Rosemont, IL, United States Internal $ 3,400.00 - 4,600.00 (US Dollar) Appointment Setter About the Job...  ...responsible for helping customers by providing information and setting an appointment for a representative to meet with them. Responsibilities... 

Apple Ford Shakopee

Customer Service Representative Job at Apple Ford Shakopee

Automotive Customer Service RepresentativeCompany: Apple Autos (Top Minnesota Workplace)Compensation: $18.00- $20.00 per hourAre you looking for a company that Supports You and Your Career Goals, Encourages You to Make a Difference, and helps you Champion Your... 

MCI Careers

Call Center Agent (Days) Job at MCI Careers

 ...fastest-growing tech-enabled business services companies in the USA, with a strong call center footprint and operations that extend across multiple countries. We deliver Customer Experience (CX), Business Process Outsourcing (BPO), and Anything-as-a-Service (XaaS) cloud... 

Voyager Express

Class A Dry Van And Flatbed Drivers Class A Job Job at Voyager Express

Class A Dry Van And Flatbed Drivers Class A JobWith Voyager Express' continued growth, we are currently looking for CDL class A flatbed and dry van truck drivers. We have very new equipment (2015 and newer). We have automatic and standard transmissions. We have yards... 

Robert Half

Sr. Staff Accountant Job at Robert Half

 ...Job Description Job Description We are looking for a highly skilled Senior Staff Accountant to join our team in Redlands, California. In this role, you will handle key accounting functions, ensuring accuracy and compliance with financial standards while contributing...