SQL / DB2 WebQuery Conversion Report Developer

Location Irvine, California 92619
Date Posted May 29, 2022
Job ID 6669
Employment Type Contract
Pay rate $40 /hour

#6669

Great opportunity to work as an IBM Web Query Analyst/Developer for a company that has a presence in North and South America for 15 plus years being in business.

Location is in the Costa Mesa, CA area.

Position will be responsible for evaluation of SQL statements and conversion into IBM DB2 WebQuery as prompted reports. This effort is required for a project initially. But there will be need to provide ongoing support to various user groups i.e., Service Warranty, Finance, Legal, Call Center and Parts. This support will require development of additional queries for users and setting them up in IBM DB2 Web Query.
Prior experience with above mentioned user groups for query development would be a big plus.

Position requirements:
Strong knowledge of SQL
Strong knowledge of IBM DB2 WebQuery application
Strong knowledge of IBM AS400 DB2 (stored procedures, tables/views)

IBM DB2 WebQuery conversion will range from easy, medium and complex:

(EASY)
Generally, less than 10 lines.
Contains joins 3 or less tables.
Uses simple summary functions (SUM, COUNT).
Uses simple filters prompted fields (EQUAL TO).

(MEDIUM)
Contains joins of 3+ tables.
Contains derived fields (sub select with correlated fields).
Contains advanced filters prompted fields (NUMBER RANGES, TEXT STRING SEARCH).

(COMPLEX)
Contains complex CTE - Common Table Expressions
Contains SQL DATE functions for date calculations AND prompting DATE fields.
Contains Summary functions Group By AND summary field prompting.

If qualified and interested in this opportunity, please reply to JO#6669 along with a copy of your updated resume.

#MantekPriority

Apply For This Job

  • Hidden
  • MM slash DD slash YYYY
  • Please enter a number
  • Accepted file types: doc, docx, pdf, xls, xlsx, ppt, pptx, Max. file size: 200 MB.
  • Accepted file types: doc, docx, pdf, xls, xlsx, ppt, pptx, Max. file size: 200 MB.
  • Accepted file types: doc, docx, pdf, xls, xlsx, ppt, pptx, jpg, jpeg, Max. file size: 200 MB.
Scroll to Top